pgsql-sql since 2017-05-07 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

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

July 29, 2017

Thread Author Time
Re: Issues with lag command Harald Fuchs 08:05
Re: created database but access is not copied ? any suggestions srilinux 17:38

July 31, 2017

Thread Author Time
Database duplicate copy srilinux 14:57
Odd unfamiliar Postgres SQL syntax Sonny 16:42
Re: Odd unfamiliar Postgres SQL syntax David G. Johnston 19:01
Re: Odd unfamiliar Postgres SQL syntax Pavel Stehule 19:02
Re: Odd unfamiliar Postgres SQL syntax Tom Lane 19:03

Aug. 1, 2017

Thread Author Time
PostgreSQL connection with Android Studio Majid Khan 12:01
Re: PostgreSQL connection with Android Studio Steve Midgley 15:40

Aug. 7, 2017

Thread Author Time
Better way to sort a JSONB array? Michael Moore 20:13
Re: Better way to sort a JSONB array? Steve Midgley 20:51
Re: Better way to sort a JSONB array? Michael Moore 21:12
Re: Better way to sort a JSONB array? Steve Midgley 21:17
Re: Better way to sort a JSONB array? Michael Moore 21:36
Re: Better way to sort a JSONB array? David G. Johnston 21:36
Re: Better way to sort a JSONB array? Michael Moore 21:38
Re: Better way to sort a JSONB array? Michael Moore 21:53
Re: Better way to sort a JSONB array? David G. Johnston 22:04
Re: Better way to sort a JSONB array? Michael Moore 22:10

Aug. 10, 2017

Thread Author Time
Re: Amazon.co.jpからセキュリティコードをお送りします Masaru Sugawara 10:12
Replication and Field Level Encryption Jason Aleski 17:04
Re: Replication and Field Level Encryption Steve Midgley 22:11

Aug. 11, 2017

Thread Author Time
Always getting back a row, even with no results Jonathan Moules 13:57
Re: Always getting back a row, even with no results Achilleas Mantzios 14:28
Re: Always getting back a row, even with no results David G. Johnston 15:18
Re: Always getting back a row, even with no results Jonathan Moules 15:30
Re: Always getting back a row, even with no results Jonathan Moules 15:36
Re: Always getting back a row, even with no results David G. Johnston 15:43

Aug. 12, 2017

Thread Author Time
Updating jsonb rows Michael Moore 01:08
Re: Updating jsonb rows David G. Johnston 01:18
Re: Always getting back a row, even with no results Michael Moore 02:41

Aug. 14, 2017

Thread Author Time
Re: Always getting back a row, even with no results Achilleas Mantzios 08:24
Re: Always getting back a row, even with no results Michael Moore 17:13
Re: Updating jsonb rows Michael Moore 17:35
Re: Updating jsonb rows David G. Johnston 18:12
Re: Updating jsonb rows Michael Moore 19:33
Re: Updating jsonb rows Michael Moore 20:51

Aug. 23, 2017

Thread Author Time
how many times Campbell, Lance 18:03
Re: how many times Rob Sargent 18:15
Re: how many times Campbell, Lance 18:35
Re: how many times David G. Johnston 19:12
Re: how many times Michael Moore 21:13
Re: how many times Michael Moore 21:19

Aug. 24, 2017

Thread Author Time
Re: how many times Campbell, Lance 14:46
Determining the DATE format with libpq Sebastien FLAESCH 15:21
Re: Determining the DATE format with libpq Tom Lane 15:26
Re: Determining the DATE format with libpq Sebastien FLAESCH 15:44

Aug. 25, 2017

Thread Author Time
Re: Determining the DATE format with libpq Sebastien FLAESCH 08:13
Re: Determining the DATE format with libpq Sebastien FLAESCH 10:09

Aug. 26, 2017

Thread Author Time
Execute format Insert sql failing with query string argument of EXECUTE is null for column with timestamp with timezone anand086 05:38
Re: Execute format Insert sql failing with query string argument of EXECUTE is null for column with timestamp with timezone Pavel Stehule 05:50
Re: Execute format Insert sql failing with query string argument of EXECUTE is null for column with timestamp with timezone anand086 08:04

Aug. 27, 2017

Thread Author Time
Hex to Number conversion anand086 05:28
Re: Hex to Number conversion Andreas Kretschmer 07:25

Browse Archives

Prev | Next