pgsql-sql since 2019-05-02 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 2, 2019

Thread	Author	Time
[No subject]	Mark Teper	17:51

May 3, 2019

Thread	Author	Time
Re: plpython transforms vs. arrays	Tom Lane	02:56
Re: plpython transforms vs. arrays	Jiří Fejfar	04:53

May 4, 2019

Thread	Author	Time
create role/user management	Kirti Adesara	16:38

May 6, 2019

Thread	Author	Time
AW:	Sonnenberg-Carstens, Stefan	08:17
Re: plpython transforms vs. arrays	Mark Teper	09:32
AW: plpython transforms vs. arrays	Sonnenberg-Carstens, Stefan	09:34
Re: create role/user management	Steve Midgley	19:35
Re: create role/user management	David G. Johnston	19:43
Re: create role/user management	Rob Sargent	19:49
Re: create role/user management	Steve Midgley	19:51
Re: create role/user management	David G. Johnston	20:08

May 16, 2019

Thread	Author	Time
XML with nodes	Leandro Carnio	11:50

May 17, 2019

Thread	Author	Time
Table as argument in postgres function	RAJIN RAJ K	13:28
Re: Problem in	Jean-David Beyer	16:09

May 18, 2019

Thread	Author	Time
Re: Problem in	Javin Paul	03:13
Re: Problem in	Charles Sheridan	03:31
getting permission denied error for user2 while proper privileges are present	rajan	04:13
Re: getting permission denied error for user2 while proper privileges are present	Tom Lane	04:46
Re: getting permission denied error for user2 while proper privileges are present	rajan	05:50
Re: getting permission denied error for user2 while proper privileges are present	Tom Lane	15:07
Unsubscribing from list (was: Problem in	David W Noon	15:33
Re: Unsubscribing from list (was: Problem in	David W Noon	16:27
Re: getting permission denied error for user2 while proper privileges are present	rajan	16:35
create index on a jsonb timestamp field?	Larry Rosenman	22:53

May 19, 2019

Thread	Author	Time
Re: create index on a jsonb timestamp field?	Larry Rosenman	00:19
Re: create index on a jsonb timestamp field?	Tom Lane	01:17
Table as argument in postgres function	RAJIN RAJ K	16:00
Re: Table as argument in postgres function	Pavel Stehule	16:20
Re: create index on a jsonb timestamp field?	Larry Rosenman	19:37
Re: create index on a jsonb timestamp field?	Tom Lane	19:55

May 20, 2019

Thread	Author	Time
Re: Table as argument in postgres function	Corey Huinker	05:56
Re: Table as argument in postgres function	Pavel Stehule	06:03

May 21, 2019

Thread	Author	Time
Re: Table as argument in postgres function	Corey Huinker	07:04
Re: Table as argument in postgres function	Pavel Stehule	07:13

May 23, 2019

Thread	Author	Time
Create function using quote_literal issues	Mohamed DIA	09:49
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

Browse Archives

Prev | Next