pgsql-sql since 2018-11-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

Nov. 28, 2018

Thread Author Time
error code 8 Olivier Leprêtre 08:32
Re: error code 8 Rene Romero Benavides 17:41
Re: error code 8 Pavel Stehule 17:43
RE: error code 8 Olivier Leprêtre 18:37

Nov. 30, 2018

Thread Author Time
Avoid "could not determine interpretation of row comparison operator =" Voillequin, Jean-Marc 13:35
Re: Avoid "could not determine interpretation of row comparison operator =" Tom Lane 15:31
RE: Avoid "could not determine interpretation of row comparison operator =" Voillequin, Jean-Marc 16:25
interval origami Adam Jensen 17:52
Re: interval origami Alvaro Herrera 17:57
Re: interval origami Adam Jensen 20:19
Re: interval origami Adam Jensen 21:02

Dec. 1, 2018

Thread Author Time
Re: interval origami Adam Jensen 00:04
Re: interval origami Adam Jensen 00:28
Re: interval origami Adam Jensen 00:45
Re: interval origami Joe Conway 13:24
Re: interval origami Adam Jensen 20:37

Dec. 2, 2018

Thread Author Time
Re: interval origami Steve Midgley 01:23

Dec. 6, 2018

Thread Author Time
After dump of 4.2 GB SQL file Equal to hard disk space??? Kirti Pathak 23:44

Dec. 7, 2018

Thread Author Time
Re: After dump of 4.2 GB SQL file Equal to hard disk space??? David G. Johnston 01:31

Dec. 11, 2018

Thread Author Time
Group by column alias where same-column-name already exists [email protected] 16:39
RE: Group by column alias where same-column-name already exists Voillequin, Jean-Marc 16:51

Dec. 12, 2018

Thread Author Time
Idle connections / sessions Oygun Josef 09:37
Re: Group by column alias where same-column-name already exists [email protected] 09:49
Re: Idle connections / sessions Thomas Kellerer 09:55
Re: Idle connections / sessions Fabio Pardi 10:02
Re: Idle connections / sessions Thomas Poty 10:10
SV: Idle connections / sessions Oygun Josef 11:20
Re: Idle connections / sessions Thomas Poty 18:26
explain analyze cost Ravi Krishna 22:37
Re: explain analyze cost Ron 22:45
Re: explain analyze cost Andres Freund 23:05

Dec. 13, 2018

Thread Author Time
Re: explain analyze cost Ravi Krishna 00:16
Postgres size greater than 1TB Rossi, Maria 16:33
Re: Postgres size greater than 1TB Jesper Krogh 16:36
Re: Postgres size greater than 1TB Steve Midgley 16:38
RE: Postgres size greater than 1TB Rossi, Maria 16:51
Changing csv structure and corresponding etl Shekar Tippur 16:51

Dec. 15, 2018

Thread Author Time
GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables? Larry Rosenman 02:13
Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables? Christopher Swingley 02:21
Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables? Rob Sargent 02:50
Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables? David G. Johnston 03:26
Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables? Larry Rosenman 03:36

Dec. 28, 2018

Thread Author Time
backend process was crashed when using zabbix monitor 梁博 10:31
Re: backend process was crashed when using zabbix monitor Tom Lane 15:36

Jan. 1, 2019

Thread Author Time
Re:Re: backend process was crashed when using zabbix monitor 梁博 01:06
Re: backend process was crashed when using zabbix monitor Peter Geoghegan 01:27
Re:Re: backend process was crashed when using zabbix monitor 梁博 01:38
How to create index on json array in postgres Surya S 05:49

Jan. 4, 2019

Thread Author Time
Re: How to create index on json array in postgres Alexey Bashtanov 17:10
Re: How to create index on json array in postgres Rene Romero Benavides 20:52
Re: How to create index on json array in postgres Steve Midgley 21:04

Jan. 22, 2019

Thread Author Time
Converting from MySQL Ertan Küçükoğlu 21:21
Re: Converting from MySQL David G. Johnston 21:42

Jan. 23, 2019

Thread Author Time
Re: Converting from MySQL Andrew Gierth 06:38
Back-out V10 upgrade but keep new data Rossi, Maria 19:06
Re: Back-out V10 upgrade but keep new data Rene Romero Benavides 19:12
Re: Back-out V10 upgrade but keep new data Rene Romero Benavides 19:31
RE: Back-out V10 upgrade but keep new data Rossi, Maria 19:51
Re: Back-out V10 upgrade but keep new data Rene Romero Benavides 21:38
Re: Back-out V10 upgrade but keep new data Rene Romero Benavides 21:41
AW: Back-out V10 upgrade but keep new data Sonnenberg-Carstens, Stefan 22:03
Re: Back-out V10 upgrade but keep new data Rene Romero Benavides 22:22
Creation of temporary tables on a publisher Cory Nemelka 22:45

Jan. 24, 2019

Thread Author Time
Re: Creation of temporary tables on a publisher Shreeyansh Dba 01:56
Re: Creation of temporary tables on a publisher Cory Nemelka 16:34

Jan. 25, 2019

Thread Author Time
Re: Creation of temporary tables on a publisher Shreeyansh Dba 10:30
Re: Creation of temporary tables on a publisher Cory Nemelka 20:04

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

Browse Archives

Prev | Next