pgsql-sql since 2019-09-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

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

Nov. 12, 2019

Thread	Author	Time
Re: type for storing emails?	Martin Edlman	07:37
FW: Re: type for storing emails?	stan	15:07
Sv: FW: Re: type for storing emails?	Andreas Joseph Krogh	15:21
Re: FW: Re: type for storing emails?	Steve Midgley	15:50
Re: FW: Re: type for storing emails?	Andreas Joseph Krogh	16:44
install problem with extensions	stan	17:09
Re: install problem with extensions	legrand legrand	21:50

Nov. 13, 2019

Thread	Author	Time
Re: install problem with extensions	stan	18:09
Re: install problem with extensions	legrand legrand	18:11

Nov. 14, 2019

Thread	Author	Time
Re: Postgresql RDS DB Latency Chossing Hash join Plan	github kran	17:21
PostGreSQL Replication and question on maintenance	github kran	17:23

Nov. 15, 2019

Thread	Author	Time
Fwd: PostGreSQL Replication and question on maintenance	github kran	05:26
Re: PostGreSQL Replication and question on maintenance	Pavel Stehule	05:41
Re: PostGreSQL Replication and question on maintenance	github kran	15:10

Nov. 16, 2019

Thread	Author	Time
Re: PostGreSQL Replication and question on maintenance	github kran	13:36
Re: PostGreSQL Replication and question on maintenance	Jeff Janes	17:13

Nov. 20, 2019

Thread	Author	Time
Re: PostGreSQL Replication and question on maintenance	Soto Cuevas Manuel Alejandro	12:12
Re: PostGreSQL Replication and question on maintenance	Pavel Stehule	12:15

Nov. 25, 2019

Thread	Author	Time
How to use Array in Array of Json	Monalee Bhandge	12:02
Re: How to use Array in Array of Json	Steve Midgley	16:13
RE: How to use Array in Array of Json	2.andriychuk	16:14

Nov. 26, 2019

Thread	Author	Time
Re: How to use Array in Array of Json	Monalee Bhandge	05:38

Nov. 27, 2019

Thread	Author	Time
Re: PostGreSQL Replication and question on maintenance	github kran	01:22
How to use Array in Array of Json	Monalee Bhandge	12:11

Dec. 1, 2019

Thread	Author	Time
Solving my query needs with Rank and may be CrossTab	Iaam Onkara	22:54
Re: Solving my query needs with Rank and may be CrossTab	Rob Sargent	23:28
Re: Solving my query needs with Rank and may be CrossTab	Iaam Onkara	23:38

Dec. 2, 2019

Thread	Author	Time
Re: Solving my query needs with Rank and may be CrossTab	Rob Sargent	04:58
Re: Solving my query needs with Rank and may be CrossTab	Iaam Onkara	06:09
Re: Solving my query needs with Rank and may be CrossTab	Rob Sargent	13:42
Re: Solving my query needs with Rank and may be CrossTab	Iaam Onkara	16:55
Re: Solving my query needs with Rank and may be CrossTab	Rob Sargent	21:14

Dec. 20, 2019

Thread	Author	Time
problem with read-only user	ROS Didier	13:01
Re: problem with read-only user	Tom Lane	14:04

Dec. 27, 2019

Thread	Author	Time
RE: problem with read-only user	ROS Didier	08:56

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

Browse Archives

Prev | Next