pgsql-sql before 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

Feb. 4, 2016

Thread Author Time
Re: [SQL] Q: documentation bug ? Fabrízio de Royes Mello 17:56
Re: Create db fails using utility tool Adrian Klaver 18:04
Re: update without SET ? Michael Moore 19:19

Feb. 5, 2016

Thread Author Time
Re: Create db fails using utility tool Shashank Dutt Jha 04:15
Re: Create db fails using utility tool Adrian Klaver 06:08

Feb. 9, 2016

Thread Author Time
Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Venkatesan, Sekhar 04:29
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Tom Lane 05:00
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Venkatesan, Sekhar 05:21
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Rob Sargent 05:33
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. David G. Johnston 05:47
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Venkatesan, Sekhar 05:48
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. David G. Johnston 05:50
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Venkatesan, Sekhar 05:53
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Rob Sargent 05:57
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. David G. Johnston 06:00
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Adrian Klaver 06:01
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. David G. Johnston 06:03
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Venkatesan, Sekhar 06:14
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. David G. Johnston 06:21
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Thomas Kellerer 06:43
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Mike Sofen 12:41
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Stuart 16:14

Feb. 10, 2016

Thread Author Time
Need documentation for PostgreSQL Replication support. Venkatesan, Sekhar 06:36
Re: Need documentation for PostgreSQL Replication support. Thomas Kellerer 06:52
inserting json content from a file into table column Shashank Dutt Jha 15:10
Re: inserting json content from a file into table column Adrian Klaver 15:22
Re: inserting json content from a file into table column Shashank Dutt Jha 16:01
Re: inserting json content from a file into table column Adrian Klaver 16:34
Re: inserting json content from a file into table column David G. Johnston 16:50

Feb. 11, 2016

Thread Author Time
Re: inserting json content from a file into table column Shashank Dutt Jha 06:11

Feb. 14, 2016

Thread Author Time
PostgreSQL: Inserting NULL values adds empty string. Venkatesan, Sekhar 13:13
Re: [ODBC] PostgreSQL: Inserting NULL values adds empty string. Adrian Klaver 16:48
Re: PostgreSQL: Inserting NULL values adds empty string. Venkatesan, Sekhar 18:08
Re: PostgreSQL: Inserting NULL values adds empty string. Thomas Kellerer 18:21
Re: PostgreSQL: Inserting NULL values adds empty string. Adrian Klaver 18:36

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

Browse Archives

Prev | Next