pgsql-sql since 2016-03-29 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

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
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

Browse Archives

Prev | Next