pgsql-sql before 2019-04-11 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

Oct. 8, 2018

Thread Author Time
RE: Why the index is not used ? ROS Didier 14:10
RE: Why the index is not used ? ROS Didier 14:29
RE: Why the index is not used ? ROS Didier 15:32
Re: Why the index is not used ? Tomas Vondra 20:00
Re: Why the index is not used ? Paul McGarry 21:34

Oct. 9, 2018

Thread Author Time
left outer join to pull in most recent record Gary Stainburn 13:18
pg_dumpall and restore Rossi, Maria 17:18
Re: pg_dumpall and restore Keith 17:58
RE: pg_dumpall and restore Rossi, Maria 18:05
Re: pg_dumpall and restore Laurenz Albe 18:28
Re: pg_dumpall and restore Tom Lane 18:32
remove from list? Christopher McDonald 19:01
Re: remove from list? Andrej 19:21
RE: pg_dumpall and restore Rossi, Maria 20:05
Re: remove from list? Galkowski, Jan 20:06
Re: remove from list? Thomas Kellerer 20:48

Oct. 10, 2018

Thread Author Time
Re: left outer join to pull in most recent record MS (direkt) 09:13
Re: pg_dumpall and restore Stanton Schmidt 11:51
RE: pg_dumpall and restore Rossi, Maria 12:01

Oct. 11, 2018

Thread Author Time
Re: remove from list? Stephen Frost 01:56

Oct. 14, 2018

Thread Author Time
array problem with double quotes Olivier Leprêtre 13:40

Oct. 16, 2018

Thread Author Time
Re: array problem with double quotes Joe Conway 12:36

Nov. 3, 2018

Thread Author Time
Passinf field name Graeme Gemmill 17:40
Re: Passinf field name Jonathan S. Katz 17:47

Nov. 4, 2018

Thread Author Time
Regular Expressions Mark Williams 19:10
Re: Regular Expressions A. Sasaki 19:20
Re: Regular Expressions David G. Johnston 19:25
RE: Regular Expressions Mark Williams 19:43
Re: Regular Expressions David G. Johnston 19:51
Re: Regular Expressions Tom Lane 19:55
RE: Regular Expressions Mark Williams 20:02
Re: Regular Expressions A. Sasaki 22:44

Nov. 5, 2018

Thread Author Time
RE: Regular Expressions Mark Williams 10:21
multiple roles for a user ? DECHERF Étienne 11:15
Re: multiple roles for a user ? Stanton Schmidt 13:03
Re: multiple roles for a user ? Guillaume Lelarge 13:25
Re: multiple roles for a user ? David G. Johnston 15:08
Re: Regular Expressions Andrew Gierth 17:51

Nov. 9, 2018

Thread Author Time
Help with a not match Campbell, Lance 16:46
Re: Help with a not match David G. Johnston 16:54
Re: Help with a not match Campbell, Lance 17:08
Re: Help with a not match David G. Johnston 17:22
Re: Help with a not match Campbell, Lance 17:59
Re: Help with a not match David G. Johnston 18:17
Re: Help with a not match Andrew Gierth 22:04

Nov. 19, 2018

Thread Author Time
Difficulties with LAG-function when calculating overtime Andreas Joseph Krogh 13:27
Re: Difficulties with LAG-function when calculating overtime David G. Johnston 16:08
Sv: Re: Difficulties with LAG-function when calculating overtime Andreas Joseph Krogh 16:20
Sv: Sv: Re: Difficulties with LAG-function when calculating overtime Andreas Joseph Krogh 16:49

Nov. 21, 2018

Thread Author Time
Weird "could not determine which collation to use for string comparison" with LEAST/GREATEST on PG11 procedure Voillequin, Jean-Marc 14:09
Re: Weird "could not determine which collation to use for string comparison" with LEAST/GREATEST on PG11 procedure Tom Lane 18:19

Nov. 26, 2018

Thread Author Time
Select Distinct Order By Array_Position Mark Williams 19:12
Re: Select Distinct Order By Array_Position Rob Sargent 19:20
Re: Select Distinct Order By Array_Position David G. Johnston 19:46
RE: Select Distinct Order By Array_Position Mark Williams 19:58
RE: Select Distinct Order By Array_Position Mark Williams 19:59
Re: Select Distinct Order By Array_Position David G. Johnston 20:06
RE: Select Distinct Order By Array_Position Mark Williams 20:22

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

Browse Archives

Prev | Next