pgsql-sql since 2017-03-30 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

March 30, 2017

Thread	Author	Time
Query Advice	Gary Chambers	18:03
Re: Query Advice	David G. Johnston	18:13
Re: Query Advice	Vincent Elschot	18:16
Re: Query Advice	Rob Sargent	18:17
Re: Query Advice	Jason Aleski	18:27
Re: Query Advice	Gary Chambers	19:19
Re: Query Advice	Gary Chambers	19:22

April 2, 2017

Thread	Author	Time
Crosstab function	Gowtham Vel	16:05

April 3, 2017

Thread	Author	Time
Re: Crosstab function	Adrian Klaver	14:39

April 4, 2017

Thread	Author	Time
Re: Crosstab function 📎	Gowtham Vel	18:28

April 5, 2017

Thread	Author	Time
Re: Crosstab function	Gowtham Vel	17:04

April 6, 2017

Thread	Author	Time
Re: Crosstab function	Adrian Klaver	00:01

April 7, 2017

Thread	Author	Time
death of array?	Rob Sargent	02:32
Re: death of array?	David G. Johnston	03:02
Re: death of array?	Achilleas Mantzios	06:28
Re: death of array?	Rob Sargent	15:22
Re: death of array?	David G. Johnston	15:26
Re: death of array?	Rob Sargent	15:57
Re: death of array?	David G. Johnston	16:02
Re: death of array?	Rob Sargent	16:17

April 8, 2017

Thread	Author	Time
Re: death of array?	Rob Sargent	21:07

April 10, 2017

Thread	Author	Time
Re: death of array?	Achilleas Mantzios	06:50
Re: death of array?	Rob Sargent	14:41

April 12, 2017

Thread	Author	Time
CTEs and re-use	Rob Sargent	00:41
Re: CTEs and re-use	David G. Johnston	01:47
Re: CTEs and re-use	Rob Sargent	02:47
Re: CTEs and re-use	Rob Sargent	03:05
Re: CTEs and re-use	Rosser Schwarz	04:04
Re: CTEs and re-use	Rob Sargent	16:29

April 13, 2017

Thread	Author	Time
Best way to store Master-Detail Data	Alvin Díaz	03:51
Re: Best way to store Master-Detail Data	David G. Johnston	04:15
Re: Best way to store Master-Detail Data	Andreas Kretschmer	10:54
Re: Best way to store Master-Detail Data	Alvin Díaz	13:08

April 20, 2017

Thread	Author	Time
Please advice on query optimization	Muhannad Shubita	16:43
Re: Please advice on query optimization 📎	Samed YILDIRIM	17:18
Re: Please advice on query optimization	Muhannad Shubita	17:35
Re: Please advice on query optimization 📎	Samed YILDIRIM	19:29
Re: Please advice on query optimization	David G. Johnston	19:37
Re: Please advice on query optimization	Muhannad Shubita	20:07
Re: Please advice on query optimization	Hector Vass	22:04

May 5, 2017

Thread	Author	Time
Most recent row	Gary Stainburn	08:25
Re: Most recent row	Karsten Hilbert	08:32
Re: Most recent row	vinny	08:50
Re: Most recent row	Gary Stainburn	09:13
Re: Most recent row	hubert depesz lubaczewski	09:35
Re: Most recent row	Gary Stainburn	09:44
Re: Most recent row	hubert depesz lubaczewski	10:00
Re: Most recent row	Gary Stainburn	10:54
Re: Most recent row	hubert depesz lubaczewski	11:09
Re: Most recent row	David G. Johnston	15:14
Re: Most recent row	Adrian Klaver	16:02
Re: Most recent row	Michael Moore	20:47
Re: Most recent row	Michael Moore	21:25
Re: Most recent row	Michael Moore	21:57

May 7, 2017

Thread	Author	Time
Re: Most recent row	Bob Edwards	23:57

May 8, 2017

Thread	Author	Time
Re: Most recent row	Gary Stainburn	11:49
Re: Most recent row	Thomas Kellerer	12:19

May 12, 2017

Thread	Author	Time
exporting query result	Günce Kaya	09:14
Re: [SQL] exporting query result	Adrian Klaver	13:12
Re: [SQL] exporting query result	Günce Kaya	15:58
Re: [SQL] exporting query result	Adrian Klaver	16:07
Re: exporting query result	Günce Kaya	16:20
Re: exporting query result	Thomas Kellerer	16:21
Re: exporting query result	Günce Kaya	18:03

May 13, 2017

Thread	Author	Time
DB initialization/ Upgrade issue	Ashish Tiwari	12:43
Re: DB initialization/ Upgrade issue	Thomas Kellerer	12:59
PostgreSQL 9.3 DB initialization issue	Ashish Tiwari	13:11
Re: PostgreSQL 9.3 DB initialization issue	Adrian Klaver	13:25
Re: [SQL] PostgreSQL 9.3 DB initialization issue	Ashish Tiwari	13:41
Re: [SQL] PostgreSQL 9.3 DB initialization issue	Adrian Klaver	14:00
Re: [SQL] PostgreSQL 9.3 DB initialization issue	Ashish Tiwari	14:58
Re: PostgreSQL 9.3 DB initialization issue	Ashish Tiwari	15:53
Re: PostgreSQL 9.3 DB initialization issue	Adrian Klaver	16:44
Re: [SQL] PostgreSQL 9.3 DB initialization issue	Ashish Tiwari	16:49
Re: PostgreSQL 9.3 DB initialization issue	Steve Midgley	21:50
Re: [SQL] PostgreSQL 9.3 DB initialization issue	Adrian Klaver	22:26

May 18, 2017

Thread	Author	Time
PostgrSQL server : CPU and Memory	kaustubh kelkar	03:50
Re: PostgrSQL server : CPU and Memory	John R Pierce	04:03

May 20, 2017

Thread	Author	Time
SQL conversion help	Ertan Küçükoğlu	04:01
Re: SQL conversion help	Adrian Klaver	04:07
Re: SQL conversion help	Ertan Küçükoğlu	13:24
Re: SQL conversion help	Adrian Klaver	13:38

May 22, 2017

Thread	Author	Time
Re: SQL conversion help	Thomas Kellerer	06:30
TRUNCATE TABLE corrupts pg_class.relfilenode = pg_attrdef.pg_attrdef	Sebastien FLAESCH	10:51
Re: TRUNCATE TABLE corrupts pg_class.relfilenode = pg_attrdef.pg_attrdef	Sebastien FLAESCH	10:57
Re: TRUNCATE TABLE corrupts pg_class.relfilenode = pg_attrdef.pg_attrdef	Sebastien FLAESCH	11:07
Re: TRUNCATE TABLE corrupts pg_class.relfilenode = pg_attrdef.pg_attrdef	Sebastien FLAESCH	11:14
Re: TRUNCATE TABLE corrupts pg_class.relfilenode = pg_attrdef.pg_attrdef	Tom Lane	12:04

May 23, 2017

Thread	Author	Time
about LEFT and INNER JOIN	Eliober Cleger Despaigne	18:38

May 25, 2017

Thread	Author	Time
Re: SQL error: function round(double precision, integer) does not exist	Vladimir Nicolici	17:26
Re: Re: SQL error: function round(double precision, integer) does not exist	Tom Lane	17:54
Re: Re: SQL error: function round(double precision, integer) does not exist	Vladimir Nicolici	17:55
Re: Re: SQL error: function round(double precision, integer) does not exist	David G. Johnston	17:56
Re: Re: SQL error: function round(double precision, integer) does not exist	Tom Lane	18:22
Re: Re: SQL error: function round(double precision, integer) does not exist	Vladimir Nicolici	18:23

May 29, 2017

Thread	Author	Time
Inconsistent/wrong behavior of pg_trigger_depth when used with DEFERRED CONSTRAINTS	Achilleas Mantzios	11:22
Lost my tablespace	tel medola	14:10
Re: Lost my tablespace	Adrian Klaver	14:23
Re: Lost my tablespace	tel medola	14:39
Re: Lost my tablespace	Adrian Klaver	14:57
Re: Lost my tablespace	Tom Lane	15:42
Re: Lost my tablespace	tel medola	15:46
Re: Lost my tablespace	tel medola	15:52
Re: Lost my tablespace	Adrian Klaver	18:01
Re: Lost my tablespace	tel medola	18:21
Re: Lost my tablespace	Adrian Klaver	18:45
Re: Lost my tablespace	tel medola	19:05
Re: Lost my tablespace	Adrian Klaver	19:32

May 30, 2017

Thread	Author	Time
Re: about LEFT and INNER JOIN	Feike Steenbergen	06:00
Re: Lost my tablespace	tel medola	12:11
Re: about LEFT and INNER JOIN	Eliober Cleger Despaigne	12:20
Re: Lost my tablespace	Adrian Klaver	13:22
Re: Lost my tablespace	tel medola	13:50
Re: Lost my tablespace	Adrian Klaver	14:21
Re: Lost my tablespace	Adrian Klaver	14:49
Re: Lost my tablespace	tel medola	14:56
Re: Lost my tablespace	Adrian Klaver	18:35
Re: Lost my tablespace	tel medola	18:56
Re: Lost my tablespace	Adrian Klaver	19:35
Re: Lost my tablespace	tel medola	20:36
Re: Lost my tablespace	Adrian Klaver	22:07
Re: Lost my tablespace	Adrian Klaver	23:25
Re: Lost my tablespace	tel medola	23:29

May 31, 2017

Thread	Author	Time
Re: Inconsistent/wrong behavior of pg_trigger_depth when used with DEFERRED CONSTRAINTS	Tom Lane	14:55

June 1, 2017

Thread	Author	Time
Re: Inconsistent/wrong behavior of pg_trigger_depth when used with DEFERRED CONSTRAINTS	Achilleas Mantzios	08:38
Can the result sets produced in SQL procedures be left open for the use of the calling program?	Gugu Rama	21:15
Re: Can the result sets produced in SQL procedures be left open for the use of the calling program?	Adrian Klaver	21:24
YNT: Re: Can the result sets produced in SQL procedures be left open for the use of the calling program?	gulsumramazanoglu	22:51

June 2, 2017

Thread	Author	Time
Re: YNT: Re: Can the result sets produced in SQL procedures be left open for the use of the calling program?	Adrian Klaver	00:07
Using bind variable within BEGIN END	anand086	00:24
Re: Using bind variable within BEGIN END	David G. Johnston	00:31
Re: Using bind variable within BEGIN END	Rob Sargent	00:59
Re: Using bind variable within BEGIN END	anand086	01:35
Database views metadata always nullable columns	basuraspam -	14:11
Re: Database views metadata always nullable columns	Tom Lane	14:21
Re: Database views metadata always nullable columns	basuraspam -	15:33
Re: Database views metadata always nullable columns	David G. Johnston	15:59
Re: Database views metadata always nullable columns	Tom Lane	16:07
Re: Using bind variable within BEGIN END	anand086	17:29
Re: Using bind variable within BEGIN END	David G. Johnston	18:21
Re: Using bind variable within BEGIN END	David G. Johnston	18:27
YNT: Re: Using bind variable within BEGIN END	gulsumramazanoglu	18:35
YNT: Re: Using bind variable within BEGIN END	gulsumramazanoglu	18:38
Re: Using bind variable within BEGIN END	David G. Johnston	18:57
Re: Using bind variable within BEGIN END	David G. Johnston	18:59
Re: Database views metadata always nullable columns	basuraspam -	19:30
Re: YNT: Re: Using bind variable within BEGIN END	Adrian Klaver	20:00
YNT: Re: YNT: Re: Using bind variable within BEGIN END	gulsumramazanoglu	20:19

June 5, 2017

Thread	Author	Time
Delete failing with -- permission denied	anand086	20:44
Re: Delete failing with -- permission denied	Tom Lane	21:15
Re: Delete failing with -- permission denied	anand086	21:34
Re: Delete failing with -- permission denied	David G. Johnston	21:43
Re: Delete failing with -- permission denied	Adrian Klaver	22:14

June 7, 2017

Thread	Author	Time
Not getting the expected results for a simple where not in	Jonathan Moules	12:20
Re: Not getting the expected results for a simple where not in	Adrian Klaver	12:49
Re: Not getting the expected results for a simple where not in	Adrian Klaver	13:28

June 12, 2017

Thread	Author	Time
crosstab category mix	Majid Khan	07:53
Re: crosstab category mix	Steve Midgley	13:46

June 16, 2017

Thread	Author	Time
Fwd: Re: crosstab category mix 📎	Majid Khan	12:35
Re: crosstab category mix 📎	Samed YILDIRIM	15:03

June 19, 2017

Thread	Author	Time
Find rows with "timestamp out of range"	Saiful Muhajir	07:04
Find rows with "timestamp out of range"	Saiful Muhajir	07:11
Re: Find rows with "timestamp out of range"	vinny	07:54
Re: Find rows with "timestamp out of range"	Saiful Muhajir	07:57
Re: Find rows with "timestamp out of range" 📎	Samed YILDIRIM	08:37
Re: Find rows with "timestamp out of range"	Adrian Klaver	13:25
Re: Find rows with "timestamp out of range"	Tom Lane	13:33

June 20, 2017

Thread	Author	Time
Re: Find rows with "timestamp out of range"	Saiful Muhajir	01:48

July 6, 2017

Thread	Author	Time
Finding the negative	Ed Rouse	19:13
Re: Finding the negative	Vincent Elschot	19:25
Re: Finding the negative	Tom Lane	19:43

July 10, 2017

Thread	Author	Time
Function with table Valued Parameters execution issue	Kanjibhai.Kanzaria	12:49
Re: Function with table Valued Parameters execution issue	Adrian Klaver	13:26

July 13, 2017

Thread	Author	Time
Function with table Valued Parameters execution issue	Kanjibhai.Kanzaria	13:53

July 18, 2017

Thread	Author	Time
Steps to place standby database in read write	Prashanth Reddy	01:27
Filter JSONB on Foreign Table in postgres_fdw	Luan Huynh	03:06
Re: Steps to place standby database in read write	Prashanth Reddy	14:58
Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database in read write	Maddali, Srinivas	15:01
Re: [ADMIN] Steps to place standby database in read write	Ashish Tiwari	15:02
Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database in read write	Prashanth Reddy	15:35
Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database in read write	Maddali, Srinivas	15:59

July 21, 2017

Thread	Author	Time
commit not completing - how to investigate?	Tim Dudgeon	11:32
Re: commit not completing - how to investigate?	Tom Lane	14:14
Re: commit not completing - how to investigate?	Tim Dudgeon	15:18
Re: commit not completing - how to investigate?	Tom Lane	17:23
How to duplicate postgres 9.4 database	srilinux	19:28
Re: How to duplicate postgres 9.4 database	Igor Neyman	20:07

July 22, 2017

Thread	Author	Time
Re: How to duplicate postgres 9.4 database	srilinux	23:43

July 25, 2017

Thread	Author	Time
Postgresql “alter column type” creates an event which contains “temp_table_xxx”	Zehra Gül Çabuk	06:18
Re: [SQL] Postgresql “alter column type” creates an event which contains “temp_table_xxx”	Tom Lane	14:18
Re: [SQL] Postgresql “alter column type” creates an event which contains “temp_table_xxx”	Craig Ringer	15:04
Re: How to duplicate postgres 9.4 database	Scott Marlowe	21:07

July 28, 2017

Thread	Author	Time
Issues with lag command	Mohamed DIA	17:48
Re: Issues with lag command	Steve Midgley	19:21
Re: Issues with lag command	David G. Johnston	19:29
Re: Issues with lag command	Igor Neyman	19:53
created database but access is not copied ? any suggestions	srilinux	20:43
Re: created database but access is not copied ? any suggestions	David G. Johnston	20:57
Re: created database but access is not copied ? any suggestions	srilinux	21:16
Re: created database but access is not copied ? any suggestions	David G. Johnston	23:00

Browse Archives

Prev | Next