pgsql-sql since 2014-06-11 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

June 11, 2014

Thread Author Time
Re: need to pass the csv file name as value to the column file_id David G Johnston 13:38
Re: need to pass the csv file name as value to the column file_id David G Johnston 13:42
Re: need to pass the csv file name as value to the column file_id David G Johnston 14:35
Re: need to pass the csv file name as value to the column file_id David G Johnston 16:03

June 12, 2014

Thread Author Time
Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 09:17
Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 09:31
Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables David G Johnston 14:02
Re: Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 19:32
Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables David G Johnston 19:49
Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables David G Johnston 19:52
Re: Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 20:04
Re: Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 20:07
Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables David G Johnston 20:36
Re: Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 21:28

June 13, 2014

Thread Author Time
cannot install 9.4 on trusty because of the libpq5 version rawi 14:01
Re: cannot install 9.4 on trusty because of the libpq5 version Adrian Klaver 14:31
Re: cannot install 9.4 on trusty because of the libpq5 version rawi 14:49

July 23, 2014

Thread Author Time
Is CREATE TABLE non-blocking ? Benjamin Dugast 10:33
Re: Is CREATE TABLE non-blocking ? hubert depesz lubaczewski 13:43
Re: Is CREATE TABLE non-blocking ? David G Johnston 14:18
Re: Is CREATE TABLE non-blocking ? Benjamin Dugast 15:13
Re: Is CREATE TABLE non-blocking ? Rob Sargent 15:52

July 24, 2014

Thread Author Time
Re: Is CREATE TABLE non-blocking ? Benjamin Dugast 08:36

July 25, 2014

Thread Author Time
Re: PGsql function timestamp issue Vinayak Pokale 08:59

July 29, 2014

Thread Author Time
Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 09:52
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 09:56
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 09:59
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 10:01
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 10:05
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 10:12
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 10:21
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 10:27
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 10:38
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 10:49
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 11:22
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 11:31

July 30, 2014

Thread Author Time
Reg: Sql Join CrashBandi 22:08
Re: Reg: Sql Join David G Johnston 22:45
Re: Reg: Sql Join David G Johnston 22:49
Re: Reg: Sql Join Oliver d'Azevedo Christina 23:09
Re: Reg: Sql Join Gavin Flower 23:34
Re: Reg: Sql Join Gavin Flower 23:43

July 31, 2014

Thread Author Time
Re: Reg: Sql Join CrashBandi 19:34

Aug. 1, 2014

Thread Author Time
PostgreSQL add id column that increments based on data DerekW 09:15
Re: PostgreSQL add id column that increments based on data Jonas Xie 09:55
Re: PostgreSQL add id column that increments based on data Adrian Klaver 13:30
Re: PostgreSQL add id column that increments based on data David G Johnston 16:12

Aug. 4, 2014

Thread Author Time
Re: PostgreSQL add id column that increments based on data DerekW 08:35

Aug. 5, 2014

Thread Author Time
function call Marcin Krawczyk 11:28
Re: function call Adrian Klaver 12:56
Re: function call Adrian Klaver 13:01

Aug. 6, 2014

Thread Author Time
Re: function call Marcin Krawczyk 07:05
Re: function call Marcin Krawczyk 07:41
Re: function call John L. Poole 12:03
Re: function call Adrian Klaver 13:58

Aug. 10, 2014

Thread Author Time
Update Returning as subquery pascal+postgres 16:15
Re: Update Returning as subquery Tom Lane 17:17
Re: Update Returning as subquery David G Johnston 18:10

Aug. 11, 2014

Thread Author Time
Re: function call Marcin Krawczyk 09:50
Re: function call Marcin Krawczyk 11:13
How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' Andreas Joseph Krogh 16:01
Re: function call David G Johnston 16:13
Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' Igor Neyman 18:38
Re: function call Adrian Klaver 19:01
Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' Pavel Stehule 19:34
Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' SENADIN 19:49
Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' Andreas Joseph Krogh 20:08
Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' Andreas Joseph Krogh 20:19
Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' Pavel Stehule 20:29

Aug. 15, 2014

Thread Author Time
Stack builder Shane Carey 12:54
Re: Stack builder Rene Romero Benavides 15:08

Aug. 17, 2014

Thread Author Time
High memory usage / performance issue ( temp tables ? ) gmb 07:35
Re: High memory usage / performance issue ( temp tables ? ) Marc Mamin 08:50
Re: High memory usage / performance issue ( temp tables ? ) gmb 10:40
Re: High memory usage / performance issue ( temp tables ? ) gmb 19:47
Re: High memory usage / performance issue ( temp tables ? ) Pavel Stehule 19:55

Aug. 18, 2014

Thread Author Time
Re: High memory usage / performance issue ( temp tables ? ) gmb 05:33
Re: High memory usage / performance issue ( temp tables ? ) Pavel Stehule 06:44
Re: function call Marcin Krawczyk 07:57
Re: High memory usage / performance issue ( temp tables ? ) gmb 11:03
Re: High memory usage / performance issue ( temp tables ? ) gmb 11:20
Re: High memory usage / performance issue ( temp tables ? ) Pavel Stehule 12:29
Re: function call Adrian Klaver 22:16

Aug. 22, 2014

Thread Author Time
Retrieve most recent 1 record from joined table agharta 08:05
Re: Retrieve most recent 1 record from joined table Brice André 08:13
Re: Retrieve most recent 1 record from joined table agharta 08:48

Aug. 23, 2014

Thread Author Time
Re: Retrieve most recent 1 record from joined table Vik Fearing 12:15
postgres json: How to query map keys to get children Hector Menchaca 18:02
Re: postgres json: How to query map keys to get children David G Johnston 20:18
Re: postgres json: How to query map keys to get children Hector Menchaca 23:38

Aug. 25, 2014

Thread Author Time
Re: Retrieve most recent 1 record from joined table Thomas Kellerer 05:59

Aug. 27, 2014

Thread Author Time
Re: Retrieve most recent 1 record from joined table agharta 09:04

Sept. 3, 2014

Thread Author Time
xpath does not seem to escape HTML correctly John Lamb 23:47

Sept. 4, 2014

Thread Author Time
Re: xpath does not seem to escape HTML correctly David G Johnston 01:50

Sept. 8, 2014

Thread Author Time
VF0072 - Operating System Compatibility for Application PostgreSQL 8.3 Bijayalakshmi Swain 08:48
Re: VF0072 - Operating System Compatibility for Application PostgreSQL 8.3 Adrian Klaver 18:21

Sept. 9, 2014

Thread Author Time
VF0258 - Operating System Compatibility for Application PostgreSQL 9.2 Bijayalakshmi Swain 05:04

Sept. 12, 2014

Thread Author Time
Re: VF0072 - Operating System Compatibility for Application PostgreSQL 8.3 Alvaro Herrera 04:12
Re: VF0072 - Operating System Compatibility for Application PostgreSQL 8.3 Bruce Momjian 11:28
Re: VF0258 - Operating System Compatibility for Application PostgreSQL 9.2 Bruce Momjian 11:32
Re: VF0072 - Operating System Compatibility for Application PostgreSQL 8.3 Craig Ringer 15:55

Sept. 15, 2014

Thread Author Time
Re: How to compare two tables in PostgreSQL Kamal Kumar TRR 10:43

Sept. 17, 2014

Thread Author Time
pg_multixact issues Dev Kumkar 12:16
Re: pg_multixact issues Adrian Klaver 13:21
Re: pg_multixact issues Andres Freund 13:23
Re: [SQL] pg_multixact issues Dev Kumkar 13:50
Re: pg_multixact issues Dev Kumkar 13:51
Re: [SQL] pg_multixact issues Dev Kumkar 14:54
Re: [SQL] pg_multixact issues Dev Kumkar 20:36
Re: pg_multixact issues Adrian Klaver 21:08
Re: [SQL] pg_multixact issues Adrian Klaver 21:11

Sept. 18, 2014

Thread Author Time
Re: pg_multixact issues Dev Kumkar 09:11
Re: [SQL] pg_multixact issues Andres Freund 10:33
Re: [GENERAL] pg_multixact issues Dev Kumkar 12:50
Re: [GENERAL] [SQL] pg_multixact issues Dev Kumkar 17:22
Re: [GENERAL] [SQL] pg_multixact issues Adrian Klaver 21:47

Sept. 19, 2014

Thread Author Time
Re: [GENERAL] pg_multixact issues Alvaro Herrera 02:37
Re: [GENERAL] pg_multixact issues Andres Freund 07:33
Re: [SQL] pg_multixact issues Dev Kumkar 07:51
Re: [GENERAL] pg_multixact issues Dev Kumkar 07:53
Re: pg_multixact issues Emanuel Calvo 13:44
Re: pg_multixact issues Dev Kumkar 14:09

Sept. 23, 2014

Thread Author Time
FOREIGN KEY Reference on multiple columns 09:54
Re: FOREIGN KEY Reference on multiple columns Luca Vernini 09:59
Re: FOREIGN KEY Reference on multiple columns 11:38
Re: FOREIGN KEY Reference on multiple columns Luca Vernini 12:36
Re: FOREIGN KEY Reference on multiple columns 13:10
Re: FOREIGN KEY Reference on multiple columns Adrian Klaver 13:15
Re: FOREIGN KEY Reference on multiple columns Luca Vernini 13:17
Re: FOREIGN KEY Reference on multiple columns 13:38

Sept. 24, 2014

Thread Author Time
Re: FOREIGN KEY Reference on multiple columns Tim Landscheidt 18:02

Sept. 25, 2014

Thread Author Time
Re: FOREIGN KEY Reference on multiple columns 05:04
uuid for each postgres install? Gerardo Herzig 20:02
Re: uuid for each postgres install? Adrian Klaver 20:18
Re: uuid for each postgres install? Gerardo Herzig 21:56
Re: uuid for each postgres install? Ian Lawrence Barwick 22:32

Sept. 26, 2014

Thread Author Time
Re: [GENERAL] pg_multixact issues Dev Kumkar 08:06

Sept. 28, 2014

Thread Author Time
how to see "where" SQL is better than PLPGSQL Gerardo Herzig 18:30
Re: [SQL] how to see "where" SQL is better than PLPGSQL Pavel Stehule 18:49
Re: [SQL] how to see "where" SQL is better than PLPGSQL Gerardo Herzig 19:29
Re: how to see "where" SQL is better than PLPGSQL Pavel Stehule 19:44

Sept. 29, 2014

Thread Author Time
Re: Why data returned inside parentheses in for loop David G Johnston 19:34
Re: Why data returned inside parentheses in for loop David G Johnston 21:16
Re: Why data returned inside parentheses in for loop David G Johnston 21:18

Sept. 30, 2014

Thread Author Time
Re: [SQL] pg_multixact issues Dev Kumkar 15:10
Re: [SQL] pg_multixact issues Alvaro Herrera 15:20
Re: [SQL] pg_multixact issues Dev Kumkar 19:32

Oct. 5, 2014

Thread Author Time
Function with OUT parameter and Return Query Hector Menchaca 04:23
Re: Function with OUT parameter and Return Query Guillaume Lelarge 08:06
Re: Function with OUT parameter and Return Query Hector Menchaca 18:10

Oct. 8, 2014

Thread Author Time
could not access status of transaction pg_multixact issue jim_yates 18:00
Re: could not access status of transaction pg_multixact issue Adrian Klaver 18:40
Re: could not access status of transaction pg_multixact issue Alvaro Herrera 18:55
Re: could not access status of transaction pg_multixact issue jim_yates 19:43
Re: could not access status of transaction pg_multixact issue Alvaro Herrera 20:54
Re: could not access status of transaction pg_multixact issue jim_yates 21:26

Oct. 9, 2014

Thread Author Time
Re: could not access status of transaction pg_multixact issue jim_yates 14:07
Re: could not access status of transaction pg_multixact issue Adrian Klaver 15:01
Re: could not access status of transaction pg_multixact issue Alvaro Herrera 15:12
Re: could not access status of transaction pg_multixact issue jim_yates 17:02
Re: could not access status of transaction pg_multixact issue Alvaro Herrera 18:00
Re: could not access status of transaction pg_multixact issue jim_yates 20:17
Re: could not access status of transaction pg_multixact issue Alvaro Herrera 20:36
Re: could not access status of transaction pg_multixact issue jim_yates 21:51

Oct. 10, 2014

Thread Author Time
Re: could not access status of transaction pg_multixact issue jim_yates 14:37
Re: could not access status of transaction pg_multixact issue Alvaro Herrera 16:26

Oct. 15, 2014

Thread Author Time
Any postgres API available to get errorcode for PQerrorMessage Roopeshakumar Narayansa Shalgar (rshalgar) 08:17
Re: [GENERAL] Any postgres API available to get errorcode for PQerrorMessage Tom Lane 16:36
Re: Any postgres API available to get errorcode for PQerrorMessage Rob Sargent 16:37
Re: [GENERAL] Any postgres API available to get errorcode for PQerrorMessage Roopeshakumar Narayansa Shalgar (rshalgar) 16:48
Re: Any postgres API available to get errorcode for PQerrorMessage John R Pierce 17:21

Oct. 16, 2014

Thread Author Time
Re: Any postgres API available to get errorcode for PQerrorMessage Yogesh. Sharma 03:10
Re: library path problems? (was: Completely unrelated) John R Pierce 03:21
Re: library path problems? Adrian Klaver 03:45
Re: Any postgres API available to get errorcode for PQerrorMessage Roopeshakumar Narayansa Shalgar (rshalgar) 07:09
Re: Any postgres API available to get errorcode for PQerrorMessage Adrian Klaver 20:09

Oct. 30, 2014

Thread Author Time
querying within json Tim Dudgeon 14:55
Re: querying within json Giuseppe Broccolo 15:22
[OFFTOPIC] unsubscribe list Roberto Oliveira dos Santos 15:28
Re: [OFFTOPIC] unsubscribe list Adrian Klaver 15:58
Re: querying within json Tim Dudgeon 16:24
Re: querying within json David G Johnston 16:48
return encoding results 📎 Emi Lu 17:37
Re: return encoding results Andreas Kretschmer 17:45
Re: querying within json Tim Dudgeon 19:22

Oct. 31, 2014

Thread Author Time
INT8 / float casting question Filip Rembiałkowski 14:58
best strategy for searching large text fields Campbell, Lance 14:59
Re: INT8 / float casting question [email protected] 15:15
Re: best strategy for searching large text fields Julien Cigar 15:17
Re: INT8 / float casting question Adrian Klaver 15:29
Re: INT8 / float casting question Adrian Klaver 15:45

Nov. 3, 2014

Thread Author Time
Text searching HTML Campbell, Lance 17:15
Re: Text searching HTML Tom Lane 20:09

Nov. 4, 2014

Thread Author Time
text search index help Campbell, Lance 04:56

Nov. 5, 2014

Thread Author Time
Bug or feature in AFTER INSERT trigger? Martin Edlman 13:00
Re: Bug or feature in AFTER INSERT trigger? hubert depesz lubaczewski 14:06

Nov. 7, 2014

Thread Author Time
filtering based on table of start/end times Seb 20:12
Re: filtering based on table of start/end times Tim 21:14
Re: filtering based on table of start/end times Bryan L Nuse 21:58

Nov. 8, 2014

Thread Author Time
Using aggregates to get sums and partial sums in one query Andreas Joseph Krogh 01:18

Browse Archives

Prev | Next