pgsql-sql since 2016-02-15 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. 15, 2016

Thread	Author	Time
Re: PostgreSQL: Inserting NULL values adds empty string.	Inoue, Hiroshi	11:53

Feb. 16, 2016

Thread	Author	Time
refer function name by a variable in the function body	Suresh Raja	15:41
Re: [SQL] refer function name by a variable in the function body	hubert depesz lubaczewski	16:15

Feb. 17, 2016

Thread	Author	Time
Re: refer function name by a variable in the function body	amulsul	12:54

Feb. 26, 2016

Thread	Author	Time
Query about foreign key details for php framework	David Binney	00:38
Re: Query about foreign key details for php framework	Adrian Klaver	00:49
Re: Query about foreign key details for php framework	David Binney	00:56
Re: Query about foreign key details for php framework	Adrian Klaver	01:05
Re: Query about foreign key details for php framework	David Binney	01:36
Re: Query about foreign key details for php framework	Adrian Klaver	03:11
Re: Query about foreign key details for php framework	David Binney	03:19
Re: Query about foreign key details for php framework	Stuart	05:18
Re: Query about foreign key details for php framework	David Binney	07:29
Re: Query about foreign key details for php framework	Stuart	09:13
Re: Query about foreign key details for php framework	David Binney	09:45
Subselect left join / not exists()	Desmond Coertzen	11:17
Re: Query about foreign key details for php framework	Stuart	12:22
Re: Query about foreign key details for php framework	Stuart	12:28
Re: Subselect left join / not exists()	David G. Johnston	14:53
Re: Subselect left join / not exists()	Tom Lane	15:00
Re: Query about foreign key details for php framework	Adrian Klaver	15:15
Re: Query about foreign key details for php framework	David Binney	18:47
Re: Subselect left join / not exists()	Desmond Coertzen	19:54
Re: Subselect left join / not exists()	Rob Sargent	20:35
Re: Query about foreign key details for php framework	Adrian Klaver	21:33

Feb. 27, 2016

Thread	Author	Time
Re: Query about foreign key details for php framework	David Binney	04:29
Re: Query about foreign key details for php framework	David G. Johnston	07:56
Re: Query about foreign key details for php framework	Adrian Klaver	15:20

Feb. 28, 2016

Thread	Author	Time
Re: Query about foreign key details for php framework	Stuart	09:30
Re: Query about foreign key details for php framework	David Binney	23:42
Re: Query about foreign key details for php framework	David Binney	23:55

Feb. 29, 2016

Thread	Author	Time
Re: Need documentation for PostgreSQL Replication support.	Venkatesan, Sekhar	03:58
Re: Need documentation for PostgreSQL Replication support.	Venkatesan, Sekhar	04:01
Re: Need documentation for PostgreSQL Replication support.	Thomas Kellerer	07:29
Re: Query about foreign key details for php framework	Stuart	08:28
Re: Query about foreign key details for php framework	Adrian Klaver	14:58
Re: Subselect left join / not exists()	Desmond Coertzen	17:17

March 1, 2016

Thread	Author	Time
Re: Need documentation for PostgreSQL Replication support.	Tsunakawa, Takayuki	03:48
Re: Subselect left join / not exists() 📎	Desmond Coertzen	10:24

March 2, 2016

Thread	Author	Time
Re: Query about foreign key details for php framework	David Binney	01:38
Re: Query about foreign key details for php framework	Adrian Klaver	14:56
Re: Query about foreign key details for php framework	David Binney	23:42
Re: Query about foreign key details for php framework	Adrian Klaver	23:45

March 3, 2016

Thread	Author	Time
Re: Query about foreign key details for php framework	David Binney	01:59
Re: Query about foreign key details for php framework	Adrian Klaver	14:17

March 9, 2016

Thread	Author	Time
How does PostgreSQL serializable transaction works? (SELECT/UPDATE vs INSERT conflict)	Alexandru Lazarev	12:18
Fwd: How does PostgreSQL serializable transaction works? (SELECT/UPDATE vs INSERT conflict)	Alexandru Lazarev	19:39
Re: How does PostgreSQL serializable transaction works? (SELECT/UPDATE vs INSERT conflict)	David G. Johnston	20:03
Re: Fwd: How does PostgreSQL serializable transaction works? (SELECT/UPDATE vs INSERT conflict)	Jeff Janes	20:37
Re: Fwd: How does PostgreSQL serializable transaction works? (SELECT/UPDATE vs INSERT conflict)	Kevin Grittner	22:41

March 10, 2016

Thread	Author	Time
Re: [GENERAL] Fwd: How does PostgreSQL serializable transaction works? (SELECT/UPDATE vs INSERT conflict)	Alexandru Lazarev	19:50
Re: Fwd: How does PostgreSQL serializable transaction works? (SELECT/UPDATE vs INSERT conflict)	Kevin Grittner	19:58

March 13, 2016

Thread	Author	Time
Re: Subselect left join / not exists()	Tom Lane	23:13

March 14, 2016

Thread	Author	Time
Re: Subselect left join / not exists()	Desmond Coertzen	09:40
Re: Subselect left join / not exists()	Tom Lane	13:42

March 16, 2016

Thread	Author	Time
delete taking long time	ivo liondov	00:10
Re: delete taking long time	Andreas Kretschmer	01:12
Re: delete taking long time	David G. Johnston	01:24
Re: delete taking long time	David G. Johnston	01:25
Re: delete taking long time	Andreas Kretschmer	01:34
Re: delete taking long time	Mike Sofen	01:49
Re: delete taking long time	ivo liondov	11:06
Re: delete taking long time	Andreas Kretschmer	11:57
Re: delete taking long time	Mike Sofen	12:31
Re: delete taking long time	ivo liondov	13:07
Re: delete taking long time	ivo liondov	13:13
Re: delete taking long time	Andreas Kretschmer	16:08

March 18, 2016

Thread	Author	Time
Enhancement to SQL query capabilities	Andrew Smith	05:04
Re: Enhancement to SQL query capabilities	David G. Johnston	05:54
Fwd: Enhancement to SQL query capabilities	Andrew Smith	07:00
Re: Fwd: Enhancement to SQL query capabilities	Martin Edlman	07:20
Re: Enhancement to SQL query capabilities	Mike Sofen	12:21
Re: Enhancement to SQL query capabilities	Tom Lane	13:17
recursive WITH nested union ALL with NOCYCLE logic	Michael Moore	21:06
Re: recursive WITH nested union ALL with NOCYCLE logic	David G. Johnston	21:32
Re: Enhancement to SQL query capabilities	Andrew Smith	22:09
Re: recursive WITH nested union ALL with NOCYCLE logic	Michael Moore	23:11

March 19, 2016

Thread	Author	Time
Re: recursive WITH nested union ALL with NOCYCLE logic	David G. Johnston	01:03

March 21, 2016

Thread	Author	Time
plan not correct? 📎	Bert	14:03
Re: plan not correct?	Adrian Klaver	14:39
Re: [SQL] plan not correct?	Adrian Klaver	15:01
Re: [SQL] plan not correct?	Bert	15:29
Re: plan not correct?	Adrian Klaver	15:38
Re: [SQL] plan not correct?	Adrian Klaver	15:40
Re: [SQL] plan not correct?	Adrian Klaver	16:01
Re: plan not correct?	Adrian Klaver	16:04
Re: recursive WITH nested union ALL with NOCYCLE logic	Michael Moore	18:38

March 23, 2016

Thread	Author	Time
simple function index question	Michael Moore	00:23
Re: simple function index question	David G. Johnston	00:39
Re: simple function index question	Rosser Schwarz	00:54
Re: simple function index question	Igor Neyman	12:56
Re: simple function index question	Michael Moore	15:14
Re: simple function index question	bricklen	15:34
Re: simple function index question	Igor Neyman	15:57
Re: simple function index question	Igor Neyman	16:10
Re: simple function index question	David G. Johnston	16:10
Re: simple function index question	Igor Neyman	16:30
query based on row number for psql8.3	Emi	18:00
Re: query based on row number for psql8.3	Adrian Klaver	18:07
Re: query based on row number for psql8.3	Stephen Tahmosh	18:09
Re: query based on row number for psql8.3	Stephen Tahmosh	18:13
Re: query based on row number for psql8.3	David G. Johnston	18:14
Re: query based on row number for psql8.3	Stephen Tahmosh	18:15
Re: query based on row number for psql8.3	Adrian Klaver	18:17
Re: query based on row number for psql8.3	Rob Sargent	18:26
Re: query based on row number for psql8.3	Stephen Tahmosh	18:57
Re: simple function index question	Michael Moore	19:24
Re: query based on row number for psql8.3	Michael Moore	20:34

March 28, 2016

Thread	Author	Time
need advice for simple web development tools	Michael Moore	22:51
Re: need advice for simple web development tools	Adrian Klaver	22:58
Re: need advice for simple web development tools	Steve Midgley	23:27
Re: need advice for simple web development tools	David Binney	23:41

March 29, 2016

Thread	Author	Time
Re: need advice for simple web development tools	Michael Moore	00:17
Re: need advice for simple web development tools	Dmitrii Ruban	22:49
how plsql work on postgresql	Selina Tech	22:57
Re: how plsql work on postgresql	Adrian Klaver	23:16
Re: how plsql work on postgresql	David G. Johnston	23:19

March 30, 2016

Thread	Author	Time
Re: how plsql work on postgresql	Michael Moore	15:23
Re: how plsql work on postgresql	Thomas Kellerer	15:37
Re: how plsql work on postgresql	Michael Moore	17:13
Re: how plsql work on postgresql	Selina Tech	17:56

April 4, 2016

Thread	Author	Time
SQL query syntax question	Alexander Levsha	07:19
SQL query syntax question	Alexander Levsha	07:23
Re: SQL query syntax question	David G. Johnston	07:54
Re: SQL query syntax question	Alexander Levsha	08:12

April 5, 2016

Thread	Author	Time
Geometry vs Geography (what to use)	Michael Moore	00:20
Re: Geometry vs Geography (what to use)	Steve Midgley	01:09
Postgres Streaming replication (version:9.4)	Mallela, Anil	04:40
Re: Geometry vs Geography (what to use)	Michael Moore	15:28
Re: Geometry vs Geography (what to use)	Lee Hachadoorian	17:07
Re: Geometry vs Geography (what to use)	Michael Moore	21:56

April 6, 2016

Thread	Author	Time
Re: Geometry vs Geography (what to use) 📎	Lee Hachadoorian	02:16
Postgres Streaming replication (version:9.4)	Mallela, Anil	11:53
Re: Geometry vs Geography (what to use)	Michael Moore	20:07
Re: Geometry vs Geography (what to use)	Lee Hachadoorian	20:39

April 7, 2016

Thread	Author	Time
Re: [SQL] Postgres Streaming replication (version:9.4)	Jayadevan M	03:24
postgresql cpu question	李嘉	04:37
Re: postgresql cpu question	Steve Midgley	04:46
答复: [SQL] postgresql cpu question	李嘉	06:43

April 8, 2016

Thread	Author	Time
ST_DWithin not using meters even when SRID unit = "metre"	Michael Moore	23:11

April 11, 2016

Thread	Author	Time
Connection to database failed: FATAL: no pg_hba.conf entry for host	Chris	22:31

April 12, 2016

Thread	Author	Time
Re: Connection to database failed: FATAL: no pg_hba.conf entry for host	Adrian Klaver	22:56
Re: Connection to database failed: FATAL: no pg_hba.conf entry for host	Chris	23:19

April 13, 2016

Thread	Author	Time
Re: Connection to database failed: FATAL: no pg_hba.conf entry for host	Dhaval Patel	02:28
Re: Re: Connection to database failed: FATAL: no pg_hba.conf entry for host	Adrian Klaver	14:50
Re: Connection to database failed: FATAL: no pg_hba.conf entry for host	Chris	16:22

April 19, 2016

Thread	Author	Time
org.postgresql.util.PSQLException: ERROR: index row requires more memory than default(8191)	msn	06:05

April 20, 2016

Thread	Author	Time
Re: org.postgresql.util.PSQLException: ERROR: index row requires more memory than default(8191)	David G. Johnston	01:34

April 21, 2016

Thread	Author	Time
PostgreSQL:ALTER TABLE command hangs forever when DB partitioning is enabled.	Venkatesan, Sekhar	09:01
Re: PostgreSQL:ALTER TABLE command hangs forever when DB partitioning is enabled.	Venkatesan, Sekhar	09:08
Re: PostgreSQL:ALTER TABLE command hangs forever when DB partitioning is enabled.	Venkatesan, Sekhar	10:23
Re: Re: PostgreSQL:ALTER TABLE command hangs forever when DB partitioning is enabled.	Adrian Klaver	14:16

April 22, 2016

Thread	Author	Time
How to get pgsql to echo commands in a command file	Michael Moore	22:50
Re: How to get pgsql to echo commands in a command file	David G. Johnston	22:58
Re: How to get pgsql to echo commands in a command file	Adrian Klaver	22:58
Re: How to get pgsql to echo commands in a command file	Michael Moore	23:04

April 25, 2016

Thread	Author	Time
Re: Re: PostgreSQL:ALTER TABLE command hangs forever when DB partitioning is enabled.	Venkatesan, Sekhar	05:47

April 26, 2016

Thread	Author	Time
Re: org.postgresql.util.PSQLException: ERROR: index row requires more memory than default(8191)	msn	10:35
Getting the queried result in the form of json structure	msn	11:32
Re: Getting the queried result in the form of json structure	Hector Vass	14:08

April 29, 2016

Thread	Author	Time
Re: Getting the queried result in the form of json structure	msn	09:40
Re: Getting the queried result in the form of json structure	Adrian Klaver	14:02
Re: Getting the queried result in the form of json structure	David G. Johnston	16:16
Re: Getting the queried result in the form of json structure	Stephen Tahmosh	16:20
Re: Getting the queried result in the form of json structure	David G. Johnston	16:33

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

Browse Archives

Prev | Next