pgsql-sql since 2020-03-25 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

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