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

July 27, 2018

Thread	Author	Time
Regarding calling shell script from postgres function	komala pelleti	06:12
Re: Regarding calling shell script from postgres function	Andreas Kretschmer	06:51
Regarding vacuumdb	komala pelleti	09:41
Re: Regarding vacuumdb	Andreas Kretschmer	11:38

Aug. 2, 2018

Thread	Author	Time
List user who have access to schema	Suresh Raja	17:49
Re: List user who have access to schema	Tom Lane	17:58
Re: List user who have access to schema	Suresh Raja	18:23
Re: List user who have access to schema	David G. Johnston	18:42
Re: List user who have access to schema	Adrian Klaver	18:47

Aug. 3, 2018

Thread	Author	Time
Re: List user who have access to schema	pinker	14:26

Aug. 6, 2018

Thread	Author	Time
read explain (analyse, buffers) output in Postgres 10.4 with parallel on	Huan Ruan	03:24
Re: read explain (analyse, buffers) output in Postgres 10.4 with parallel on	Jonathan S. Katz	03:33
Re: read explain (analyse, buffers) output in Postgres 10.4 with parallel on	Huan Ruan	06:15

Aug. 28, 2018

Thread	Author	Time
pgadmin not displaying data from postgresql_fdw	Olivier Leprêtre	15:37

Aug. 29, 2018

Thread	Author	Time
redundant constraint_schema	Olivier Leprêtre	13:48
Stored Procedure to Delete Rows and Return Count	Dave Bolt	21:46
Re: Stored Procedure to Delete Rows and Return Count	Jonathan S. Katz	21:50
Re: Stored Procedure to Delete Rows and Return Count	Jonathan S. Katz	21:56
Re: Stored Procedure to Delete Rows and Return Count	David G. Johnston	21:56
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	[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

Browse Archives

Prev | Next