pgsql-sql before 2019-11-12 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

May 23, 2019

Thread Author Time
Re: Create function using quote_literal issues Mohamed DIA 10:09

May 28, 2019

Thread Author Time
Alternate methods for multiple rows input/output to a function. RAJIN RAJ K 14:36
Re: Alternate methods for multiple rows input/output to a function. Adrian Klaver 14:59
Re: Alternate methods for multiple rows input/output to a function. Adrian Klaver 17:26

July 4, 2019

Thread Author Time
Error: rows returned by function are not all of the same row type andrey.sychev 09:35

July 12, 2019

Thread Author Time
Would like to know what is the problem in my sql statement Karen Goh 02:04
Re: Would like to know what is the problem in my sql statement Juan C. Olivares 02:11
Would like to know what is the problem in my sql statement David G. Johnston 02:34
Re: Would like to know what is the problem in my sql statement Karen Goh 12:22
Re: Error: rows returned by function are not all of the same row type Ed Behn 15:34

July 14, 2019

Thread Author Time
Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 03:39
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 08:10
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? David G. Johnston 16:40

July 16, 2019

Thread Author Time
Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 06:14
Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 06:17
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Martin Stöcker 06:25
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 08:21
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 08:41
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 08:44
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 08:54
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Thomas Kellerer 08:57
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 09:25
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 09:36
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 09:48
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 11:19
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 12:45
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Steve Midgley 13:32
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 14:10
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 14:19
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 14:28
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 15:02
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 15:21
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 15:44
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? David G. Johnston 16:00
IN vs arrays (was: Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?) Andrew Gierth 16:01

July 18, 2019

Thread Author Time
Ordered Hierarchies. Tim Uckun 02:46
Re: IN vs arrays (was: Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?) Tumasgiu Rossini 08:43
Re: IN vs arrays (was: Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?) Karen Goh 08:54
Fwd: Ordered Hierarchies. Todd Reed 13:45
Re: Ordered Hierarchies. Tony Shelver 16:25
Re: Ordered Hierarchies. Dmitry Ruban 20:58

July 19, 2019

Thread Author Time
Re: Ordered Hierarchies. Tim Uckun 02:19
Re: Ordered Hierarchies. Steve Midgley 08:15
RE: Ordered Hierarchies. Voillequin, Jean-Marc 08:47
Re: Ordered Hierarchies. Tim Uckun 12:38
pg_advisory_lock lock FAILURE / What does those numbers mean (process 240828 waits for ExclusiveLock on advisory lock [1167570,16820923,3422556162,1];)? Alexandru Lazarev 18:15
Re: pg_advisory_lock lock FAILURE / What does those numbers mean (process 240828 waits for ExclusiveLock on advisory lock [1167570,16820923,3422556162,1];)? Laurenz Albe 19:27
Re: pg_advisory_lock lock FAILURE / What does those numbers mean (process 240828 waits for ExclusiveLock on advisory lock [1167570,16820923,3422556162,1];)? Alexandru Lazarev 19:52

July 21, 2019

Thread Author Time
How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 00:58
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 01:25
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 01:31
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 01:48
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 02:00
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 02:07
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 02:20
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? David G. Johnston 02:48
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Holger Jakobs 07:28
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 13:53
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 14:12
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 14:24
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? David G. Johnston 14:54
Fw: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 14:56
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 15:00
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? David G. Johnston 15:06
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 15:10
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 15:13
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 15:23
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 15:37
Fw: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 15:44
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Avin Kavish 16:10
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 16:26
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 16:30
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Scott Ribe 17:30

July 22, 2019

Thread Author Time
How do I alter an existing column and add a foreign key which is a Primary key to a table? David G. Johnston 03:14
Interesting security context issue Erik Brandsberg 20:58

July 23, 2019

Thread Author Time
Implicit typecast behavior Rick Vincent 11:22
AW: Implicit typecast behavior Sonnenberg-Carstens, Stefan 11:29
Re: Implicit typecast behavior Thomas Kellerer 11:46
Re: Implicit typecast behavior Tom Lane 14:31
RE: Implicit typecast behavior Rick Vincent 15:01

July 30, 2019

Thread Author Time
install sample database error Cao, Xiaowei 23:27

July 31, 2019

Thread Author Time
Re: install sample database error Thomas Kellerer 06:16
RE: install sample database error Cao, Xiaowei 16:28
Re: install sample database error Rob Sargent 16:30

Aug. 3, 2019

Thread Author Time
[ECPG] - Help on Dynamic Query using SQLDA with Cursors Rajesh Parameswaran 01:03

Aug. 13, 2019

Thread Author Time
UPDATE command with FROM clause JORGE MALDONADO 18:37
Re: UPDATE command with FROM clause Rob Sargent 21:45
Re: UPDATE command with FROM clause David G. Johnston 22:47

Aug. 19, 2019

Thread Author Time
PLJAVA build failure on postgres docker image Rick Vincent 15:04

Aug. 20, 2019

Thread Author Time
RE: PLJAVA build failure on postgres docker image Rick Vincent 08:38

Aug. 23, 2019

Thread Author Time
Ordering of arrays Mike Martin 10:12
Ordering of arrays Mike Martin 10:14
Re: Ordering of arrays Pavel Stehule 11:53

Aug. 29, 2019

Thread Author Time
libpq: How are result sets fetch behind the scene? Sebastien FLAESCH 16:32
Re: libpq: How are result sets fetched behind the scene? Sebastien FLAESCH 16:39

Aug. 30, 2019

Thread Author Time
Re: libpq: How are result sets fetched behind the scene? Sebastien FLAESCH 13:40
Re: libpq: How are result sets fetched behind the scene? Sebastien FLAESCH 13:55

Sept. 5, 2019

Thread Author Time
Question about WHERE CASE Mike Martin 11:04
Re: Question about WHERE CASE Martin Stöcker 11:42
Re: Question about WHERE CASE Tom Lane 13:46

Sept. 6, 2019

Thread Author Time
A complex SQL query jj08 12:31
Re: A complex SQL query Jānis Pūris 12:56
RE:Re: A complex SQL query jj08 14:35

Sept. 7, 2019

Thread Author Time
How do I enabled Windows 10 to be able to run PSQL etc Karen Goh 12:26
Re: libpq: How are result sets fetched behind the scene? 📎 Christian Barthel 12:43
Re: How do I enabled Windows 10 to be able to run PSQL etc Rob Sargent 14:07
Re: How do I enabled Windows 10 to be able to run PSQL etc Karen Goh 15:04
Re: How do I enabled Windows 10 to be able to run PSQL etc Rob Sargent 15:49
RE:RE:Re: A complex SQL query jj08 18:23
Re: RE:Re: A complex SQL query Victor Yegorov 21:33

Sept. 8, 2019

Thread Author Time
RE:Re: RE:Re: A complex SQL query jj08 02:09
Re: RE:Re: RE:Re: A complex SQL query v_kalees 03:20
Re: How do I enabled Windows 10 to be able to run PSQL etc 📎 Karen Goh 04:11
RE:Re: RE:Re: RE:Re: A complex SQL query jj08 16:12
Re: libpq: How are result sets fetched behind the scene? Tom Lane 19:35

Sept. 9, 2019

Thread Author Time
Re: How do I enabled Windows 10 to be able to run PSQL etc Rob Sargent 02:30
Re: How do I enabled Windows 10 to be able to run PSQL etc 📎 Karen Goh 05:06
Re: How do I enabled Windows 10 to be able to run PSQL etc Steve Midgley 15:07
Re: How do I enabled Windows 10 to be able to run PSQL etc Rob Sargent 15:45

Sept. 10, 2019

Thread Author Time
Re: libpq: How are result sets fetched behind the scene? Sebastien FLAESCH 09:11

Sept. 11, 2019

Thread Author Time
Find and replace Campbell, Lance 20:24
Re: Find and replace Rob Sargent 20:27
Re: Find and replace Campbell, Lance 20:31
Re: Find and replace Tom Lane 20:49

Sept. 12, 2019

Thread Author Time
Re: How do I enabled Windows 10 to be able to run PSQL etc Karen Goh 10:50
Re: How do I enabled Windows 10 to be able to run PSQL etc Steve Midgley 12:07
Looking for technical references on how to set up PostGIS/PostgreSQL for serving MapInfo Desktop application users Shaozhong SHI 12:09
Re: How do I enabled Windows 10 to be able to run PSQL etc Karen Goh 12:17
Re: How do I enabled Windows 10 to be able to run PSQL etc Steve Midgley 12:22
Re: Looking for technical references on how to set up PostGIS/PostgreSQL for serving MapInfo Desktop application users Iuri Sampaio 23:17

Sept. 18, 2019

Thread Author Time
Unexpected behaviour since Windows 1903 Update Koorsen, Andre 11:39

Sept. 19, 2019

Thread Author Time
any alternative to pg-safeupdate for windows 10? john snow 03:47
Re: any alternative to pg-safeupdate for windows 10? john snow 04:00
Re: any alternative to pg-safeupdate for windows 10? Steve Midgley 08:16

Sept. 20, 2019

Thread Author Time
German "umlaut insensitive" query Jakob.Witczak 08:36
Re: German "umlaut insensitive" query Jonathan S. Katz 12:17
Dialog box, passing parameter fails [email protected] 22:20

Sept. 23, 2019

Thread Author Time
Re: Dialog box, passing parameter fails Steve Midgley 00:24
AW: German "umlaut insensitive" query Jakob.Witczak 05:57
RE: Dialog box, passing parameter fails Voillequin, Jean-Marc 06:53

Sept. 24, 2019

Thread Author Time
Re: AW: German "umlaut insensitive" query Peter Eisentraut 07:05
AW: AW: German "umlaut insensitive" query Jakob.Witczak 08:38
RE: AW: German "umlaut insensitive" query Voillequin, Jean-Marc 10:10

Sept. 25, 2019

Thread Author Time
How do I get rid of version 10 Postgresql completely ? Karen Goh 15:03
Fw: How do I get rid of version 10 Postgresql completely ? Karen Goh 15:52
Re: Fw: How do I get rid of version 10 Postgresql completely ? Rob Sargent 16:05

Sept. 26, 2019

Thread Author Time
No enough disk space to launch server [email protected] 20:06

Sept. 27, 2019

Thread Author Time
Transactions in one table JORGE MALDONADO 16:21
Re: Transactions in one table Olivier Gautherot 16:26
Re: Transactions in one table David G. Johnston 16:27
Re: Transactions in one table Rob Sargent 16:41

Oct. 4, 2019

Thread Author Time
Automatically updating a new information column in PostgreSQL Pepe TD Vo 13:26
RE: Automatically updating a new information column in PostgreSQL Voillequin, Jean-Marc 13:49
Re: Automatically updating a new information column in PostgreSQL Tom Lane 13:50
Re: Automatically updating a new information column in PostgreSQL Pepe TD Vo 15:53

Oct. 8, 2019

Thread Author Time
parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..." Marius Andreiana 06:12
Re: parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..." Pavel Stehule 06:32
Re: parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..." Marius Andreiana 07:14
Re: parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..." Pavel Stehule 07:25
Re: parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..." Tom Lane 14:29
Qusetion re regexexp_split_to_array and last occurence Mike Martin 15:48
Question re regexexp_split_to_array and last oc Mike Martin 15:51
Re: Qusetion re regexexp_split_to_array and last occurence David G. Johnston 19:26

Oct. 9, 2019

Thread Author Time
pg_dump compatibility level / use create view instead of create table/rule Alex Williams 01:01
Re: pg_dump compatibility level / use create view instead of create table/rule Alex Williams 01:11
Re: pg_dump compatibility level / use create view instead of create table/rule Tom Lane 05:01
Set FILLFACTOR for primary key Ed Behn 16:36
Re: Set FILLFACTOR for primary key Peter Geoghegan 17:16
Re: pg_dump compatibility level / use create view instead of create table/rule Alex Williams 21:32
Re: pg_dump compatibility level / use create view instead of create table/rule Alex Williams 21:34
Re: pg_dump compatibility level / use create view instead of create table/rule Alex Williams 21:39
Re: pg_dump compatibility level / use create view instead of create table/rule Tom Lane 22:46

Oct. 10, 2019

Thread Author Time
Re: pg_dump compatibility level / use create view instead of create table/rule 📎 Alex Williams 00:24
Re: pg_dump compatibility level / use create view instead of create table/rule Tom Lane 15:20

Oct. 11, 2019

Thread Author Time
Modeling graph data in Postgres? Steve Midgley 09:20

Oct. 16, 2019

Thread Author Time
Save Session? Mike Martin 11:30
Should I add a Index Key in this case ? Karen Goh 11:36
Re: Save Session? William Ivanski 11:36
Re: Should I add a Index Key in this case ? Steve Midgley 15:26
Re: Should I add a Index Key in this case ? Karen Goh 15:47
Re: Should I add a Index Key in this case ? Rob Sargent 16:05

Oct. 17, 2019

Thread Author Time
Re: Save Session? Arni Kromić 07:31
Fwd: Save Session? Arni Kromić 07:33
RE: Save Session? Dave Bolt 10:13

Oct. 21, 2019

Thread Author Time
pgpool-II 4.0 switching over standby to master issue Om Prakash Jaiswal 09:11

Oct. 26, 2019

Thread Author Time
Re: pg_dump compatibility level / use create view instead of create table/rule Tom Lane 19:03
Re: pg_dump compatibility level / use create view instead of create table/rule Andres Freund 20:56
Re: pg_dump compatibility level / use create view instead of create table/rule Tom Lane 21:18

Nov. 7, 2019

Thread Author Time
Using transactions in all CRUD operations JORGE MALDONADO 00:42
Re: Using transactions in all CRUD operations Rene Romero Benavides 00:53
Returned row count doesn't match lines in output file Tchouante, Merlin 17:57
Re: Returned row count doesn't match lines in output file Tom Lane 18:06
Re: Returned row count doesn't match lines in output file Rob Sargent 18:06
Re: Returned row count doesn't match lines in output file Steve Midgley 18:06
RE: Returned row count doesn't match lines in output file Tchouante, Merlin 18:29

Nov. 8, 2019

Thread Author Time
Help with outer joins Tchouante, Merlin 16:55

Nov. 11, 2019

Thread Author Time
RE: Help with outer joins Tchouante, Merlin 15:21
type for storing emails? stan 17:59
Re: type for storing emails? Dmitry Igrishin 18:19
Re: type for storing emails? Rene Romero Benavides 18:29

Browse Archives

Prev | Next