pgsql-sql since 2018-08-29 22:26

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

Aug. 29, 2018

Thread Author Time
RE: Stored Procedure to Delete Rows and Return Count Dave Bolt 22:26

Sept. 4, 2018

Thread Author Time
XMLTABLE question 📎 David Day 10:05
Re: XMLTABLE question Pavel Stehule 15:05

Sept. 5, 2018

Thread Author Time
RE: XMLTABLE question David Day 08:56
Re: XMLTABLE question Pavel Stehule 09:41

Sept. 10, 2018

Thread Author Time
md5 and trust and pg_hba.conf Rossi, Maria 14:45
Re: md5 and trust and pg_hba.conf Sameer Kumar 14:55
Re: md5 and trust and pg_hba.conf Fabio Pardi 15:17
RE: md5 and trust and pg_hba.conf Rossi, Maria 15:22
Re: md5 and trust and pg_hba.conf Sameer Kumar 15:35
RE: md5 and trust and pg_hba.conf David Raymond 15:41
RE: md5 and trust and pg_hba.conf Rossi, Maria 19:47
RE: md5 and trust and pg_hba.conf David Raymond 20:39

Sept. 14, 2018

Thread Author Time
create policy/using expression Voillequin, Jean-Marc 09:22

Sept. 21, 2018

Thread Author Time
select where not in () fails Gary Stainburn 15:08
Re: select where not in () fails Pavel Stehule 15:11
Re: select where not in () fails Gary Stainburn 15:20
Re: select where not in () fails Pavel Stehule 16:14

Sept. 22, 2018

Thread Author Time
Re: select where not in () fails Andrew Gierth 18:13

Oct. 6, 2018

Thread Author Time
Why the index is not used ? ROS Didier 09:57
Re: Why the index is not used ? Pavel Stehule 10:13
Re: Why the index is not used ? Vladimir Ryabtsev 16:51

Oct. 7, 2018

Thread Author Time
Re: Why the index is not used ? Paul McGarry 02:20
RE: Why the index is not used ? ROS Didier 13:13
RE: Why the index is not used ? ROS Didier 13:20
Re: Why the index is not used ? Francisco Olarte 15:58
RE: Why the index is not used ? ROS Didier 18:32
RE: Why the index is not used ? Kumar, Virendra 18:41
Re: Why the index is not used ? Vladimir Ryabtsev 18:48
Re: Why the index is not used ? Vladimir Ryabtsev 19:32
Re: Why the index is not used ? Tomas Vondra 20:07
Re: Why the index is not used ? Paul McGarry 22:10

Oct. 8, 2018

Thread Author Time
RE: Why the index is not used ? ROS Didier 06:29
RE: Why the index is not used ? ROS Didier 08:32
Re: Why the index is not used ? Jean-Paul Argudo 08:44
RE: Why the index is not used ? ROS Didier 11:47
RE: Why the index is not used ? ROS Didier 12:02
RE: Why the index is not used ? ROS Didier 12:07
RE: Why the index is not used ? Phil Endecott 13:14
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 agharta82@gmail.com 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 agharta82@gmail.com 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

Browse Archives

Prev | Next