Quick Links

pgsql-sql since 2019-12-31 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

Dec. 31, 2019

Thread	Author	Time
Whether to use "IN" clause	Mark Williams	10:15

Jan. 3, 2020

Thread	Author	Time
For each statement trigger and update table	Mike Martin	23:09
Re: For each statement trigger and update table	Rene Romero Benavides	23:39
Re: For each statement trigger and update table	Mike Martin	23:55

Jan. 4, 2020

Thread	Author	Time
Re: For each statement trigger and update table	Rene Romero Benavides	00:06
Re: For each statement trigger and update table	Rene Romero Benavides	00:26
Re: For each statement trigger and update table	Mike Martin	00:32
Re: For each statement trigger and update table	Mike Martin	03:45

Jan. 5, 2020

Thread	Author	Time
Re: For each statement trigger and update table	Rene Romero Benavides	01:49
Re: For each statement trigger and update table	Mike Martin	16:10
Re: For each statement trigger and update table	Rene Romero Benavides	19:42

Jan. 6, 2020

Thread	Author	Time
Re: For each statement trigger and update table	Erik Brandsberg	13:53

Jan. 25, 2020

Thread	Author	Time
SQL schema and query optimisation for fast cross-table query execution	Brice André	08:49
RE: SQL schema and query optimisation for fast cross-table query execution	Mike Sofen	13:18

Feb. 25, 2020

Thread	Author	Time
pg_dump fails when a table is in ACCESS SHARE MODE	Viral Shah	15:11
Re: pg_dump fails when a table is in ACCESS SHARE MODE	Rene Romero Benavides	15:36
Re: pg_dump fails when a table is in ACCESS SHARE MODE	Viral Shah	15:45
Re: pg_dump fails when a table is in ACCESS SHARE MODE	Rene Romero Benavides	16:27
Re: pg_dump fails when a table is in ACCESS SHARE MODE	Rene Romero Benavides	18:31
Documentation of the pg_service file	Tim Uckun	20:25
Re: Documentation of the pg_service file	Tom Lane	22:15
Re: Documentation of the pg_service file	Steve Midgley	22:32

Feb. 29, 2020

Thread	Author	Time
min()/max() with BRIN indexes	Wayne	16:50
Re: min()/max() with BRIN indexes	Tom Lane	19:37
Re: min()/max() with BRIN indexes	Wayne	21:40

March 1, 2020

Thread	Author	Time
What is the right syntax for retrieving the last_insert_id() in Postgresql ?	Karen Goh	10:17
Re: What is the right syntax for retrieving the last_insert_id() in Postgresql ?	Pavel Stehule	10:26
Re: What is the right syntax for retrieving the last_insert_id() in Postgresql ?	agharta agharta	11:16

March 3, 2020

Thread	Author	Time
Re: What is the right syntax for retrieving the last_insert_id() in Postgresql ?	Karen Goh	15:50
Re: What is the right syntax for retrieving the last_insert_id() in Postgresql ?	john	16:04
Re: What is the right syntax for retrieving the last_insert_id() in Postgresql ?	Pavel Stehule	16:26
Re: What is the right syntax for retrieving the last_insert_id() in Postgresql ?	Sándor Daku	16:36

March 25, 2020

Thread	Author	Time
Re: min()/max() with BRIN indexes	Bruce Momjian	17:45

April 1, 2020

Thread	Author	Time
FK constraint question	Heinemann, Manfred (IMS)	13:49
Re: FK constraint question	Steve Midgley	15:29

April 5, 2020

Thread	Author	Time
How do CHECK Constraint Function privileges work?	Ruwan Fernando	08:22
Re: How do CHECK Constraint Function privileges work?	David G. Johnston	14:37
Re: How do CHECK Constraint Function privileges work?	Tom Lane	15:42
Re: How do CHECK Constraint Function privileges work?	Ruwan Fernando	15:46
Re: How do CHECK Constraint Function privileges work?	Ruwan Fernando	15:58

April 6, 2020

Thread	Author	Time
Separate volumes	Ed Behn	11:51
Re: Separate volumes	Erik Brandsberg	16:41
Re: Separate volumes	Steve Midgley	17:11
Re: Separate volumes	MichaelDBA	19:30
Re: [External] Re: Separate volumes	Ed Behn	19:36
Re: [External] Re: Separate volumes	Iuri Sampaio	21:40

April 7, 2020

Thread	Author	Time
回复: [External] Re: Separate volumes	Lu Dillon	16:31

April 10, 2020

Thread	Author	Time
Re: 回复: [External] Re: Separate volumes	Bruce Momjian	20:04
Re: 回复: [External] Re: Separate volumes	Erik Brandsberg	20:52
Re: 回复: [External] Re: Separate volumes	Bruce Momjian	21:01
Re: 回复: [External] Re: Separate volumes	Erik Brandsberg	21:26

April 22, 2020

Thread	Author	Time
Re: FK constraint question 📎	Samed YILDIRIM	15:50
Re: FK constraint question	Ashutosh Sharma	16:31

April 23, 2020

Thread	Author	Time
How to sql scripts in a file?	John Zhang	12:42
Fwd: How to sql scripts in a file?	Sándor Daku	13:08
Re: [postgis-users] How to sql scripts in a file?	Giuseppe Broccolo	13:37
Re: [postgis-users] How to sql scripts in a file?	John Zhang	16:08

April 25, 2020

Thread	Author	Time
insert in an array of composite type	Maxime FRYSOU	21:45
Re: insert in an array of composite type	David G. Johnston	22:15
Re: insert in an array of composite type	Tom Lane	22:22

April 26, 2020

Thread	Author	Time
Re: insert in an array of composite type	Maxime FRYSOU	06:57

April 30, 2020

Thread	Author	Time
Re: pg_dump fails when a table is in ACCESS SHARE MODE	Viral Shah	22:15

May 1, 2020

Thread	Author	Time
Re: pg_dump fails when a table is in ACCESS SHARE MODE	Rene Romero Benavides	02:58
Table/log file name which store the queries which got executed in last 1 month	Gaurav Tomar	03:19
Re: Table/log file name which store the queries which got executed in last 1 month	Rob Sargent	03:33
Re: Table/log file name which store the queries which got executed in last 1 month	Rene Romero Benavides	03:34
Re: Table/log file name which store the queries which got executed in last 1 month	legrand legrand	07:55
Re: pg_dump fails when a table is in ACCESS SHARE MODE	Viral Shah	13:53
Re: pg_dump fails when a table is in ACCESS SHARE MODE	Tom Lane	14:18

May 2, 2020

Thread	Author	Time
Re: pg_dump fails when a table is in ACCESS SHARE MODE	Viral Shah	01:06
Re: pg_dump fails when a table is in ACCESS SHARE MODE	David G. Johnston	01:24

May 4, 2020

Thread	Author	Time
Re: Table/log file name which store the queries which got executed in last 1 month	Craig Jackson	15:36

May 11, 2020

Thread	Author	Time
Exporting modifications to a table as XML/JSON	ertan.kucukoglu	21:17
Re: Exporting modifications to a table as XML/JSON	David G. Johnston	23:37
Re: Exporting modifications to a table as XML/JSON	David G. Johnston	23:51

May 20, 2020

Thread	Author	Time
Postgres stored procedure errs while parsing JSONB object	Igor Shmukler	14:39
Re: Postgres stored procedure errs while parsing JSONB object	David G. Johnston	15:04
Re: Postgres stored procedure errs while parsing JSONB object	Igor Shmukler	15:10

May 29, 2020

Thread	Author	Time
left outer join with count	Gary Stainburn	16:09

May 30, 2020

Thread	Author	Time
Re: left outer join with count	Gábor SZŰCS	04:43
Re: left outer join with count	Gary Stainburn	19:40

June 2, 2020

Thread	Author	Time
autovacuum processes not spawning	Wayne Cuddy	00:43

June 3, 2020

Thread	Author	Time
Recursive CTE with a function	Mark Bannister	13:52
Problem with parameterised CASE UPDATE	Mike Martin	16:33
Re: Problem with parameterised CASE UPDATE	Steve Midgley	18:02
Re: Problem with parameterised CASE UPDATE	David G. Johnston	18:15
Re: Problem with parameterised CASE UPDATE	Mike Martin	22:31

June 8, 2020

Thread	Author	Time
Persisting Query tabs/contents over restart	Joseph	18:14
Re: Persisting Query tabs/contents over restart	David G. Johnston	18:31
Re: Persisting Query tabs/contents over restart	Joseph	19:12

June 26, 2020

Thread	Author	Time
Optimizer Hint, to ignore limit and offset in optimizer plan	Martin Handsteiner	08:49
Re: Optimizer Hint, to ignore limit and offset in optimizer plan	Pavel Stehule	09:01
Re: Optimizer Hint, to ignore limit and offset in optimizer plan	Bruce Momjian	23:59

June 27, 2020

Thread	Author	Time
Re: Optimizer Hint, to ignore limit and offset in optimizer plan	Simon Riggs	11:08
pgsql function for roman2decimal?	F Bax	20:38
Re: pgsql function for roman2decimal?	Bruce Momjian	21:01
Re: pgsql function for roman2decimal?	Erik Brandsberg	21:14
Re: pgsql function for roman2decimal?	Bruce Momjian	21:24
Re: pgsql function for roman2decimal?	Erik Brandsberg	21:28
Re: pgsql function for roman2decimal?	Bruce Momjian	21:31

June 29, 2020

Thread	Author	Time
AW: Optimizer Hint, to ignore limit and offset in optimizer plan	Martin Handsteiner	08:10
Re: AW: Optimizer Hint, to ignore limit and offset in optimizer plan	Tom Lane	14:30
Re: AW: Optimizer Hint, to ignore limit and offset in optimizer plan	Erik Brandsberg	14:33
Re: AW: Optimizer Hint, to ignore limit and offset in optimizer plan	Bruce Momjian	15:48
AW: AW: Optimizer Hint, to ignore limit and offset in optimizer plan	Martin Handsteiner	17:33

July 8, 2020

Thread	Author	Time
Partition by list - is select possible?	Mike Martin	10:31
Re: Partition by list - is select possible?	David Rowley	12:01
Role information table name	Gaurav Tomar	17:25
Re: Role information table name	Jonathan Katz	17:44
Re: Role information table name	David G. Johnston	17:46
Re: Role information table name	Stephen Frost	17:54

July 20, 2020

Thread	Author	Time
foreign key referencing inheritance parent	J Lumby	14:44

July 25, 2020

Thread	Author	Time
plphyton function - return each list value as a row ?	karsten	21:26
Re: plphyton function - return each list value as a row ?	David G. Johnston	21:32
plphyton function - return each list value as a row ?	karsten	21:41
RE: plphyton function - return each list value as a row ?	karsten	21:50

July 30, 2020

Thread	Author	Time
UNNEST and multidimensional arrays	Mike Martin	13:28
Re: UNNEST and multidimensional arrays	Pavel Stehule	15:05
Re: UNNEST and multidimensional arrays	Steve Midgley	15:30

July 31, 2020

Thread	Author	Time
how to use function from different database	Bhupendra Babu	00:03
Re: how to use function from different database	David G. Johnston	00:15
Re: how to use function from different database	Rob Sargent	00:28
Re: how to use function from different database	Bhupendra Babu	06:05
Re: foreign key referencing inheritance parent 📎	Samed YILDIRIM	07:07
Re: foreign key referencing inheritance parent	John Lumby	15:48

Aug. 1, 2020

Thread	Author	Time
Group by a range of values	Mike Martin	12:14
Re: Group by a range of values	Torsten Grust	12:34
Re: Group by a range of values	Rob Sargent	12:53
Re: Group by a range of values	Steve Midgley	18:55

Aug. 3, 2020

Thread	Author	Time
Error - Arrays must contain only scalars and other arrays when array element is an array	Mike Martin	10:39

Aug. 8, 2020

Thread	Author	Time
Re: Group by a range of values 📎	Samed YILDIRIM	11:29

Aug. 9, 2020

Thread	Author	Time
recursive sql	ml	06:28
AW: recursive sql		07:55
Re: recursive sql 📎	Samed YILDIRIM	10:38
Re: recursive sql	ml	11:57
Re: recursive sql 📎	Samed YILDIRIM	12:08
Re: recursive sql	Igor Andriychuk	12:18
Re: recursive sql	ml	13:25
Re: recursive sql	Igor Andriychuk	14:10
Re: recursive sql	Igor Andriychuk	14:22
Re: recursive sql	Franz Timmer	14:54
Re: recursive sql	ml	15:04

Aug. 11, 2020

Thread	Author	Time
Use multidimensional array as VALUES clause in insert	Mike Martin	10:47
Use multidimensional array as VALUES clause in insert	Mike Martin	10:50
Re: Use multidimensional array as VALUES clause in insert 📎	Samed YILDIRIM	10:58
Re: Use multidimensional array as VALUES clause in insert	David G. Johnston	13:22
Re: Use multidimensional array as VALUES clause in insert	Thomas Kellerer	14:08
Re: Use multidimensional array as VALUES clause in insert	Igor Andriychuk	14:43
Re: Use multidimensional array as VALUES clause in insert	Mike Martin	20:59

Aug. 16, 2020

Thread	Author	Time
Weird issue with truncation of values in array with some tables	Mike Martin	13:48
Re: Weird issue with truncation of values in array with some tables	David G. Johnston	15:13
Re: Weird issue with truncation of values in array with some tables	Tom Lane	17:12
Re: Weird issue with truncation of values in array with some tables	Mike Martin	21:19

Aug. 22, 2020

Thread	Author	Time
Stored procedure and returning clause	Mike Martin	12:52

Aug. 28, 2020

Thread	Author	Time
value returned by EXTRACT, date_part	John Lumby	17:43
Re: value returned by EXTRACT, date_part	David G. Johnston	19:44
Re: value returned by EXTRACT, date_part	John Lumby	21:18

Aug. 29, 2020

Thread	Author	Time
Re: value returned by EXTRACT, date_part	Tom Lane	01:39
Re: value returned by EXTRACT, date_part	John Lumby	13:13
Re: value returned by EXTRACT, date_part	Tom Lane	16:04

Sept. 3, 2020

Thread	Author	Time
Re: Crossing/Rotating table rows to rows and columns	Christophe Pettus	02:58
Crossing/Rotating table rows to rows and columns	Iuri Sampaio	02:58

Sept. 4, 2020

Thread	Author	Time
Re: Crossing/Rotating table rows to rows and columns	Iuri Sampaio	00:20
Re: Crossing/Rotating table rows to rows and columns	Christophe Pettus	00:22

Sept. 7, 2020

Thread	Author	Time
Re: Crossing/Rotating table rows to rows and columns	Iuri Sampaio	02:03

Sept. 11, 2020

Thread	Author	Time
Clarification on pg_attribute attrelid	Mike Martin	11:26
Re: Clarification on pg_attribute attrelid	Tom Lane	14:12

Sept. 17, 2020

Thread	Author	Time
Postgres as a service for supporting common application users	Shaozhong SHI	22:59
Postgres as a service for supporting common application users	Shaozhong SHI	23:04

Oct. 3, 2020

Thread	Author	Time
Querying sporadic time series type data.	Tim Uckun	05:44
Re: Querying sporadic time series type data.	David G. Johnston	16:11
Re: Querying sporadic time series type data.	Tim Uckun	23:53

Oct. 4, 2020

Thread	Author	Time
Re: Querying sporadic time series type data.	David G. Johnston	00:10
Re: Querying sporadic time series type data.	Steven Pousty	00:42
Re: Querying sporadic time series type data.	Tim Uckun	08:29
parallelisation of queries	Francesco De Angelis	14:40

Oct. 8, 2020

Thread	Author	Time
libpq CREATE DATABASE operation from multiple treads	p.sun.fun	19:46
Re: libpq CREATE DATABASE operation from multiple treads	Tom Lane	19:57
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	20:04
Re: libpq CREATE DATABASE operation from multiple treads	Dmitry Igrishin	20:15
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	20:30
Re: libpq CREATE DATABASE operation from multiple treads	Tom Lane	20:32
Re: libpq CREATE DATABASE operation from multiple treads	Rob Sargent	20:35
Re: libpq CREATE DATABASE operation from multiple treads	Tom Lane	20:36
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	20:41
Re: libpq CREATE DATABASE operation from multiple treads	Rob Sargent	20:43
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	20:46
Re: libpq CREATE DATABASE operation from multiple treads	Rob Sargent	20:50
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	20:52
Re: libpq CREATE DATABASE operation from multiple treads	Tom Lane	20:56
Re: libpq CREATE DATABASE operation from multiple treads	Tom Lane	20:57

Oct. 9, 2020

Thread	Author	Time
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	03:33
Re: libpq CREATE DATABASE operation from multiple treads	Guillaume Lelarge	03:44
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	03:49
send query in background	Franz Timmer	04:31
send query in background	ml	04:34
Re: send query in background	Tatsuo Ishii	04:40
getting aroung chr(0)	James Cloos	20:01

Oct. 10, 2020

Thread	Author	Time
total and partial sums in the same query??	Iuri Sampaio	02:58
Re: total and partial sums in the same query??	David G. Johnston	03:40

Browse Archives

Prev | Next