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

Jan. 28, 2019

Thread Author Time
Re: Creation of temporary tables on a publisher Cory Nemelka 18:27
Re: Creation of temporary tables on a publisher Cory Nemelka 19:02
Fwd: Creation of temporary tables on a publisher Cory Nemelka 19:02

Feb. 1, 2019

Thread Author Time
Idea: INSERT INTO ... NATURAL SELECT ... Sven Berkvens-Matthijsse 16:06
Re: Idea: INSERT INTO ... NATURAL SELECT ... Steve Midgley 17:32
Re: Idea: INSERT INTO ... NATURAL SELECT ... Martin Stöcker 18:35
a recommendation on admin tool john fabiani 19:11
Re: a recommendation on admin tool William Ivanski 19:19
Re: a recommendation on admin tool Martin Stöcker 19:19
Re: a recommendation on admin tool basti 19:50
Re: a recommendation on admin tool Jonathan S. Katz 23:41

Feb. 2, 2019

Thread Author Time
Re: a recommendation on admin tool john fabiani 01:23
Re: a recommendation on admin tool john fabiani 01:25
Sv: Re: a recommendation on admin tool Andreas Joseph Krogh 11:14
Re: Sv: Re: a recommendation on admin tool john fabiani 13:43

Feb. 4, 2019

Thread Author Time
Re: Idea: INSERT INTO ... NATURAL SELECT ... Sven Berkvens-Matthijsse 16:03
Re: Idea: INSERT INTO ... NATURAL SELECT ... Sven Berkvens-Matthijsse 16:19

Feb. 5, 2019

Thread Author Time
Re: Weird "could not determine which collation to use for string comparison" with LEAST/GREATEST on PG11 procedure 📎 Peter Eisentraut 14:11
Re: Weird "could not determine which collation to use for string comparison" with LEAST/GREATEST on PG11 procedure Tom Lane 14:46

Feb. 7, 2019

Thread Author Time
Re: Weird "could not determine which collation to use for string comparison" with LEAST/GREATEST on PG11 procedure Peter Eisentraut 07:29

Feb. 11, 2019

Thread Author Time
Aurora Postgresql RDS DB Latency github kran 21:14
Re: Aurora Postgresql RDS DB Latency Michael Lewis 21:29

Feb. 12, 2019

Thread Author Time
Re: Aurora Postgresql RDS DB Latency github kran 00:00
Re: Aurora Postgresql RDS DB Latency github kran 13:07
Postgresql RDS DB Latency Chossing Hash join Plan github kran 18:27
Re: Postgresql RDS DB Latency Chossing Hash join Plan Michael Lewis 18:33
Re: Postgresql RDS DB Latency Chossing Hash join Plan 📎 github kran 18:55
Getting wrong time using now() Om Prakash Jaiswal 23:36
Re: Getting wrong time using now() Adrian Klaver 23:40
Re: Getting wrong time using now() Tom Lane 23:46

Feb. 13, 2019

Thread Author Time
Re: Postgresql RDS DB Latency Chossing Hash join Plan github kran 15:49
Re: Postgresql RDS DB Latency Chossing Hash join Plan Michael Lewis 17:37

Feb. 14, 2019

Thread Author Time
Re: Postgresql RDS DB Latency Chossing Hash join Plan github kran 15:47
Re: Postgresql RDS DB Latency Chossing Hash join Plan Michael Lewis 18:43
Re: Postgresql RDS DB Latency Chossing Hash join Plan github kran 22:11
Re: Postgresql RDS DB Latency Chossing Hash join Plan Michael Lewis 22:58

Feb. 15, 2019

Thread Author Time
Help on SQL query Ian Tan 17:22
Re: Help on SQL query Andrew Gierth 17:28
Re: Help on SQL query Rob Sargent 17:38
Re: Help on SQL query Ian Tan 18:16
Re: Help on SQL query Rob Sargent 19:03

Feb. 17, 2019

Thread Author Time
Re: Postgresql RDS DB Latency Chossing Hash join Plan github kran 17:03

Feb. 19, 2019

Thread Author Time
Re: Postgresql RDS DB Latency Chossing Hash join Plan Michael Lewis 17:11

Feb. 21, 2019

Thread Author Time
Group By aggregate string function Campbell, Lance 18:59
Re: Group By aggregate string function Campbell, Lance 19:02
Re: Group By aggregate string function David G. Johnston 19:53
Re: Group By aggregate string function Martin Stöcker 20:06

Feb. 22, 2019

Thread Author Time
Re: Postgresql RDS DB Latency Chossing Hash join Plan github kran 04:57
Database link MICHAEL LAZLO III 20:16
Re: Database link MichaelDBA 23:21

Feb. 25, 2019

Thread Author Time
PostgreSQL DB Maintenance and Partitioning to keep data longer. github kran 22:59

Feb. 27, 2019

Thread Author Time
Re: PostgreSQL DB Maintenance and Partitioning to keep data longer. github kran 05:51

March 1, 2019

Thread Author Time
Top 3 values for each group in PGSQL Ila B. 10:51
Re: Top 3 values for each group in PGSQL hubert depesz lubaczewski 11:59
Re: Top 3 values for each group in PGSQL Thomas Kellerer 12:52
Why does GROUP BY reduce number of rows? Rocky Ji 12:55
Re: Top 3 values for each group in PGSQL Achilleas Mantzios 13:17
Re: Why does GROUP BY reduce number of rows? Andrew Gierth 13:25

March 6, 2019

Thread Author Time
INSERT / UPDATE into 2 inner joined table simultaneously Lou 19:59
Re: INSERT / UPDATE into 2 inner joined table simultaneously Christopher Swingley 20:11
Re: INSERT / UPDATE into 2 inner joined table simultaneously Lou 21:36
Re: INSERT / UPDATE into 2 inner joined table simultaneously Christopher Swingley 21:41
Re: INSERT / UPDATE into 2 inner joined table simultaneously Steve Midgley 22:45

March 7, 2019

Thread Author Time
Re: INSERT / UPDATE into 2 inner joined table simultaneously Tony Shelver 05:44

March 12, 2019

Thread Author Time
Jsonb column MICHAEL LAZLO 13:33
Re: Jsonb column Alexandru Lazarev 14:27
Re: Jsonb column MICHAEL LAZLO 16:30

March 18, 2019

Thread Author Time
Moving from TSQL to PL/pgsql select into a variable... Ron Clarke 14:52
Re: Moving from TSQL to PL/pgsql select into a variable... David G. Johnston 14:57
Re: Moving from TSQL to PL/pgsql select into a variable... Pavel Stehule 15:06

March 22, 2019

Thread Author Time
Re: Error while executing a view in postgres 10.5 pavan95 11:26
Re: Error while executing a view in postgres 10.5 Jonathan S. Katz 13:08

March 29, 2019

Thread Author Time
Archival process of partition tables with filtering few rows from tables. github kran 04:13
Re: Archival process of partition tables with filtering few rows from tables. Andreas Kretschmer 05:42
returning multiple refcursors from inner function Debajyoti Saha 08:11

April 11, 2019

Thread Author Time
Partitioning table on tztsrange Alexandre Lessard 14:05

April 19, 2019

Thread Author Time
xpath insert unexpected newlines Voillequin, Jean-Marc 13:04
Re: xpath insert unexpected newlines Tom Lane 14:21

April 22, 2019

Thread Author Time
Re: xpath insert unexpected newlines Tom Lane 19:48

April 25, 2019

Thread Author Time
Problem in Max Lipsky 13:45
Re: Problem in Tom Lane 16:56
Re: Problem in Max Lipsky 21:08
Re: Problem in Tom Lane 21:41

April 27, 2019

Thread Author Time
Re: Problem in Andrej 00:34
Re: Problem in Max Lipsky 07:32
Restrictions of channel arg of pg_notofy Axel Rau 17:51
Re: Restrictions of channel arg of pg_notofy Tom Lane 18:51

April 28, 2019

Thread Author Time
Re: Restrictions of channel arg of pg_notofy Axel Rau 16:22
Re: Restrictions of channel arg of pg_notofy Tom Lane 17:02
Re: Restrictions of channel arg of pg_notofy Axel Rau 17:46
Re: Restrictions of channel arg of pg_notofy Tom Lane 18:23

April 29, 2019

Thread Author Time
[RESOLVED] Re: Restrictions of channel arg of pg_notofy Axel Rau 08:23

April 30, 2019

Thread Author Time
ERROR: missing FROM-clause entry for table "new" Mike LAZLO 13:41
Re: ERROR: missing FROM-clause entry for table "new" Tom Lane 13:47
RE: ERROR: missing FROM-clause entry for table "new" Voillequin, Jean-Marc 13:53
Re: ERROR: missing FROM-clause entry for table "new" Mike LAZLO 15:27

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

Browse Archives

Prev | Next