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

Feb. 27, 2018

Thread	Author	Time
update tables with instead of trigger after update of view	garret	17:59

March 1, 2018

Thread	Author	Time
Monthly budgets	Gary Stainburn	08:42
Re: Monthly budgets	Gary Stainburn	09:42
How to best migrate this nested join ?	Gary M	21:16
Re: How to best migrate this nested join ?	David G. Johnston	21:31

March 2, 2018

Thread	Author	Time
Re: How to best migrate this nested join ?	Gary M	00:15

March 8, 2018

Thread	Author	Time
Query question	Stanton Schmidt	18:58
Re: Query question	Martin Stöcker	19:07
Re: Query question	Stanton Schmidt	19:17
Re: Query question	Jeff Fletcher	19:20
Re: Query question	David G. Johnston	19:28
Re: Query question	Thomas Kellerer	19:48
Re: Query question	Stanton Schmidt	20:17

March 10, 2018

Thread	Author	Time
Trouble with single trigger using UUID as key, should I use two triggers?	Jason Aleski	02:15

March 16, 2018

Thread	Author	Time
does the notification of postgres appear in transaction completed order	abctevez	13:42
Re: does the notification of postgres appear in transaction completed order	Tom Lane	14:57

March 29, 2018

Thread	Author	Time
when transaction is committed in postgres	abctevez	06:46
Re: when transaction is committed in postgres 📎	Samed YILDIRIM	11:29

April 1, 2018

Thread	Author	Time
select unnest(), unnest()	Jasmin Dizdarevic	19:38
Re: select unnest(), unnest()	Tom Lane	19:49
Re: select unnest(), unnest()	Jasmin Dizdarevic	20:25

April 17, 2018

Thread	Author	Time
Postgres 9.6 - ltree extension - (re)build a tree on a table	Luca	10:11

April 18, 2018

Thread	Author	Time
Re: Postgres 9.6 - ltree extension - (re)build a tree on a table	Steve Midgley	00:19
Re: Postgres 9.6 - ltree extension - (re)build a tree on a table	David G. Johnston	00:30
summary view design / performance	Gary Stainburn	09:20
Re: summary view design / performance	Achilleas Mantzios	12:45

April 25, 2018

Thread	Author	Time
error in function, works when typed	Gary Stainburn	09:06
Re: error in function, works when typed 📎	Samed YILDIRIM	09:32
Re: error in function, works when typed	Gary Stainburn	09:56

April 27, 2018

Thread	Author	Time
psql method (initcap and also keep Roman number capitalized)	Emi	14:39

April 30, 2018

Thread	Author	Time
Re: psql method (initcap and also keep Roman number capitalized)	Martin Stöcker	11:22

May 6, 2018

Thread	Author	Time
Access to table only through functions	Alvin D?az	22:51

May 7, 2018

Thread	Author	Time
Re: Access to table only through functions	Gerardo Herzig	01:14
Re: Access to table only through functions	Alvin D?az	01:56

June 13, 2018

Thread	Author	Time
Window ?	Olivier Leprêtre	14:33
Re: Window ?	Gerardo Herzig	14:51
Re: Window ?	David G. Johnston	14:54
RE: Window ?	Olivier Leprêtre	15:14
Re: Window ?	Gerardo Herzig	15:22

July 3, 2018

Thread	Author	Time
Problem inserting binary data in bytea column of UTF-8 database	Brice André	04:28

July 5, 2018

Thread	Author	Time
Re: Problem inserting binary data in bytea column of UTF-8 database	Alexey Bashtanov	13:48
Re: Problem inserting binary data in bytea column of UTF-8 database	David G. Johnston	14:04

July 7, 2018

Thread	Author	Time
Re: Problem inserting binary data in bytea column of UTF-8 database	Brice André	06:42

July 26, 2018

Thread	Author	Time
Vacumdb Command Problem	komala pelleti	10:38
Re: Vacumdb Command Problem	hubert depesz lubaczewski	11:41
test mail	Emiliano Amilcarelli	20:18
Fwd: test mail	Emiliano Amilcarelli	20:25
Re: Fwd: test mail	Alvaro Herrera	20:29

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

Browse Archives

Prev | Next