pgsql-sql since 2016-05-05 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 5, 2016

Thread	Author	Time
weird error message	Michael Moore	20:14

May 6, 2016

Thread	Author	Time
Re: weird error message	Adrian Klaver	13:53
Re: weird error message	David G. Johnston	15:22
Re: weird error message	Michael Moore	15:31
Re: weird error message	Tom Lane	16:35
Re: weird error message	David G. Johnston	17:00
Re: weird error message	Tom Lane	17:14
Re: weird error message	Michael Moore	17:30
Re: weird error message	David G. Johnston	17:35

May 10, 2016

Thread	Author	Time
python install defies all efforts and leaves programmer a broken shell of a man	Michael Moore	23:25
Re: python install defies all efforts and leaves programmer a broken shell of a man	Adrian Klaver	23:30
Re: python install defies all efforts and leaves programmer a broken shell of a man	Michael Moore	23:51

May 11, 2016

Thread	Author	Time
Re: python install defies all efforts and leaves programmer a broken shell of a man	Adrian Klaver	00:07
Create a trigger only for certain users	Ezequiel Luis Pellettieri	14:12
Re: Create a trigger only for certain users	Adrian Klaver	14:22
Re: python install defies all efforts and leaves programmer a broken shell of a man	Michael Moore	18:43
Re: python install defies all efforts and leaves programmer a broken shell of a man	Adrian Klaver	20:38
Re: python install defies all efforts and leaves programmer a broken shell of a man	Michael Moore	21:10

May 13, 2016

Thread	Author	Time
oracle_fdw	Desmond Coertzen	14:43
is this a good approach?	Michael Moore	21:52
please ignore question 1 in my previous post	Michael Moore	23:52

May 14, 2016

Thread	Author	Time
Re: Create a trigger only for certain users	Ezequiel Luis Pellettieri	00:26
Re: is this a good approach?	David G. Johnston	01:50
Re: is this a good approach?	Michael Moore	15:46

May 16, 2016

Thread	Author	Time
Re: Create a trigger only for certain users	Ezequiel Luis Pellettieri	19:53

May 17, 2016

Thread	Author	Time
Re: PostgreSQL:ALTER TABLE command hangs forever when DB partitioning is enabled.	Venkatesan, Sekhar	04:47
Handle untype-cast string as VARCHAR instead of TEXT	gmb	12:58
Re: Handle untype-cast string as VARCHAR instead of TEXT	David G. Johnston	13:19
Re: Handle untype-cast string as VARCHAR instead of TEXT	gmb	16:23

May 21, 2016

Thread	Author	Time
SQL query funnel analysis	Maks Materkov	16:52

May 24, 2016

Thread	Author	Time
INOUT text[],OUT text parameter handling problem	Michael Moore	22:19
Re: INOUT text[],OUT text parameter handling problem	David G. Johnston	22:45
Re: INOUT text[],OUT text parameter handling problem	Michael Moore	23:19
Re: INOUT text[],OUT text parameter handling problem	David G. Johnston	23:43

May 25, 2016

Thread	Author	Time
Array casting in where : unexpected behavior	Achilleas Mantzios	06:42
Re: Array casting in where : unexpected behavior	David G. Johnston	12:29
Re: Array casting in where : unexpected behavior	Achilleas Mantzios	12:40
My "variable number of bind variables for dynamic SQL" solution. Comments?	Michael Moore	18:36
Re: My "variable number of bind variables for dynamic SQL" solution. Comments?	David G. Johnston	19:43
quoted csv to array pattern	Michael Moore	23:25
Re: quoted csv to array pattern	David G. Johnston	23:34

May 26, 2016

Thread	Author	Time
Re: quoted csv to array pattern	Michael Moore	00:26
Re: My "variable number of bind variables for dynamic SQL" solution. Comments?	Michael Moore	22:59
Re: My "variable number of bind variables for dynamic SQL" solution. Comments?	David G. Johnston	23:54

May 31, 2016

Thread	Author	Time
Re: My "variable number of bind variables for dynamic SQL" solution. Comments?	Michael Moore	17:24
Re: My "variable number of bind variables for dynamic SQL" solution. Comments?	David G. Johnston	17:28
jdbc and postgresql function session question	Michael Moore	21:20
Re: jdbc and postgresql function session question	Adrian Klaver	22:01
Re: jdbc and postgresql function session question	David G. Johnston	22:36

June 1, 2016

Thread	Author	Time
Re: jdbc and postgresql function session question	Michael Moore	14:29

June 2, 2016

Thread	Author	Time
[No subject]	Max Lipsky	21:31

June 3, 2016

Thread	Author	Time
Re:	Steve Midgley	00:28
Re:	Max Lipsky	01:24
Re:	Max Lipsky	01:42
Re:	Michael Moore	15:15
NOT NULL CHECK (mycol !='') :good idea? bad idea?	Michael Moore	18:16
Re: NOT NULL CHECK (mycol !='') :good idea? bad idea?	David G. Johnston	18:37
Re: NOT NULL CHECK (mycol !='') :good idea? bad idea?	David W Noon	18:56
Re: NOT NULL CHECK (mycol !='') :good idea? bad idea?	Adrian Klaver	19:05
Re: NOT NULL CHECK (mycol !='') :good idea? bad idea?	Michael Moore	19:25

June 9, 2016

Thread	Author	Time
What does it mean? Plan stats and double rainbows.	Michael Moore	21:11
Re: What does it mean? Plan stats and double rainbows.	Thomas Kellerer	21:52
Re: What does it mean? Plan stats and double rainbows.	David G. Johnston	22:33

June 10, 2016

Thread	Author	Time
Re: What does it mean? Plan stats and double rainbows.	Michael Moore	18:12

June 14, 2016

Thread	Author	Time
Subquery with multiple rows		06:22
Re: Subquery with multiple rows	Benjamin Dietrich	09:38
Re: Subquery with multiple rows		12:37
Re: Subquery with multiple rows	David G. Johnston	13:04
Re: Subquery with multiple rows		15:13
Re: Subquery with multiple rows	Mohd Hazmin Zailan	15:42

June 20, 2016

Thread	Author	Time
ANSI JOINS versus , like JOINS 📎	Herwig Goemans	10:06
Re: ANSI JOINS versus , like JOINS	Tom Lane	13:42
Re: ANSI JOINS versus , like JOINS	Herwig Goemans	15:35

June 23, 2016

Thread	Author	Time
Regarding RDS postgresql instance	Mallela, Anil	12:36
Re: [SQL] Regarding RDS postgresql instance	Steve Midgley	17:19
Custom sort order with jsonb key	Anton Ananich	18:38
Re: Custom sort order with jsonb key	David G. Johnston	19:03
Re: Custom sort order with jsonb key	Steve Midgley	19:14
Re: Custom sort order with jsonb key	Anthony Ananich	19:40

June 24, 2016

Thread	Author	Time
Re: Regarding RDS postgresql instance	Mallela, Anil	15:28
Re: Regarding RDS postgresql instance	David G. Johnston	15:51
Re: [SQL] Regarding RDS postgresql instance	Joshua D. Drake	17:19

July 1, 2016

Thread	Author	Time
missing data for column	tel medola	20:20
Re: missing data for column	Adrian Klaver	20:30
Re: missing data for column	tel medola	20:42
Re: missing data for column	Steve Midgley	22:20

July 6, 2016

Thread	Author	Time
Exception handling in Foreign table	Gaurav Tomar	07:39
Re: Exception handling in Foreign table	Adrian Klaver	17:35

July 18, 2016

Thread	Author	Time
posgres optimizer not using the index on hstore HELP	adam	15:18

July 19, 2016

Thread	Author	Time
Re: posgres optimizer not using the index on hstore HELP	Steve Midgley	22:04
Re: posgres optimizer not using the index on hstore HELP	Tom Lane	22:06

July 20, 2016

Thread	Author	Time
Wiindow Aggregate function	Herby Raynaud	21:55

Aug. 20, 2016

Thread	Author	Time
Autoincrement value in a SELECT statement	JORGE MALDONADO	22:44

Aug. 21, 2016

Thread	Author	Time
Re: Autoincrement value in a SELECT statement	Tom Lane	00:09

Aug. 23, 2016

Thread	Author	Time
Display group title only at the first record within each group	CN	16:13

Aug. 24, 2016

Thread	Author	Time
Re: Display group title only at the first record within each group	Harald Fuchs	08:03

Aug. 26, 2016

Thread	Author	Time
Unsupported feature F867: WITH TIES	Jürgen Purtz	13:06
Re: [HACKERS] Unsupported feature F867: WITH TIES	Peter Eisentraut	15:58

Aug. 27, 2016

Thread	Author	Time
error-org.postgresql.Driver for 9.5.3 postgres version	Kavi	07:44
Re: error-org.postgresql.Driver for 9.5.3 postgres version	Andreas Kretschmer	09:11
Re: error-org.postgresql.Driver for 9.5.3 postgres version	Andreas Kretschmer	09:42

Sept. 20, 2016

Thread	Author	Time
PostgreSQL 9.5 operator precedence	Андрей Авакимов	06:02
Re: PostgreSQL 9.5 operator precedence	David G. Johnston	14:10
Re: PostgreSQL 9.5 operator precedence	Tom Lane	14:47

Sept. 22, 2016

Thread	Author	Time
insert values from a ROW object	Michael Moore	21:42
Re: insert values from a ROW object	Michael Moore	21:44
Re: insert values from a ROW object	David G. Johnston	21:55
Re: insert values from a ROW object	Thomas Kellerer	22:20
Re: insert values from a ROW object	Michael Moore	22:38

Sept. 26, 2016

Thread	Author	Time
cvs text to quoted cvs text	Michael Moore	19:23
Re: cvs text to quoted cvs text	Igor Neyman	19:28
Re: cvs text to quoted cvs text	Pavel Stehule	19:33
Re: cvs text to quoted cvs text	Michael Moore	20:09
Re: cvs text to quoted cvs text	Pavel Stehule	20:13
Re: cvs text to quoted cvs text	Michael Moore	22:05

Sept. 29, 2016

Thread	Author	Time
using possibly null timestamptz columns	James Cloos	12:35
Re: using possibly null timestamptz columns	Tom Lane	13:05
Re: using possibly null timestamptz columns	Tom Lane	13:15
Re: using possibly null timestamptz columns	James Cloos	15:48

Oct. 4, 2016

Thread	Author	Time
PLPython and named arguments	Andrey Avakimov	12:20
Re: PLPython and named arguments	Tom Lane	12:37
Re: PLPython and named arguments	Adrian Klaver	13:19
Re: PLPython and named arguments	Andrey Avakimov	13:36

Oct. 6, 2016

Thread	Author	Time
SQL Bug	Bujji Babu	10:22
Re: SQL Bug 📎	Bujji Babu	10:23
Re: SQL Bug	Oleksandr Shulgin	10:44
Re: [BUGS] SQL Bug	Heikki Linnakangas	10:44
Re: [BUGS] SQL Bug	Bujji Babu	10:59
Re: SQL Bug	Heikki Linnakangas	11:07
Re: [BUGS] SQL Bug	Bujji Babu	11:19

Oct. 7, 2016

Thread	Author	Time
row number with in cursor	Kevin Duffy	00:05
Re: row number with in cursor	Adrian Klaver	00:26
Re: row number with in cursor	Kevin Duffy	01:01
Re: row number with in cursor	Adrian Klaver	01:21
Re: row number with in cursor	Thomas Kellerer	05:42
Large Objects	Jürgen Purtz	07:10
Re: Large Objects	Thomas Kellerer	07:24
Re: Large Objects	Pavel Stehule	07:25
Re: Large Objects	Adrian Klaver	13:19
How to get the position of each record in a SELECT statement	JORGE MALDONADO	17:20
Re: How to get the position of each record in a SELECT statement	Stephen Tahmosh	17:31
Re: Large Objects	Jürgen Purtz	19:31
Re: Large Objects	Thomas Kellerer	19:41

Oct. 8, 2016

Thread	Author	Time
Re: How to get the position of each record in a SELECT statement	Adelo Herrero Pérez	07:35
Re: How to get the position of each record in a SELECT statement	Adelo Herrero Pérez	07:44

Oct. 13, 2016

Thread	Author	Time
Table Partitioning with Foreign Data Wrapper	Ranjeet Verma	08:19
Using TEMP ON COMMIT DROP, but need logging too.	Michael Moore	21:24
Re: Using TEMP ON COMMIT DROP, but need logging too.	David G. Johnston	21:48
Re: Using TEMP ON COMMIT DROP, but need logging too.	Michael Moore	21:53

Oct. 14, 2016

Thread	Author	Time
Re: Using TEMP ON COMMIT DROP, but need logging too.	Benjamin Dietrich	07:24
Re: Using TEMP ON COMMIT DROP, but need logging too.	Michael Moore	17:23
Re: Using TEMP ON COMMIT DROP, but need logging too.	David G. Johnston	17:32
Re: Using TEMP ON COMMIT DROP, but need logging too.	Michael Moore	17:35

Oct. 26, 2016

Thread	Author	Time
Fwd: Regarding change in the size of database	harish Reddy	05:01
Re: Fwd: Regarding change in the size of database	Jayadevan M	13:37
Re: Fwd: Regarding change in the size of database	harish Reddy	16:21

Oct. 27, 2016

Thread	Author	Time
Re: Fwd: Regarding change in the size of database	Jayadevan M	03:34
Re: Fwd: Regarding change in the size of database	harish Reddy	11:23
Re: Fwd: Regarding change in the size of database	Michael Moore	23:40

Oct. 31, 2016

Thread	Author	Time
PL/pgSQL Audit Utility	Michael Moore	19:06
Re: PL/pgSQL Audit Utility	Pavel Stehule	19:08
Re: PL/pgSQL Audit Utility	Michael Moore	19:10
Why does the PL/pgSQL compiler do this?	Michael Moore	22:13
Re: Why does the PL/pgSQL compiler do this?	David G. Johnston	22:24
Re: Why does the PL/pgSQL compiler do this?	Michael Moore	22:55
Re: Why does the PL/pgSQL compiler do this?	Michael Moore	23:32
Re: Why does the PL/pgSQL compiler do this?	Adrian Klaver	23:38

Nov. 1, 2016

Thread	Author	Time
Re: Why does the PL/pgSQL compiler do this?	Michael Moore	01:09
Re: Why does the PL/pgSQL compiler do this?	Adrian Klaver	01:20
Re: Why does the PL/pgSQL compiler do this?	Tom Lane	02:38
Re: Why does the PL/pgSQL compiler do this?	Michael Moore	17:36
Re: Why does the PL/pgSQL compiler do this?	Pavel Stehule	17:43

Nov. 2, 2016

Thread	Author	Time
Re: Fwd: Regarding change in the size of database	harish Reddy	17:26
Re: Fwd: Regarding change in the size of database	Michael Moore	19:12
ERROR: out of shared memory	Michael Moore	21:31
Re: ERROR: out of shared memory	David G. Johnston	21:49
Re: ERROR: out of shared memory	Michael Moore	21:52
Re: ERROR: out of shared memory	Michael Moore	22:03
Re: Why does the PL/pgSQL compiler do this?	Pavel Stehule	22:15
Re: ERROR: out of shared memory	David G. Johnston	22:28
Re: ERROR: out of shared memory	David G. Johnston	22:29
Re: ERROR: out of shared memory	Michael Moore	22:33
Re: ERROR: out of shared memory	David G. Johnston	22:33
Re: ERROR: out of shared memory	Michael Moore	22:55
Re: ERROR: out of shared memory	David G. Johnston	23:06
Re: ERROR: out of shared memory	David G. Johnston	23:08
Re: ERROR: out of shared memory	Michael Moore	23:31

Nov. 3, 2016

Thread	Author	Time
Re: Fwd: Regarding change in the size of database	Amitabh Kant	03:50
Re: Fwd: Regarding change in the size of database	harish Reddy	04:36

Nov. 4, 2016

Thread	Author	Time
Re: Fwd: Regarding change in the size of database	Amitabh Kant	04:33

Nov. 11, 2016

Thread	Author	Time
Re: Fwd: Regarding change in the size of database	harish Reddy	05:19
Re: Fwd: Regarding change in the size of database	Amitabh Kant	05:34

Nov. 15, 2016

Thread	Author	Time
Only target lines of text	Michael Moore	01:19
Re: Only target lines of text	Rob Sargent	01:36
Re: Only target lines of text	Tom Lane	01:57
Re: Only target lines of text	Michael Moore	03:07
Re: Only target lines of text	Michael Moore	22:58
Re: Only target lines of text	Tom Lane	23:04
Re: Only target lines of text	Michael Moore	23:10

Nov. 23, 2016

Thread	Author	Time
Dynamic queries for Partitions	Metatrader EA	14:54

Browse Archives

Prev | Next