Home > mailing lists

Mailing lists [pgsql-general]

1 December 2011

04:47 Problem with custom aggregates and record pseudo-type Maxim Boguk
05:00 Re: How to restore the table space tar files created by pg_basebackup? Venkat Balaji
07:05 Re: Is it possible to make a streaming replication faster using COPY instead of lots of INSERTS? Sergey Konoplev
07:09 Re: Is it possible to make a streaming replication faster using COPY instead of lots of INSERTS? Sergey Konoplev
07:56 Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)? Tomas Vondra
08:34 Re: Strange problem with turning WAL archiving on Albe Laurenz
10:45 How to get Place Names from Lat Lon Adarsh Sharma
10:50 Problem with binary data transfer format of TEXT in 8.4 Gracjan Polak
10:58 Re: psql query gets stuck indefinitely tamanna madaan
11:17 Conditional left join Amitabh Kant
11:27 Re: Conditional left join Alban Hertroys
11:36 Re: How to restore the table space tar files created by pg_basebackup? Samba
11:48 Streaming Replication Over SSL Samba
12:07 Replication issue Jim Buttafuoco
12:46 Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)? Tomas Vondra
12:58 Re: psql query gets stuck indefinitely Tomas Vondra
13:55 Re: How to restore the table space tar files created by pg_basebackup? Magnus Hagander
13:56 Re: Streaming Replication Over SSL Magnus Hagander
14:10 session hang for same row update AI Rumman
14:23 Re: session hang for same row update Adrian Klaver
15:19 Re: Problem with custom aggregates and record pseudo-type Tom Lane
17:59 recursive inner trigger call Red Light
18:09 Re: recursive inner trigger call Gauthier, Dave
18:19 Re: recursive inner trigger call Red Light
18:21 problem with restore: collision id`s lob Hellmuth Vargas
18:32 Re: recursive inner trigger call David Johnston
18:32 Re: recursive inner trigger call Bèrto ëd Sèra
18:37 Re: recursive inner trigger call Red Light
18:52 Re: Problem with custom aggregates and record pseudo-type Maxim Boguk
20:13 returning rows from an implicit JOIN where results either exist in both tables OR only one table Lonni J Friedman
20:58 Re: returning rows from an implicit JOIN where results either exist in both tables OR only one table David Johnston
21:01 psql -1 with multiple files? Jay Levitt
22:29 Re: psql -1 with multiple files? Steve Crawford
23:01 Re: psql -1 with multiple files? Jay Levitt
23:50 Re: Query Optimizer makes a poor choice Marcin Mańk

2 December 2011

00:08 Postgresql + corrupted disk = data loss. (Need help for database recover) Oleg Serov
00:10 Re: Postgresql + corrupted disk = data loss. (Need help for database recover) Oleg Serov
00:36 Re: returning rows from an implicit JOIN where results either exist in both tables OR only one table Lonni J Friedman
02:49 Re: Postgresql + corrupted disk = data loss. (Need help for database recover) Venkat Balaji
07:17 Re: Postgresql + corrupted disk = data loss. (Need help for database recover) Oleg Serov
12:47 How to convert HEX to ASCII? Torsten Zuehlsdorff
12:59 Re: How to convert HEX to ASCII? Damien Churchill
13:02 sql statements using access frontend Gavin Mitchell
13:29 Re: sql statements using access frontend Richard Huxton
13:29 Re: Query Optimizer makes a poor choice Tyler Hains
13:46 Re: How to convert HEX to ASCII? Torsten Zuehlsdorff
14:05 order by, within a plpgsql fx
14:43 Re: order by, within a plpgsql fx Tom Lane
14:46 Re: How to convert HEX to ASCII? Merlin Moncure
15:10 Re: odbc_fdw
15:12 Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)? Merlin Moncure
15:13 Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)? Magnus Hagander
15:13 sql statements using access frontend Gavin Mitchell
15:42 Re: How to convert HEX to ASCII? Marti Raudsepp
15:59 Re: How to convert HEX to ASCII? Merlin Moncure
16:16 Re: How to convert HEX to ASCII? Pavel Stehule
18:47 Re: How to convert HEX to ASCII? Merlin Moncure
19:02 Re: How to convert HEX to ASCII? Pavel Stehule
19:14 \dT+ does not give elements ? Gauthier, Dave
19:19 Oddball data distribution giving me planner headaches Jeff Amiel
19:38 Re: Oddball data distribution giving me planner headaches David Johnston
19:52 Re: Oddball data distribution giving me planner headaches Jeff Amiel
19:57 Re: How to convert HEX to ASCII? Merlin Moncure
20:02 Re: How to convert HEX to ASCII? Pavel Stehule
20:04 Re: Oddball data distribution giving me planner headaches David Johnston
20:15 Re: Oddball data distribution giving me planner headaches Jeff Amiel
20:37 Re: Oddball data distribution giving me planner headaches David Johnston
20:55 Re: \dT+ does not give elements ? Tom Lane
21:06 Re: Oddball data distribution giving me planner headaches Jeff Amiel
21:09 Re: Oddball data distribution giving me planner headaches Tom Lane
21:16 Re: Oddball data distribution giving me planner headaches David Johnston
21:20 Re: Oddball data distribution giving me planner headaches Jeff Amiel
21:23 Re: Oddball data distribution giving me planner headaches Jeff Amiel
21:37 weird negative seconds on checkpoint message. Ing.Edmundo.Robles.Lopez
21:50 Re: weird negative seconds on checkpoint message. Adrian Klaver
21:53 Re: weird negative seconds on checkpoint message. Ing.Edmundo.Robles.Lopez
22:11 Re: Oddball data distribution giving me planner headaches Jeff Amiel
22:13 Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. Andre Lopes
22:28 Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. David Johnston
22:35 Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. Adrian Klaver
22:37 Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. John R Pierce
22:41 Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. Andre Lopes
22:46 Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. John R Pierce
22:52 Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. Andre Lopes

3 December 2011

01:37 gouse shaik
02:02 Re: PostgreSQL 9.0 and asynchronous replication through VPN Edson Richter
06:23 Re: Postgresql + corrupted disk = data loss. (Need help for database recover) Craig Ringer
08:13 Re: Oddball data distribution giving me planner headaches Harald Fuchs
11:40 Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke
13:10 Re: Postgresql + corrupted disk = data loss. (Need help for database recover) Tomas Vondra
13:35 Re: Shared memory usage in PostgreSQL 9.1 Tomas Vondra
13:46 Re: How to convert HEX to ASCII? Torsten Zühlsdorff
14:31 Re: Postgresql + corrupted disk = data loss. (Need help for database recover) Oleg Serov
16:02 Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke
16:39 Re: Shared memory usage in PostgreSQL 9.1 Tom Lane
16:50 returning results from plsql function to plpythonu function c k
16:55 Re: [ADMIN] returning results from plsql function to plpythonu function Lou Picciano
17:01 Re: [ADMIN] returning results from plsql function to plpythonu function c k
17:15 Re: [ADMIN] returning results from plsql function to plpythonu function c k
17:24 Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke
17:51 Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke
17:51 Re: [ADMIN] returning results from plsql function to plpythonu function Lou Picciano
18:31 Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke
18:33 Re: [ADMIN] returning results from plsql function to plpythonu function c k
19:16 Re: How to get Place Names from Lat Lon Josh Kupershmidt
20:33 Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke
20:33 Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke

4 December 2011

09:19 Foreign keys question (performance) Phoenix Kiula
10:14 Re: Foreign keys question (performance) Alban Hertroys
10:32 Weird behavior: deleted row still in index? Phoenix Kiula
10:41 Re: Foreign keys question (performance) Phoenix Kiula
10:51 Re: Weird behavior: deleted row still in index? Alban Hertroys
10:55 Re: Weird behavior: deleted row still in index? Szymon Guz
11:57 Re: Weird behavior: deleted row still in index? Phoenix Kiula
13:06 Re: Shared memory usage in PostgreSQL 9.1 Stephen Frost
13:09 Re: Shared memory usage in PostgreSQL 9.1 sfrost@snowman.net
13:34 Re: Shared memory usage in PostgreSQL 9.1 Tomas Vondra
14:20 Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke
20:24 Re: Shared memory usage in PostgreSQL 9.1 Tom Lane

5 December 2011

02:29 WITH and WITH RECURSIVE in single query Maxim Boguk
02:42 Re: WITH and WITH RECURSIVE in single query Tom Lane
02:44 Questions about setting an array element value outside of the update Maxim Boguk
02:45 Re: WITH and WITH RECURSIVE in single query David Johnston
02:59 Re: WITH and WITH RECURSIVE in single query Maxim Boguk
03:04 Re: Questions about setting an array element value outside of the update David Johnston
03:07 pl/pgsql and arrays[] Maxim Boguk
03:10 What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Mike Christensen
03:13 Re: Questions about setting an array element value outside of the update Tom Lane
03:15 Re: WITH and WITH RECURSIVE in single query David Johnston
03:36 Re: WITH and WITH RECURSIVE in single query Maxim Boguk
03:54 Re: pl/pgsql and arrays[] Pavel Stehule
04:12 Re: pl/pgsql and arrays[] Maxim Boguk
04:21 Re: pl/pgsql and arrays[] Pavel Stehule
06:12 Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Craig Ringer
06:15 Re: psql query gets stuck indefinitely tamanna madaan
06:32 Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Mike Christensen
07:24 Regarding licensing of Postgresql Jayashankar K B
07:42 Re: Regarding licensing of Postgresql John R Pierce
07:52 Re: odbc_fdw Albe Laurenz
07:59 Re: Regarding licensing of Postgresql John R Pierce
08:05 Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Albe Laurenz
09:49 Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Filip Rembiałkowski
09:55 Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Cédric Villemain
10:16 pg_standby: How to check in which state the server is currently? Frank Lanitz
10:25 Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Craig Ringer
10:31 Re: Regarding licensing of Postgresql Craig Ringer
10:43 FATAL: the database system is starting up Dave Cramer
11:08 Re: FATAL: the database system is starting up Dave Cramer
11:11 Re: odbc_fdw Florian Schwendener
11:11 Re: Regarding licensing of Postgresql Jayashankar K B
11:44 Re: Regarding licensing of Postgresql Andrew Sullivan
13:59 Re: Regarding licensing of Postgresql Gregg Jaskiewicz
13:59 plpgsql question Gauthier, Dave
14:12 Re: plpgsql question Adrian Klaver
14:51 Re: pg_standby: How to check in which state the server is currently? Ray Stell
15:02 Re: pg_standby: How to check in which state the server is currently? Cédric Villemain
15:11 Re: pl/pgsql and arrays[] Tom Lane
15:42 Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Francisco Figueiredo Jr.
15:48 Re: pl/pgsql and arrays[] Pavel Stehule
17:31 High-Concurrency GiST in postgreSQL C. Mundi
17:42 disallow SET WORK_MEM Andreas Kretschmer
17:43 Installing different PostgreSQL versions in parallel Rafael Ostertag
18:14 Re: disallow SET WORK_MEM Bruce Momjian
18:27 Re: High-Concurrency GiST in postgreSQL Andy Colson
19:01 Re: disallow SET WORK_MEM Tom Lane
20:34 Re: High-Concurrency GiST in postgreSQL C. Mundi
20:42 Re: High-Concurrency GiST in postgreSQL John R Pierce
20:53 Re: High-Concurrency GiST in postgreSQL John R Pierce
21:26 Re: High-Concurrency GiST in postgreSQL Andy Colson
21:41 Re: High-Concurrency GiST in postgreSQL C. Mundi
22:00 Re: High-Concurrency GiST in postgreSQL Andy Colson
23:37 Re: Regarding licensing of Postgresql Craig Ringer

6 December 2011

07:57 Re: gouse shaik
09:28 Re: pg_standby: How to check in which state the server is currently? Frank Lanitz
09:38 How to retrieve rows with empty value in numeric(12,8) columns Adarsh Sharma
09:52 Re: How to retrieve rows with empty value in numeric(12,8) columns Adarsh Sharma
09:59 Re: How to retrieve rows with empty value in numeric(12,8) columns Adarsh Sharma
10:08 Re: How to retrieve rows with empty value in numeric(12,8) columns Raymond O'Donnell
10:19 Re: How to retrieve rows with empty value in numeric(12,8) columns Alban Hertroys
10:20 Re: How to retrieve rows with empty value in numeric(12,8) columns Bèrto ëd Sèra
13:51 Re: [BUGS] BUG #6325: Useless Index updates Daniel Migowski
14:15 Re: [BUGS] BUG #6325: Useless Index updates Gregg Jaskiewicz
15:46 Re: Foreign keys question (performance) Phoenix Kiula
15:56 PostgreSQL DBA in SPAAAAAAAACE Joe Miller
16:08 Re: Foreign keys question (performance) David Johnston
16:31 Re: PostgreSQL DBA in SPAAAAAAAACE Merlin Moncure
16:33 Re: PostgreSQL DBA in SPAAAAAAAACE Torello Querci
17:02 Re: PostgreSQL DBA in SPAAAAAAAACE Bèrto ëd Sèra
19:39 Re: Foreign keys question (performance) Adrian Klaver
19:56 Re: PostgreSQL DBA in SPAAAAAAAACE Glyn Astill
20:20 Re: PostgreSQL DBA in SPAAAAAAAACE Rob Sargent
20:27 Re: PostgreSQL DBA in SPAAAAAAAACE Scott Marlowe
20:31 Re: PostgreSQL DBA in SPAAAAAAAACE Joe Miller
20:32 Re: PostgreSQL DBA in SPAAAAAAAACE Larry Rosenman
20:48 Re: PostgreSQL DBA in SPAAAAAAAACE Rob Sargent
23:58 Re: PostgreSQL DBA in SPAAAAAAAACE Esmin Gracić

7 December 2011

03:30 Re: Installing different PostgreSQL versions in parallel raghu ram
03:35 Re: psql query gets stuck indefinitely tamanna madaan
03:36 Re: Installing different PostgreSQL versions in parallel John R Pierce
03:58 Re: [BUGS] BUG #6325: Useless Index updates Craig Ringer
05:37 Re: Installing different PostgreSQL versions in parallel Rafael Ostertag
05:56 Re: Installing different PostgreSQL versions in parallel John R Pierce
06:57 Re: [pgadmin-support] Help for Migration
06:58 upgrading tsearch2: how to call function in trigger robert
07:18 Re: [pgadmin-support] Help for Migration Craig Ringer
07:24 Re: PostgreSQL DBA in SPAAAAAAAACE Achilleas Mantzios
07:48 Re: Installing different PostgreSQL versions in parallel Rafael Ostertag
08:26 Re: [pgadmin-support] Help for Migration Alban Hertroys
08:27 Queries take long long(10 sec.) time running Andre Lopes
08:45 Re: Queries take long long(10 sec.) time running Tomas Vondra
08:52 Re: Queries take long long(10 sec.) time running John R Pierce
09:07 Re: [pgadmin-support] Help for Migration Craig Ringer
09:28 Re: Queries take long long(10 sec.) time running Andre Lopes
11:45 Re: Queries take long long(10 sec.) time running Tomas Vondra
12:23 Re: [pgadmin-support] Help for Migration Craig Ringer
12:27 is there example of update skript? Pavel Stehule
12:30 Re: [pgadmin-support] Help for Migration Guillaume Lelarge
12:34 Re: [pgadmin-support] Help for Migration Guillaume Lelarge
13:03 postgres 9.0.4 Streaming relate question .. akp geek
13:13 Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64 Gene Poole
13:36 Re: Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64 Tomas Vondra
13:45 making "\pset pager off" the default Gauthier, Dave
13:57 Re: making "\pset pager off" the default Adrian Klaver
14:09 Expanding a VARCHAR on a large table that has inherited subtables ... Paulo Correia
14:18 Re: making "\pset pager off" the default Gauthier, Dave
14:19 Re: is there example of update skript? Cédric Villemain
14:47 Re: making "\pset pager off" the default Scott Marlowe
15:14 dblink performance Alex Bible
15:21 Re: [pgadmin-support] Help for Migration
15:21 Re: [pgadmin-support] Help for Migration
15:21 Re: [pgadmin-support] Help for Migration
15:21 Slow COMMIT statements Felix Feinhals
15:45 Fwd: postgres 9.0.4 Streaming related question .. akp geek
16:01 Re: Fwd: postgres 9.0.4 Streaming related question .. Ben Chobot
18:10 Tables creation date and time Prashant Bharucha
18:49 Re: dblink performance Merlin Moncure
19:10 Re: Tables creation date and time Scott Marlowe
19:48 Re: dblink performance Marc Mamin
19:53 Re: dblink performance Bruno Lavoie
20:17 Re: dblink performance Merlin Moncure
20:38 Re: dblink performance Marc Mamin
20:45 Re: Tables creation date and time Pavel Stehule
20:49 Re: dblink performance Merlin Moncure

8 December 2011

01:41 Query Slowdown after upgrade from 9.1.1 to 9.1.2 Jason Long
02:11 Hope for a new PostgreSQL era? Rodrigo E. De León Plicet
03:09 Re: Hope for a new PostgreSQL era? Scott Marlowe
03:11 pg crash shortly after 9.1.1 -> 9.1.2 upgrade Joseph Shraibman
04:26 Re: Hope for a new PostgreSQL era? Chris Travers
04:54 Re: pg crash shortly after 9.1.1 -> 9.1.2 upgrade Tom Lane
05:19 Very slow table Richard Weiss
05:19 Re: [pgadmin-support] Help for Migration
05:28 Re: pg crash shortly after 9.1.1 -> 9.1.2 upgrade Joseph Shraibman
06:05 Error while vacuuming table Nikhil G. Daddikar
07:21 Re: Very slow table Szymon Guz
10:24 Re: Hope for a new PostgreSQL era? Craig Ringer
11:27 Re: Hope for a new PostgreSQL era? Simon Riggs
11:54 Re: Hope for a new PostgreSQL era? Tomas Vondra
12:18 Re: Hope for a new PostgreSQL era? Craig Ringer
12:21 Re: Hope for a new PostgreSQL era? Andrew Sullivan
13:48 Re: Hope for a new PostgreSQL era? Satoshi Nagayasu
13:54 Re: Hope for a new PostgreSQL era? Merlin Moncure
14:12 Re: Hope for a new PostgreSQL era? Marc Cousin
14:17 Re: Fwd: postgres 9.0.4 Streaming related question .. akp geek
14:29 Re: Hope for a new PostgreSQL era? Merlin Moncure
14:57 concat(NULL,NULL) returns empty string Ingmar Brouns
15:04 Re: concat(NULL,NULL) returns empty string Pavel Stehule
15:04 Re: Hope for a new PostgreSQL era? Andrew Sullivan
15:11 Re: Hope for a new PostgreSQL era? Marc Cousin
15:19 Statistics mismatch between n_live_tup and actual row count Andreas Brandl
15:29 Re: Hope for a new PostgreSQL era? Nicholson, Brad (Toronto, ON, CA)
15:50 Re: Hope for a new PostgreSQL era? Tomas Vondra
15:55 Re: Hope for a new PostgreSQL era? Tomas Vondra
16:06 Re: Hope for a new PostgreSQL era? Tomas Vondra
16:06 Re: Hope for a new PostgreSQL era? Marc Cousin
16:06 Re: Hope for a new PostgreSQL era? Merlin Moncure
16:07 Re: Hope for a new PostgreSQL era? Marc Cousin
16:09 Re: Hope for a new PostgreSQL era? Tomas Vondra
16:11 Re: Hope for a new PostgreSQL era? Tomas Vondra
16:16 Re: Hope for a new PostgreSQL era? Marc Cousin
16:17 Re: Hope for a new PostgreSQL era? Marc Cousin
16:23 Re: Hope for a new PostgreSQL era? Tomas Vondra
16:35 Re: Hope for a new PostgreSQL era? Tomas Vondra
16:46 Re: Hope for a new PostgreSQL era? Marc Cousin
16:48 Re: Hope for a new PostgreSQL era? Tomas Vondra
17:08 Database system identifier via SELECT? Chris Redekop
17:15 Re: Hope for a new PostgreSQL era? Joshua D. Drake
17:37 Clarification on CONTEXT: xlog redo xid assignment kc5
17:54 Re: Hope for a new PostgreSQL era? John R Pierce
18:16 Re: Hope for a new PostgreSQL era? Joshua D. Drake
18:24 Re: Hope for a new PostgreSQL era? John R Pierce
18:39 Re: Hope for a new PostgreSQL era? Joshua D. Drake
19:16 Re: Clarification on CONTEXT: xlog redo xid assignment Simon Riggs
19:57 Re: Database system identifier via SELECT? Bruce Momjian
20:11 Re: Database system identifier via SELECT? Joshua D. Drake
20:19 Re: Database system identifier via SELECT? David Johnston
20:27 Re: Database system identifier via SELECT? Bruce Momjian
20:47 OT DBA type question - GRANT PRIVILEDGE James B. Byrne
20:58 Re: Database system identifier via SELECT? Scott Mead
21:09 Re: Database system identifier via SELECT? Safari Code
21:28 Re: OT DBA type question - GRANT PRIVILEDGE Andy Colson
21:54 Re: Clarification on CONTEXT: xlog redo xid assignment kc5
22:00 Re: Statistics mismatch between n_live_tup and actual row count Tom Lane
22:09 sharmi_jo@yahoo.com
22:13 Re: Raymond O'Donnell
22:16 Re: Joshua D. Drake
22:17 Re: Hope for a new PostgreSQL era? Chris Travers
22:19 Re: Bèrto ëd Sèra
22:21 Re: Raymond O'Donnell
22:22 Function Question Jake Stride
23:09 Re: Hope for a new PostgreSQL era? Rodger Donaldson
23:30 Re: Hope for a new PostgreSQL era? Chris Travers
23:35 Re: Hope for a new PostgreSQL era? Chris Travers

9 December 2011

00:24 Re: OT DBA type question - GRANT PRIVILEDGE Craig Ringer
01:47 Re: Hope for a new PostgreSQL era? Rodger Donaldson
02:11 Re: Hope for a new PostgreSQL era? Craig Ringer
02:13 Re: Tom Lane
02:14 Re: Hope for a new PostgreSQL era? Craig Ringer
02:16 Re: Function Question Tom Lane
03:18 Re: Hope for a new PostgreSQL era? Chris Travers
06:35 Character encoding problems Bruce Clay
07:20 Re: Character encoding problems John R Pierce
09:26 Re: Hope for a new PostgreSQL era? Marc Cousin
09:44 Re: Bèrto ëd Sèra
09:51 Re: Hope for a new PostgreSQL era? Simon Riggs
10:42 Why is cast array integer[] <--> text[] is not immutable. Phil Couling
12:33 Re: Hope for a new PostgreSQL era? Andreas 'ads' Scherbaum
12:33 Re: Hope for a new PostgreSQL era? Simon Riggs
12:43 Question regarding authentication/login Chris Deadlock
13:17 Re: Database system identifier via SELECT? Chris Redekop
13:35 Re: Question regarding authentication/login Adrian Klaver
14:05 How to configure the connection timeout in PostgreSQL 8.3 Andre Lopes
14:10 Re: Why is cast array integer[] <--> text[] is not immutable. Tom Lane
14:11 Re: How to configure the connection timeout in PostgreSQL 8.3 Frank Lanitz
15:23 Re: Why is cast array integer[] <--> text[] is not immutable. Phil Couling
16:06 Re: Why is cast array integer[] <--> text[] is not immutable. Tom Lane
16:14 Re: OT DBA type question - GRANT PRIVILEGE James B. Byrne
16:44 Re: OT DBA type question - GRANT PRIVILEGE James B. Byrne
17:19 Re: OT DBA type question - GRANT PRIVILEGE Scott Marlowe
17:46 Is the a "magic number" for WAL files Rob Sargent
17:49 Re: OT DBA type question - GRANT PRIVILEGE Andrew Sullivan
18:38 Re: Is the a "magic number" for WAL files Thom Brown
18:46 Re: OT DBA type question - GRANT PRIVILEGE Andrew Sullivan
18:49 Re: Is the a "magic number" for WAL files Peter Geoghegan
21:48 Why does aggregate query allow select of non-group by or aggregate values? Jack Christensen
21:52 Re: Why does aggregate query allow select of non-group by or aggregate values? Henry Drexler
21:58 Re: Why does aggregate query allow select of non-group by or aggregate values? David Johnston
21:58 Re: Why does aggregate query allow select of non-group by or aggregate values? Adrian Klaver

10 December 2011

00:54 Re: Hope for a new PostgreSQL era? Greg Smith
04:45 Re: Question regarding authentication/login Craig Ringer
08:01 Re: How could I find the last modified procedure in the database? Jasen Betts
08:09 Re: Frank Lanitz
08:14 Re: frank@frank.uvena.de
14:11 Re: Statistics mismatch between n_live_tup and actual row count Andreas Brandl
15:08 Re: Statistics mismatch between n_live_tup and actual row count Tom Lane
19:40 Re: Why does aggregate query allow select of non-group by or aggregate values? Jack Christensen

11 December 2011

01:28 Re: Hope for a new PostgreSQL era? Craig Ringer
02:29 Re: Hope for a new PostgreSQL era? Scott Marlowe
05:19 Re: Hope for a new PostgreSQL era? Greg Smith
05:52 Improve replication usability Andrew Armstrong
15:18 sort order Abraham, Danny
15:30 initdb locale WIN1252 Abraham, Danny
15:57 Re: Improve replication usability Magnus Hagander
16:41 Problem installing PG9.1 using yum wstrzalka
16:43 Postgresql featured on Hacker News Vincent Veyron
20:30 Re: Problem installing PG9.1 using yum Devrim GÜNDÜZ
23:09 Re: Hope for a new PostgreSQL era? Satoshi Nagayasu
23:10 Re: Hope for a new PostgreSQL era? Eduardo Morras
23:41 Denormalizing via SQL Robert James
23:42 Howto to clear PostgreSQL cache and how to preload all tuples of a table into the cache? Stefan Keller
23:44 Re: Denormalizing via SQL David Johnston
23:46 Controlling complexity in queries Robert James

12 December 2011

00:16 Re: Controlling complexity in queries David Johnston
02:04 Re: Howto to clear PostgreSQL cache and how to preload all tuples of a table into the cache? Craig Ringer
02:13 Re: Controlling complexity in queries Craig Ringer
03:25 Re: Problem installing PG9.1 using yum devrim@gunduz.org
03:42 Re: Hope for a new PostgreSQL era? Jayadevan M
03:47 Re: Hope for a new PostgreSQL era? Ondrej Ivanič
04:10 Re: Howto to clear PostgreSQL cache and how to preload all tuples of a table into the cache? Raghavendra
06:59 Re: Howto to clear PostgreSQL cache and how to preload all tuples of a table into the cache? Cédric Villemain
07:10 Re: Hope for a new PostgreSQL era? Eduardo Morras
10:43 Re: Hope for a new PostgreSQL era? Greg Smith
11:10 Re: Hope for a new PostgreSQL era? Greg Smith
11:11 Re: Hope for a new PostgreSQL era? Chris Curvey
12:25 Re: PostgreSQL DBA in SPAAAAAAAACE Mark Morgan Lloyd
12:35 Re: PostgreSQL DBA in SPAAAAAAAACE Cédric Villemain
14:26 Re: Problem installing PG9.1 using yum Wojciech Strzałka
14:30 Re: Problem installing PG9.1 using yum Devrim GÜNDÜZ
14:31 Having Issue Getting the Postgresql Service to Start Sogard, Michael (DPS)
14:32 Re: Problem installing PG9.1 using yum devrim@gunduz.org
14:43 Re: Controlling complexity in queries Merlin Moncure
14:49 Re: initdb locale WIN1252 Adrian Klaver
14:52 Re: Having Issue Getting the Postgresql Service to Start Sachin Srivastava
14:52 Re: sort order Adrian Klaver
14:57 Re: sort order Abraham, Danny
15:07 Re: PostgreSQL DBA in SPAAAAAAAACE Joe Miller
15:07 Re: sort order Tom Lane
15:09 Re: sort order Adrian Klaver
15:17 Re: sort order Abraham, Danny
15:19 Re: Having Issue Getting the Postgresql Service to Start Sogard, Michael (DPS)
16:12 Server/Data Migration Advice Carlos Mennens
16:24 Re: Server/Data Migration Advice Andreas Kretschmer
16:24 Re: Server/Data Migration Advice Cédric Villemain
16:39 Re: Server/Data Migration Advice Carlos Mennens
17:01 Re: Question regarding authentication/login Chris Deadlock
17:05 Re: Problem installing PG9.1 using yum Wojciech Strzałka
17:15 psql latex and newlines Wim Bertels
17:53 initdb with lc-collate=C Scot Kreienkamp
18:14 Re: Statistics mismatch between n_live_tup and actual row count Andreas Brandl
19:15 Re: initdb with lc-collate=C Adrian Klaver
19:26 Re: initdb with lc-collate=C Adrian Klaver
19:38 Re: initdb with lc-collate=C Scot Kreienkamp
19:56 Re: initdb with lc-collate=C Adrian Klaver
20:28 Re: initdb with lc-collate=C Adrian Klaver
22:38 Consecutive operators not recognized without whitespace Chris Angelico
22:48 Re: Having Issue Getting the Postgresql Service to Start Craig Ringer
23:01 Re: Consecutive operators not recognized without whitespace Tom Lane
23:43 Re: WAL file accumulation on log shipping primary node Dong Han

13 December 2011

00:16 Re: WAL file accumulation on log shipping primary node Dave Cramer
02:22 Re: initdb with lc-collate=C Scot Kreienkamp
02:36 Re: Hope for a new PostgreSQL era? Jayadevan M
03:28 Re: WAL file accumulation on log shipping primary node Dong Han
04:00 Re: initdb with lc-collate=C Tom Lane
10:19 Re: WAL file accumulation on log shipping primary node Dave Cramer
12:05 order of (escaped) characters in regex range InterRob
12:09 Re: order of (escaped) characters in regex range Szymon Guz
12:29 Re: order of (escaped) characters in regex range InterRob
12:31 Re: order of (escaped) characters in regex range David Johnston
12:51 Re: order of (escaped) characters in regex range InterRob
13:14 Re: order of (escaped) characters in regex range hubert depesz lubaczewski
15:12 Re: Having Issue Getting the Postgresql Service to Start Sogard, Michael (DPS)
15:39 Re: order of (escaped) characters in regex range Merlin Moncure
15:53 Re: order of (escaped) characters in regex range David Johnston
15:58 Re: initdb with lc-collate=C Scot Kreienkamp
15:59 Re: order of (escaped) characters in regex range Merlin Moncure
16:20 Re: order of (escaped) characters in regex range Rob Marjot
19:38 query for all values linked to a field anisoptera
19:51 Re: query for all values linked to a field Merlin Moncure
20:03 Re: query for all values linked to a field anisoptera
21:27 Re: Controlling complexity in queries Jay Levitt
22:22 Re: Hope for a new PostgreSQL era? Greg Smith

14 December 2011

01:35 PGDay.SoCal @ SCALE 10X Joe Conway
01:39 PGDay.SoCal @ SCALE 10X joe.conway@credativ.com
03:55 Question about HoT updates and conditional indexes Maxim Boguk
04:22 Re: Having Issue Getting the Postgresql Service to Start Craig Ringer
04:28 Postgresql connect into windows server Yuriy Rusinov
04:32 Re: Postgresql connect into windows server John R Pierce
04:41 Re: Postgresql connect into windows server Yuriy Rusinov
04:55 : streaming replication on PG-9.1.1 Venkat Balaji
05:11 Re: Postgresql connect into windows server David Johnston
05:39 when was pg_stat_reset() used in my server for the last time AI Rumman
10:05 why can't my account be used at wiki.postgresql.org after having registered in www.postgresql.org? sunpeng
10:11 Re: why can't my account be used at wiki.postgresql.org after having registered in www.postgresql.org? Raymond O'Donnell
11:33 Philosophical question Andreas
11:53 Re: Philosophical question Serge Fonville
12:29 Re: Philosophical question Craig Ringer
12:35 Re: Philosophical question Chris Travers
12:44 Re: Postgresql connect into windows server Yuriy Rusinov
12:58 Copying timeline history file to standby senthilnathan
14:13 Re: why can't my account be used at wiki.postgresql.org after having registered in www.postgresql.org? Tom Lane
14:33 Re: Controlling complexity in queries Merlin Moncure
15:02 Re: Philosophical question Albe Laurenz
16:16 Re: Philosophical question Andreas
16:52 Locking Tables & Backup Inquiry Carlos Mennens
17:04 Cisco Systems fail Ray Stell
17:15 Re: Locking Tables & Backup Inquiry Andy Colson
17:26 Re: Locking Tables & Backup Inquiry Carlos Mennens
17:38 Re: Locking Tables & Backup Inquiry Andy Colson
17:54 Re: Locking Tables & Backup Inquiry Carlos Mennens
18:00 Re: Locking Tables & Backup Inquiry Andy Colson
18:14 Re: why can't my account be used at wiki.postgresql.org after having registered in www.postgresql.org? Magnus Hagander
19:01 Vacuum and Large Objects Simon Windsor
19:23 Re: Controlling complexity in queries Jay Levitt
19:57 Re: when was pg_stat_reset() used in my server for the last time Marti Raudsepp
20:21 Re: Philosophical question Chris Angelico
21:17 Re: Philosophical question David Owen
21:24 Re: Controlling complexity in queries Alban Hertroys
23:26 Re: Philosophical question Leif Biberg Kristensen
23:54 Re: Philosophical question Chris Travers
23:56 Re: Vacuum and Large Objects Craig Ringer

15 December 2011

00:02 Re: Philosophical question Craig Ringer
01:15 Re: Philosophical question Edson Richter
03:11 Re: Controlling complexity in queries Jay Levitt
03:15 Re: Philosophical question Chris Angelico
03:41 Re: Philosophical question Darren Duncan
03:43 Correct syntax to create partial index on a boolean column Mike Christensen
03:47 Re: Philosophical question Darren Duncan
04:23 Re: Philosophical question Chris Travers
04:34 Re: Philosophical question Chris Angelico
04:54 Re: Correct syntax to create partial index on a boolean column Mike Christensen
05:12 question about \encoding option of psql Xiaobo Gu
05:26 Re: question about \encoding option of psql John R Pierce
05:57 Re: Correct syntax to create partial index on a boolean column Mike Christensen
06:53 Re: Correct syntax to create partial index on a boolean column Alban Hertroys
07:27 Re: Locking Tables & Backup Inquiry Albe Laurenz
07:28 Re: Correct syntax to create partial index on a boolean column Albe Laurenz
07:58 Re: Philosophical question Bèrto ëd Sèra
08:25 Re: question about \encoding option of psql Guillaume Lelarge
08:37 Re: Controlling complexity in queries Harald Fuchs
08:50 Re: Philosophical question Andreas
08:53 Re: Controlling complexity in queries Bèrto ëd Sèra
10:23 Re: Philosophical question Chris Travers
12:33 Re: Server/Data Migration Advice Carlos Mennens
12:42 Re: Server/Data Migration Advice Bèrto ëd Sèra
13:01 Re: Correct syntax to create partial index on a boolean column Craig Ringer
13:38 Re: Server/Data Migration Advice Adrian Klaver
13:45 Re: question about \encoding option of psql Adrian Klaver
13:56 Re: Server/Data Migration Advice Carlos Mennens
14:08 Re: Correct syntax to create partial index on a boolean column Mike Christensen
14:28 Re: Server/Data Migration Advice Adrian Klaver
14:28 Re: Correct syntax to create partial index on a boolean column Tom Lane
14:31 Re: Correct syntax to create partial index on a boolean column Jay Levitt
15:00 Re: Server/Data Migration Advice Carlos Mennens
15:10 Re: Server/Data Migration Advice Raymond O'Donnell
15:10 Logical Aggregate Functions (eg ANY()) Robert James
15:14 Re: Server/Data Migration Advice Carlos Mennens
15:18 Re: Server/Data Migration Advice Adrian Klaver
15:22 Double Denormalizing in Postgres Robert James
15:28 Re: Philosophical question Scott Marlowe
15:28 Re: Double Denormalizing in Postgres Pavel Stehule
15:41 Streaming Replication Configuration Carlos Mennens
15:42 Re: Double Denormalizing in Postgres David Johnston
15:53 Re: Streaming Replication Configuration Raymond O'Donnell
15:53 Re: Streaming Replication Configuration Gabriele Bartolini
15:54 Re: Streaming Replication Configuration Gabriele Bartolini
15:55 Re: Streaming Replication Configuration Raymond O'Donnell
16:05 Re: Logical Aggregate Functions (eg ANY()) Merlin Moncure
16:17 LOCK DATABASE Eliot Gable
16:29 CREATE OR REPLACE AGGREGATE Robert James
16:56 Re: CREATE OR REPLACE AGGREGATE Merlin Moncure
17:41 null tablespace? Tony Capobianco
17:52 Re: Logical Aggregate Functions (eg ANY()) Kirill Simonov
17:54 Re: null tablespace? Raghavendra
18:01 Re: LOCK DATABASE Scott Marlowe
18:09 Re: Logical Aggregate Functions (eg ANY()) Marti Raudsepp
19:26 Re: Philosophical question Chris Angelico
19:38 Re: null tablespace? Tony Capobianco
20:35 Re: null tablespace? Raghavendra

16 December 2011

05:33 Re: question about \encoding option of psql Xiaobo Gu
14:30 Re: Vacuum and Large Objects Igor Neyman
14:38 Permission denied on relation Radosław Smogura
14:43 Re: question about \encoding option of psql Adrian Klaver
19:23 disable autovacuum per-database? Mike Blackwell
21:32 PQreset needs to be executed twice to really connect to the postgresql database ChoonSoo Park

17 December 2011

00:46 New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..." Patrick Kevin McCaffrey
08:39 REMINDER: FOSDEM 2012 - PostgreSQL Devroom: Call for Speakers Andreas 'ads' Scherbaum
18:14 Re: LOCK DATABASE Josh Kupershmidt
20:26 segfault with plproxy Filip Rembiałkowski
23:04 Re: CREATE OR REPLACE AGGREGATE Robert James
23:06 Re: Logical Aggregate Functions (eg ANY()) Robert James

18 December 2011

01:53 Performance question: Commit or rollback? Chris Angelico
02:02 Re: Performance question: Commit or rollback? Chris Travers
02:06 Re: Performance question: Commit or rollback? Chris Angelico
03:26 Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..." Tom Lane
13:19 pg_dump and pg_restore make data dir doubled size? Yan Chunlu
15:23 recovery_target_timeline and multiple slave behavior when master fails Rick Pufky
15:23 indexes and tables amit sehas
15:23 New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..." Patrick Kevin McCaffrey
17:14 Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..." Steve Atkins
21:00 Re: indexes and tables David Johnston
23:27 Re: indexes and tables David Johnston

19 December 2011

01:52 Re: recovery_target_timeline and multiple slave behavior when master fails Fujii Masao
03:32 Re: Logical Aggregate Functions (eg ANY()) Merlin Moncure
04:16 Re: indexes and tables amit sehas
04:29 Re: pg_dump and pg_restore make data dir doubled size? Yan Chunlu
05:44 How to make a non-removable row in a table? Капралов Александр
05:54 ignore duplicate key while using COPY? Yan Chunlu
05:56 Re: How to make a non-removable row in a table? Thomas Markus
06:07 Re: ignore duplicate key while using COPY? David Johnston
06:17 Re: How to make a non-removable row in a table? Капралов Александр
07:03 Re: How to make a non-removable row in a table? Thomas Markus
08:05 Re: [pgeu-general] REMINDER: FOSDEM 2012 - PostgreSQL Devroom: Call for Speakers Emanuel Calvo
08:35 Re: indexes and tables Misa Simic
08:39 Re: segfault with plproxy Marko Kreen
08:43 Re: Logical Aggregate Functions (eg ANY()) Marti Raudsepp
10:57 Escaping input from COPY Roger Leigh
11:05 Re: segfault with plproxy Filip Rembiałkowski
11:36 Re: segfault with plproxy Filip Rembiałkowski
12:01 Changing Passwords as Encrypted not Clear-Text MURAT KOÇ
12:02 Re: Logical Aggregate Functions (eg ANY()) Merlin Moncure
12:05 consecutive analyze calls with different column lists. Marc Mamin
13:19 Re: ignore duplicate key while using COPY? Adrian Klaver
13:24 Fwd: consecutive analyze calls with different column lists. David Johnston
13:32 Re: Changing Passwords as Encrypted not Clear-Text Guillaume Lelarge
13:51 Re: Changing Passwords as Encrypted not Clear-Text Adrian Klaver
14:19 Re: Changing Passwords as Encrypted not Clear-Text MURAT KOÇ
14:26 Re: Changing Passwords as Encrypted not Clear-Text MURAT KOÇ
14:32 Re: Changing Passwords as Encrypted not Clear-Text Alban Hertroys
14:45 Re: Changing Passwords as Encrypted not Clear-Text Guillaume Lelarge
14:46 Re: Changing Passwords as Encrypted not Clear-Text Adrian Klaver
14:52 fsync on ext4 does not work Havasvölgyi Ottó
14:53 Re: Changing Passwords as Encrypted not Clear-Text MURAT KOÇ
15:00 Re: fsync on ext4 does not work Tomas Vondra
15:01 Feature Request: Better handling of foreign keys in DELETE statements Daniel Migowski
15:03 Re: fsync on ext4 does not work Florian Weimer
15:05 Re: Changing Passwords as Encrypted not Clear-Text Alban Hertroys
15:11 Re: Feature Request: Better handling of foreign keys in DELETE statements Chris Angelico
15:15 Re: Feature Request: Better handling of foreign keys in DELETE statements Pavel Stehule
15:18 Re: Changing Passwords as Encrypted not Clear-Text Magnus Hagander
15:20 Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..." Patrick Kevin McCaffrey
15:26 Re: Feature Request: Better handling of foreign keys in DELETE statements Marti Raudsepp
15:56 Re: recovery_target_timeline and multiple slave behavior when master fails Rick Pufky
15:58 Re: Changing Passwords as Encrypted not Clear-Text Adrian Klaver
15:59 Re: Feature Request: Better handling of foreign keys in DELETE statements Pavel Stehule
16:31 Re: indexes and tables Alan Hodgson
16:35 Re: indexes and tables Misa Simic
18:46 Re: Changing Passwords as Encrypted not Clear-Text MURAT KOÇ
19:47 Re: fsync on ext4 does not work Havasvölgyi Ottó
20:01 Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..." Tom Lane
20:34 Re: fsync on ext4 does not work Havasvölgyi Ottó
20:46 Re: Feature Request: Better handling of foreign keys in DELETE statements Hannes Erven
21:59 Re: Changing Passwords as Encrypted not Clear-Text Adrian Klaver

20 December 2011

08:06 using pg's internal timezone database? Louis-David Mitterrand
09:21 Re: fsync on ext4 does not work Florian Weimer
09:49 pg_restore should restore the schema comments and the database properties Daniel Migowski
11:29 Re: using pg's internal timezone database? Scott Marlowe
12:44 Re: fsync on ext4 does not work Greg Smith
13:15 Re: pg_restore should restore the schema comments and the database properties Adrian Klaver
13:36 Re: pg_restore should restore the schema comments and the database properties Adrian Klaver
13:37 Re: segfault with plproxy Marko Kreen
13:58 Re: Cisco Systems fail Christian Ramseyer
14:01 Re: PostgreSQL DBA in SPAAAAAAAACE Merlin Moncure
14:02 Re: pg_restore should restore the schema comments and the database properties Alban Hertroys
14:04 Re: PostgreSQL DBA in SPAAAAAAAACE Alban Hertroys
14:08 Re: PostgreSQL DBA in SPAAAAAAAACE Joe Miller
14:10 Re: pg_restore should restore the schema comments and the database properties Adrian Klaver
14:51 How To Handle Hung Connections Carlos Mennens
15:07 Re: How To Handle Hung Connections Mike Blackwell
15:59 Re: segfault with plproxy Filip Rembiałkowski
16:41 General coding question jkells
17:33 Re: General coding question David Johnston
17:48 Re: General coding question Bill Moran
18:49 PostgreSQL server architecture James B. Byrne
18:54 Postgres Logs question akp geek
19:08 Re: PostgreSQL server architecture Bill Moran
19:11 Re: pg crash shortly after 9.1.1 -> 9.1.2 upgrade Tom Lane
20:10 out of memory error with loading pg_dumpall Dara Olson
20:11 Re: General coding question jkells
21:01 Re: General coding question David Johnston
21:35 Re: Postgres Logs question Chris Travers
22:56 Re: Escaping input from COPY Josh Kupershmidt
22:57 design help for performance Culley Harrelson
23:03 Re: PostgreSQL server architecture Craig Ringer
23:12 Re: design help for performance Misa Simic
23:19 Re: PostgreSQL server architecture John R Pierce
23:28 Re: design help for performance David Johnston
23:37 Re: design help for performance Culley Harrelson
23:47 Re: Escaping input from COPY Adrian Klaver

21 December 2011

00:16 Re: out of memory error with loading pg_dumpall Tom Lane
06:53 Re: design help for performance Alban Hertroys
07:12 Re: design help for performance Misa Simic
08:47 Re: design help for performance Marc Mamin
10:39 can not use the column after rename salah jubeh
11:15 Re: can not use the column after rename Simon Tokumine
12:24 Re: can not use the column after rename salah jubeh
12:26 Cannot connect to 2nd cluster database remotely Jacques Lamothe
12:38 Re: can not use the column after rename Marti Raudsepp
12:52 Re: Cannot connect to 2nd cluster database remotely Devrim GÜNDÜZ
12:56 Re: Cannot connect to 2nd cluster database remotely Jacques Lamothe
13:01 Re: can not use the column after rename David Johnston
13:07 Re: Cannot connect to 2nd cluster database remotely devrim@gunduz.org
13:51 Re: out of memory error with loading pg_dumpall Dara Olson
15:06 Re: can not use the column after rename Tom Lane
15:14 Re: out of memory error with loading pg_dumpall Tom Lane
17:29 How to create database with default system locale is set to et_EE.UTF-8 Andrus
17:51 [partition table] fetchall or fetchone function can not get the returning rows Xiaoning Xu
17:58 Re: Postgres Logs question akp geek
18:47 Re: How to create database with default system locale is set to et_EE.UTF-8 Adrian Klaver
19:57 How to escape to quotes on Insert into? Andre Lopes
20:05 Re: How to escape to quotes on Insert into? Bill Moran
20:07 Re: design help for performance Culley Harrelson
20:21 Re: How to escape to quotes on Insert into? Andre Lopes
20:31 [partition table] python fetchall or fetchone function can not get the returning rows Xiaoning Xu
21:40 Why vacumming performed on template1 with initdb command ? Raghavendra
21:42 Re: fsync on ext4 does not work Havasvölgyi Ottó
22:17 Re: Escaping input from COPY Josh Kupershmidt
22:21 Re: [partition table] python fetchall or fetchone function can not get the returning rows Misa Simic
22:27 Re: Escaping input from COPY Roger Leigh
22:30 Re: Why vacumming performed on template1 with initdb command ? Tom Lane
22:40 Re: design help for performance Misa Simic
23:48 Trying to understand postgres crash Hanns Hartman

22 December 2011

00:16 Re: Escaping input from COPY Adrian Klaver
01:13 Re: ignore duplicate key while using COPY? Yan Chunlu
02:50 Cursor loop - stop current iteration and continue with next iteration Dinesh Kumara
02:51 Help with Multiple Cluster on same host Jacques Lamothe
02:55 [partition table] fetchall or fetchone function can not get the returning rows Xiaoning Xu
02:57 Re: Help with Multiple Cluster on same host David Morton
02:59 Re: Cursor loop - stop current iteration and continue with next iteration David Johnston
03:01 Re: Help with Multiple Cluster on same host John R Pierce
03:07 Re: [partition table] fetchall or fetchone function can not get the returning rows John R Pierce
03:58 Re: Trying to understand postgres crash Scott Marlowe
06:20 Re: [partition table] python fetchall or fetchone functioncan not get the returning rows Misa Simic
06:40 Re: design help for performance Misa Simic
06:55 Re: Why vacumming performed on template1 with initdb command ? Raghavendra
09:32 Re: fsync on ext4 does not work Havasvölgyi Ottó
14:29 Re: Trying to understand postgres crash Tom Lane
15:29 Re: How to create database with default system locale is set to et_EE.UTF-8 Andrus
15:32 Cannot connect to 2nd cluster database remotely Jacques Lamothe
15:40 Unable to connect to PostgreSQL server : Could not get socket error status Shankar Palaniappan
15:57 not-always-full vacuuming in 9.0 ?
15:57 Re: How to create database with default system locale is set to et_EE.UTF-8 Bèrto ëd Sèra
15:59 Re: How to create database with default system locale is set to et_EE.UTF-8 Adrian Klaver
16:00 Re: How to create database with default system locale is set to et_EE.UTF-8 Andrus
16:10 Re: How to create database with default system locale is set to et_EE.UTF-8 Andrus
16:10 Re: How to create database with default system locale is set to et_EE.UTF-8 Bèrto ëd Sèra
16:15 Re: How to create database with default system locale is set to et_EE.UTF-8 Bèrto ëd Sèra
16:32 Default value of column in information_schema Юра Величко
16:45 Re: How to create database with default system locale is set to et_EE.UTF-8 Andrus
16:51 Re: Trying to understand postgres crash Hanns Hartman
16:55 Re: How to create database with default system locale is set to et_EE.UTF-8 Adrian Klaver
16:58 Re: Trying to understand postgres crash Hanns Hartman
17:13 Re: Unable to connect to PostgreSQL server : Could not get socket error status John R Pierce
17:15 Re: Trying to understand postgres crash Tom Lane
17:43 Re: Trying to understand postgres crash Hanns Hartman
19:06 pgrouting extension with quantum gis saqib11@igis.nust.edu.pk
19:18 Pgrouting configuaration with QuantumGIS saqib11@igis.nust.edu.pk
19:20 Configuatration of pgrouting with QuantumGIS saqib11@igis.nust.edu.pk
20:23 Re: How to create database with default system locale is set to et_EE.UTF-8 Andrus
21:29 Initdb fails on openwrt in "creating template1 database" Clemens Eisserer

23 December 2011

00:02 Re: Initdb fails on openwrt in "creating template1 database" Scott Marlowe
08:58 Re: Initdb fails on openwrt in "creating template1 database" Clemens Eisserer
12:14 Fetch from refcursor and transactions aasat
12:55 Re: PostgreSQL DBA in SPAAAAAAAACE Gavin Flower
12:56 Re: Unable to connect to PostgreSQL server : Could not get socket error status Shankar Palaniappan
12:56 postgresql triggers - defining a global resource (java) Aman Gupta
13:15 Re: How to convert HEX to ASCII? Pavel Stehule
13:33 Re: Fetch from refcursor and transactions Adrian Klaver
13:43 Re: Initdb fails on openwrt in "creating template1 database" Adrian Klaver
13:52 Re: Re: Unable to connect to PostgreSQL server : Could not get socket error status Adrian Klaver
14:00 Re: Initdb fails on openwrt in "creating template1 database" Tom Lane
14:20 Re: How to create database with default system locale is set to et_EE.UTF-8 Adrian Klaver
14:23 Re: How to create database with default system locale is set to et_EE.UTF-8 Peter Eisentraut
14:26 Re: How to create database with default system locale is set to et_EE.UTF-8 Andrus
14:28 Re: How to create database with default system locale is set to et_EE.UTF-8 Adrian Klaver
14:33 Re: How to create database with default system locale is set to et_EE.UTF-8 Andrus
16:48 Re: How to create database with default system locale is set to et_EE.UTF-8 Peter Eisentraut
17:47 Example of a pg_gethostname() function. Feedback? bricklen

24 December 2011

00:47 Re: Initdb fails on openwrt in "creating template1 database" Ben Chobot
03:22 Re: Example of a pg_gethostname() function. Feedback? Craig Ringer
07:24 pgrouting extension with quantum gis saqib11@igis.nust.edu.pk
07:40 Re: pgrouting extension with quantum gis Pavel Stehule
08:55 concurrent read and write on live data feeds Muhammad Abuizzah
11:47 Re: Performance question: Commit or rollback? vinny
11:50 Re: Performance question: Commit or rollback? Chris Angelico
12:00 Re: Performance question: Commit or rollback? vinny
12:20 Re: Performance question: Commit or rollback? Chris Angelico
16:03 Re: PostgreSQL DBA in SPAAAAAAAACE Vincent Veyron
18:34 Re: Performance question: Commit or rollback? Darren Duncan
20:32 Re: postgresql triggers - defining a global resource (java) Alban Hertroys
20:39 Re: PostgreSQL DBA in SPAAAAAAAACE Alban Hertroys
22:22 Re: PostgreSQL DBA in SPAAAAAAAACE Scott Marlowe
23:30 Re: Performance question: Commit or rollback? Chris Travers

25 December 2011

07:21 PG Routing Help needed.. saqib11@igis.nust.edu.pk
17:59 Re: PG Routing Help needed.. Adrian Klaver

26 December 2011

06:21 Error while loading sql file Adarsh Sharma
06:21 Error while loading sql file Adarsh Sharma
11:18 Re: Error while loading sql file Alban Hertroys
15:08 invalid memory alloc request size Ben Chobot
20:54 Re: postgresql triggers - defining a global resource (java) Aman Gupta
21:06 Re: Unable to connect to PostgreSQL server : Could not get socket error status Shankar Palaniappan
21:25 Re: Re: Unable to connect to PostgreSQL server : Could not get socket error status Raymond O'Donnell
21:48 Re: Re: Unable to connect to PostgreSQL server : Could not get socket error status Adrian Klaver

27 December 2011

04:31 Re: Error while loading sql file Adarsh Sharma
04:42 Re: Error while loading sql file John R Pierce
07:45 Why does index not use for CTE query? AI Rumman
07:50 Re: Why does index not use for CTE query? Robins Tharakan
07:53 Re: Why does index not use for CTE query? robins.tharakan@comodo.com
07:55 Re: Why does index not use for CTE query? AI Rumman
08:26 Show in psql does any calculations? Raghavendra
08:46 Re: Show in psql does any calculations? Guillaume Lelarge
08:51 Re: Show in psql does any calculations? Raghavendra
08:56 Re: Show in psql does any calculations? Guillaume Lelarge
09:32 Re: Why does index not use for CTE query? Robins Tharakan
09:39 Re: Why does index not use for CTE query? robins.tharakan@comodo.com
11:21 Re: Error while loading sql file Bèrto ëd Sèra
11:28 Re: Show in psql does any calculations? Filip Rembiałkowski
13:40 Re: Error while loading sql file Adrian Klaver
14:17 Re: postgresql triggers - defining a global resource (java) Merlin Moncure
14:56 Replication order Martin S
15:03 Re: Example of a pg_gethostname() function. Feedback? bricklen
15:34 not-always-full vacuuming in 9.0 ?
16:34 Re: invalid memory alloc request size Ben Chobot
17:29 Detecting uncommitted changes Thomas Kellerer
17:38 Re: Detecting uncommitted changes Bill Moran
17:49 Re: Detecting uncommitted changes Thomas Kellerer
18:07 UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL Jacques Lamothe
18:17 Re: UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL John R Pierce
18:17 Re: UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL Adrian Klaver
18:21 Re: UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL Raymond O'Donnell
18:23 Re: Detecting uncommitted changes Tom Lane
18:31 Re: UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL Jacques Lamothe
18:34 Re: UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL Jacques Lamothe
18:39 Re: UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL Adrian Klaver
18:39 Re: UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL Jacques Lamothe
18:41 Re: UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL Adrian Klaver
18:44 Re: UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL Jacques Lamothe
18:46 Re: UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL John R Pierce
18:48 Re: UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL Adrian Klaver
18:48 Re: UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL Jacques Lamothe
18:49 Re: UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL Jacques Lamothe
21:07 Re: invalid memory alloc request size Tomas Vondra
21:23 Re: invalid memory alloc request size Merlin Moncure
21:34 Re: Detecting uncommitted changes Thomas Kellerer
21:37 Re: invalid memory alloc request size Tomas Vondra
22:12 Kindly Please Help Me saqib11@igis.nust.edu.pk
22:20 Re: Kindly Please Help Me Merlin Moncure
23:42 Re: Detecting uncommitted changes Tom Lane

28 December 2011

04:20 PostgreSQL 9.1 pg_dump setval() sets wrong value Greg Donald
04:28 Re: Show in psql does any calculations? Raghavendra
07:11 Create XML elements from rows Thangalin
07:15 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Scott Marlowe
07:16 Re: Create XML elements from rows Raghavendra
08:50 Re: Detecting uncommitted changes Thomas Kellerer
08:54 psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams hosuresh
08:57 Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams Devrim GÜNDÜZ
09:03 Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams devrim@gunduz.org
09:30 Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams hosuresh
09:40 Re: Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams Devrim GÜNDÜZ
09:44 Re: Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams devrim@gunduz.org
09:54 Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams John R Pierce
11:47 Re: Create XML elements from rows Thangalin
11:57 Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams hosuresh
12:04 Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams hosuresh
13:55 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Greg Donald
14:07 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Adrian Klaver
14:18 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Greg Donald
14:30 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Adrian Klaver
14:52 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Greg Donald
15:04 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Greg Donald
15:20 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Adrian Klaver
15:36 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Adrian Klaver
15:38 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Merlin Moncure
17:34 Re: Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams Tom Lane
17:35 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Adrian Klaver
17:54 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Merlin Moncure
18:00 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Tom Lane
18:02 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Tom Lane
20:03 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Greg Donald
21:58 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Tom Lane
21:59 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Adrian Klaver

29 December 2011

00:16 checking for table bloat Ben Chobot
00:38 Re: checking for table bloat Ondrej Ivanič
01:24 Unable to Increase the column which was part of Primary key karthikeyan
04:16 Re: Unable to Increase the column which was part of Primary key Tom Lane
05:33 Restoring default privileges on a table Julian Mehnle
05:39 Restoring default privileges on a table julian@mehnle.net
05:48 Kindly Please Help Me saqib11@igis.nust.edu.pk
06:02 Re: Kindly Please Help Me Craig Ringer
07:25 Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams hosuresh
09:11 Refine Form of My querry saqib11@igis.nust.edu.pk
09:14 Re: Refine Form of My querry John R Pierce
09:25 Re: Unable to Increase the column which was part of Primary key Andreas Kretschmer
10:25 Postgresql Replication Comparison Required saurabh gupta
11:58 Re: Refine Form of My querry Eduardo Morras
13:49 Re: Postgresql Replication Comparison Required Gabriele Bartolini
15:11 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Greg Donald
15:14 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Greg Donald
15:21 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Greg Donald
15:28 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Merlin Moncure
15:34 Re: Refine Form of My querry David Salisbury
15:54 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Greg Donald
16:19 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Merlin Moncure
16:47 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Adrian Klaver
16:54 Re: PostgreSQL 9.1 pg_dump setval() sets wrong value Adrian Klaver
17:16 Verifying a timestamp is null or in the past Alexander Farber
17:44 Re: Verifying a timestamp is null or in the past Andreas Kretschmer
19:01 Re: Verifying a timestamp is null or in the past Alexander Farber
19:20 Re: Verifying a timestamp is null or in the past David Johnston
19:58 Re: Refine Form of My querry Eduardo Morras

30 December 2011

05:31 dhaval jaiswal
05:36 streaming replication vacuum dhaval jaiswal
09:03 Re: Verifying a timestamp is null or in the past Alexander Farber
11:03 Re: streaming replication vacuum Magnus Hagander
12:07 Re: Verifying a timestamp is null or in the past Alban Hertroys
13:18 How to get the time zone offset Cezariusz Marek
13:33 duplicate key errors when restoring 8.4.0 database dump into 9.1.2 Culley Harrelson
13:51 Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2 Adrian Klaver
14:49 Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2 Culley Harrelson
15:06 Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2 Adrian Klaver
15:12 Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2 Culley Harrelson
15:14 Re: How to get the time zone offset Adrian Klaver
15:16 Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2 Nigel Heron
15:20 Re: How to get the time zone offset Cezariusz Marek
15:20 Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2 Adrian Klaver
15:21 Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2 Bèrto ëd Sèra
15:37 Re: How to get the time zone offset Adrian Klaver
15:51 Dated Version of PostgreSQL Carlos Mennens
15:51 Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2 Culley Harrelson
15:57 Re: How to get the time zone offset Adrian Klaver
15:59 Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2 Adrian Klaver
16:12 How to get the time zone offset Cezariusz Marek
16:12 pgoledb transaction error gato pardo
16:12 How to get the time zone offset using to_char Cezariusz Marek
16:13 How to get the time zone offset using to_char Cezariusz Marek
16:13 How to get the time zone offset using to_char Cezariusz Marek
16:13 How to get the time zone offset Cezariusz Marek
16:14 Re: Dated Version of PostgreSQL Carlos Mennens
16:39 Re: Dated Version of PostgreSQL Devrim GÜNDÜZ
16:41 Data Type for Money Carlos Mennens
16:43 Re: Dated Version of PostgreSQL Carlos Mennens
16:43 Re: Dated Version of PostgreSQL devrim@gunduz.org
16:46 Re: Data Type for Money Adrian Klaver
16:48 Re: Dated Version of PostgreSQL Devrim GÜNDÜZ
16:49 Re: How to get the time zone offset Cezariusz Marek
16:53 Re: Dated Version of PostgreSQL devrim@gunduz.org
17:10 Re: Data Type for Money Carlos Mennens
17:28 Re: Data Type for Money Tom Lane
17:34 Re: Verifying a timestamp is null or in the past Alexander Farber
17:35 Would whoever is at "Hi-Tech Gears Ltd, Gurgaon, India" fix their mailer? Tom Lane
17:36 Re: Data Type for Money Dann Corbit
19:25 Re: pgoledb transaction error David Johnston
22:16 join and having clause Alexander Farber
22:38 Re: join and having clause David Johnston
22:55 Large Objects and and Vacuum Simon Windsor
23:06 Re: streaming replication vacuum Scott Marlowe

31 December 2011

02:43 Re: streaming replication vacuum Simon Riggs
05:15 Re: Verifying a timestamp is null or in the past Alexander Farber
05:19 Re: Verifying a timestamp is null or in the past Alexander Farber
08:27 Re: Verifying a timestamp is null or in the past Raymond O'Donnell
16:38 Re: pgoledb transaction error gato pardo
20:02 Streaming replication failover Ben Chobot
22:38 Re: Streaming replication failover Tatsuo Ishii