Mailing lists [pgsql-general]

1 March 2010

• 00:08   Re: continuous copy/update one table to another Terry
• 00:18   Re: continuous copy/update one table to another John R Pierce
• 00:19   Confusion about users and roles C. Bensend
• 00:49   Re: Confusion about users and roles Tom Lane
• 06:00   Re: continuous copy/update one table to another Terry
• 06:09   Re: continuous copy/update one table to another Terry
• 07:49   Re: continuous copy/update one table to another Grzegorz Jaśkiewicz
• 07:59   Re: continuous copy/update one table to another Szymon Guz
• 08:43   Optimizer: ranges and partial indices? Or use partitioning? Adrian von Bidder
• 08:51   Re: continuous copy/update one table to another Adrian von Bidder
• 11:08   current transaction id AI Rumman
• 11:15   Re: current transaction id A. Kretschmer
• 12:28   Re: Confusion about users and roles C. Bensend
• 13:11   custom index michael uwe maier
• 13:11   Cannot remove prepared statement. Darryl Pye
• 14:39   Re: continuous copy/update one table to another Tom Lane
• 15:05   Re: Optimizer: ranges and partial indices? Or use partitioning? Tom Lane
• 15:21   Re: Cannot remove prepared statement. Tom Lane
• 17:43   Re: Cacti + PostgreSQL Graphing Marc G. Fournier
• 18:20   Re: Cacti + PostgreSQL Graphing Marc G. Fournier
• 18:37   Re: Cacti + PostgreSQL Graphing Brad Nicholson
• 21:47   Re: Hung postmaster (8.3.9) Ed L.
• 21:59   Re: Hung postmaster (8.3.9) Ed L.
• 22:03   Re: Hung postmaster (8.3.9) Ed L.
• 22:49   Re: Hung postmaster (8.3.9) Ed L.
• 22:50   Re: Hung postmaster (8.3.9) Tom Lane
• 22:57   Re: Hung postmaster (8.3.9) Tom Lane
• 23:06   Re: Hung postmaster (8.3.9) Ed L.
• 23:15   Re: Hung postmaster (8.3.9) Tom Lane
• 23:17   Re: Hung postmaster (8.3.9) Ed L.
• 23:18   Re: Hung postmaster (8.3.9) Tom Lane
• 23:21   Re: Hung postmaster (8.3.9) Ed L.
• 23:23   Re: Hung postmaster (8.3.9) Ed L.
• 23:25   Re: Hung postmaster (8.3.9) Ed L.
• 23:26   Re: Hung postmaster (8.3.9) Tom Lane
• 23:27   Re: Hung postmaster (8.3.9) Ed L.
• 23:36   Re: Hung postmaster (8.3.9) Ed L.
• 23:49   Re: Hung postmaster (8.3.9) Ed L.
• 23:57   Re: Hung postmaster (8.3.9) Tom Lane
• 23:59   Re: Hung postmaster (8.3.9) Tom Lane

2 March 2010

• 00:27   [SOLVED] Re: Hung postmaster (8.3.9) Ed L.
• 00:30   Re: [SOLVED] Re: Hung postmaster (8.3.9) Tom Lane
• 00:32   Re: Hung postmaster (8.3.9) Ed L.
• 00:49   Re: [SOLVED] Re: Hung postmaster (8.3.9) Ed L.
• 03:37   Re: Hung postmaster (8.3.9) Tom Lane
• 06:49   Re: Optimizer: ranges and partial indices? Or use partitioning? Adrian von Bidder
• 07:09   Re: [SOLVED] Re: Hung postmaster (8.3.9) Ed L.
• 08:49   Re: Hung postmaster (8.3.9) Greg Stark
• 09:43   to_timestamp() and quarters Asher Hoskins
• 10:12   How to grant a user read-only access to a database? Antonio Goméz Soto
• 10:28   Re: How to grant a user read-only access to a database? Thom Brown
• 10:47   Re: How to grant a user read-only access to a database? Nilesh Govindarajan
• 10:48   Re: Putting index entries to XLog Simon Riggs
• 10:53   Re: custom index Simon Riggs
• 10:57   need a query AI Rumman
• 11:02   Re: How to grant a user read-only access to a database? Thom Brown
• 11:12   Re: How to grant a user read-only access to a database? Craig Ringer
• 11:35   Re: need a query Pavel Stehule
• 13:49   Re: How to grant a user read-only access to a database? Antonio Goméz Soto
• 13:55   Re: to_timestamp() and quarters Tom Lane
• 13:57   Re: How to grant a user read-only access to a database? Thom Brown
• 14:15   Re: How to grant a user read-only access to a database? Raymond O'Donnell
• 14:16   Re: to_timestamp() and quarters A. Kretschmer
• 14:26   Re: How to grant a user read-only access to a database? Antonio Goméz Soto
• 14:34   Re: How to grant a user read-only access to a database? Said Ramirez
• 14:43   The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf Arnold, Sandra
• 16:00   I suspend the subscription maria teresa tarquino
• 16:08   tipo de dato Miguel Angel Hernandez Moreno
• 16:11   Re: to_timestamp() and quarters Scott Bailey
• 16:21   Array columns vs normalized table Lee Hachadoorian
• 16:48   disable triggers isolated to transaction only? Vick Khera
• 16:53   Re: tipo de dato Said Ramirez
• 16:55   Re: Array columns vs normalized table Pavel Stehule
• 16:57   Re: Array columns vs normalized table Peter Hunsberger
• 17:00   Re: Array columns vs normalized table Scott Bailey
• 17:15   Re: [ADMIN] The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf Chander Ganesan
• 17:22   createdb but revoke dropdb Ben Eliott
• 17:42   Re: Array columns vs normalized table Lee Hachadoorian
• 17:49   Re: disable triggers isolated to transaction only? Ben Chobot
• 18:20   Re: [ADMIN] The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf Scott Marlowe
• 18:24   Re: [ADMIN] The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf Scott Marlowe
• 18:54   Re: [ADMIN] The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf Scott Marlowe
• 20:12   FSM and VM file akp geek
• 20:30   Re: FSM and VM file Thomas Kellerer
• 20:31   Re: FSM and VM file Scott Mead
• 20:47   Re: FSM and VM file akp geek
• 22:23   Not all functions in schema pg_catalog are "visible" Thomas Kellerer
• 23:17   Re: disable triggers isolated to transaction only? Tom Lane

3 March 2010

• 00:30   SQL Syntax - like FIELD and BITPATTERN = BITPATTERN? Ozz Nixon
• 00:59   Re: [SOLVED] SQL Syntax - like FIELD and BITPATTERN = BITPATTERN? Ozz Nixon
• 02:32   Trigger help - updates to column data with null values Greg Fischer
• 03:07   Re: Trigger help - updates to column data with null values Craig Ringer
• 03:57   Re: Trigger help - updates to column data with null values Greg Fischer
• 04:08   Re: SQL Syntax - like FIELD and BITPATTERN = BITPATTERN? Harvey, Allan AC
• 08:13   Fwd: createdb but revoke dropdb Ben Eliott
• 08:18   Re: createdb but revoke dropdb Richard Huxton
• 08:41   Re: FSM and VM file Richard Huxton
• 08:57   Re: createdb but revoke dropdb Ben Eliott
• 10:08   Re: How to grant a user read-only access to a database? Nilesh Govindarajan
• 12:33   Re: FSM and VM file akp geek
• 12:37   Re: FSM and VM file Richard Huxton
• 12:44   stopping processes, preventing connections Herouth Maoz
• 12:54   Re: FSM and VM file Devrim GÜNDÜZ
• 13:29   Re: How to grant a user read-only access to a database? Merlin Moncure
• 13:44   Re: FSM and VM file akp geek
• 13:50   finding duplicate numbers in a select distinct statement Terry
• 13:51   Re: How to grant a user read-only access to a database? Kevin Kempter
• 14:00   Re: finding duplicate numbers in a select distinct statement Grzegorz Jaśkiewicz
• 14:02   Re: finding duplicate numbers in a select distinct statement Terry
• 14:04   Re: finding duplicate numbers in a select distinct statement Grzegorz Jaśkiewicz
• 14:05   bug in function arguments "recognition" Ivan Sergio Borgonovo
• 14:08   Re: How to grant a user read-only access to a database? Thom Brown
• 14:08   LDAP Login Problem Tom Robst
• 14:18   Re: LDAP Login Problem Magnus Hagander
• 14:20   Re: How to grant a user read-only access to a database? Tom Lane
• 14:24   Re: bug in function arguments "recognition" Tom Lane
• 14:30   Re: LDAP Login Problem Tom Robst
• 14:31   Re: bug in function arguments "recognition" Ivan Sergio Borgonovo
• 14:42   Re: bug in function arguments "recognition" Ivan Sergio Borgonovo
• 14:46   Re: disable triggers isolated to transaction only? Greg Sabino Mullane
• 14:50   Re: disable triggers isolated to transaction only? Richard Huxton
• 14:51   Massive table bloat Markus Wollny
• 14:56   Re: Massive table bloat Thom Brown
• 14:57   Re: Massive table bloat Grzegorz Jaśkiewicz
• 15:02   Re: stopping processes, preventing connections Josh Kupershmidt
• 15:07   Re: stopping processes, preventing connections Herouth Maoz
• 15:22   Raid 10 settings for optimal postgres performance? Chris Barnes
• 15:24   Work Mem Allocation Questions Brad Nicholson
• 15:45   Re: finding duplicate numbers in a select distinct statement Terry
• 15:48   Re: Work Mem Allocation Questions Bill Moran
• 16:44   Re: How to grant a user read-only access to a database? Kevin Kempter
• 16:46   Auto VACUUM akp geek
• 16:57   Re: Massive table bloat Markus Wollny
• 17:01   Re: Auto VACUUM Joao Ferreira gmail
• 17:09   Re: Auto VACUUM akp geek
• 17:13   PQntuples returns an int. Guillaume Yziquel
• 17:18   Larger volumes of chronologically ordered data and the planner John Moran
• 17:32   Re: stopping processes, preventing connections Josh Kupershmidt
• 17:36   Re: Larger volumes of chronologically ordered data and the planner Tom Lane
• 18:00   Re: PQntuples returns an int. Steve Atkins
• 19:40   Scratching my head why results are different between machines. Michael Gould
• 20:01   Re: Scratching my head why results are different between machines. Justin Graf
• 20:07   Re: PQntuples returns an int. Greg Sabino Mullane
• 20:08   Re: Raid 10 settings for optimal postgres performance? Greg Smith
• 20:24   Re: Larger volumes of chronologically ordered data and the planner Greg Smith
• 20:33   Re: Auto VACUUM Igor Neyman
• 20:44   Re: Cacti + PostgreSQL Graphing Marc G. Fournier
• 20:52   Re: Scratching my head why results are different between machines. Michael Gould
• 20:59   The REAL cost of joins Marcin Krol
• 21:17   Re: Scratching my head why results are different between machines. Michael Gould
• 21:26   Re: Cacti + PostgreSQL Graphing Marc G. Fournier
• 21:27   Re: PQntuples returns an int. Guillaume Yziquel
• 21:34   Re: The REAL cost of joins Peter Hunsberger
• 21:34   Re: Scratching my head why results are different between machines. Justin Graf
• 21:46   ArgoUML SQL code generator for PostgreSQL John Gage
• 22:50   Re: Scratching my head why results are different between machines. Michael Gould
• 23:22   Failed to run initdb: 128 Niranjan Maturi (nmaturi)
• 23:43   Failed to run initdb: 128 Niranjan Maturi (nmaturi)

4 March 2010

• 00:33   Re: Scratching my head why results are different between machines. Craig Ringer
• 00:35   Re: Scratching my head why results are different between machines. Craig Ringer
• 00:45   Re: Scratching my head why results are different between machines. Greg Sabino Mullane
• 00:54   Re: Scratching my head why results are different between machines. John R Pierce
• 00:54   Re: Scratching my head why results are different between machines. Scott Marlowe
• 00:57   Re: Scratching my head why results are different between machines. Scott Marlowe
• 06:09   Need to Reload a Dump File - Need to Delete the PGDATA directory Again? Wang, Mary Y
• 06:22   Re: Need to Reload a Dump File - Need to Delete the PGDATA directory Again? John R Pierce
• 07:48   Re: The REAL cost of joins Richard Huxton
• 07:49   Re: Scratching my head why results are different between machines. Dave Page
• 07:51   Re: Scratching my head why results are different between machines. Richard Huxton
• 08:04   Re: Failed to run initdb: 128 Richard Huxton
• 09:02   Re: The REAL cost of joins Grzegorz Jaśkiewicz
• 09:26   Re: Larger volumes of chronologically ordered data and the planner John Moran
• 10:49   Re: The REAL cost of joins Craig Ringer
• 10:53   Re: Failed to run initdb: 128 Magnus Hagander
• 12:12   Re: to_timestamp() and quarters Asher Hoskins
• 13:15   Re: Scratching my head why results are different between machines. Justin Graf
• 14:00   Re: The REAL cost of joins Merlin Moncure
• 14:01   Re: Scratching my head why results are different between machines. Greg Stark
• 15:04   Re: Auto VACUUM akp geek
• 15:15   Re: Scratching my head why results are different between machines. Justin Graf
• 15:34   Re: Auto VACUUM Joshua D. Drake
• 15:36   non intuitive behaviour of DROP TABLE IF EXISTS Manlio Perillo
• 16:04   Re: Scratching my head why results are different between machines. Scott Marlowe
• 16:07   ERROR: row is too big: size 8176, maximum size 8160 DimitryASuplatov
• 16:13   Re: ERROR: row is too big: size 8176, maximum size 8160 Andreas Kretschmer
• 16:26   join from multiple tables Terry
• 16:33   Re: join from multiple tables Thom Brown
• 16:43   Re: join from multiple tables Terry
• 18:25   Re: The REAL cost of joins Simon Riggs
• 18:32   Optimal database table optimization method Roger Tannous
• 18:44   Re: join from multiple tables Terry
• 18:47   Can you set the date output format (to_char style) per session? Joshua Johnston
• 18:51   Re: Can you set the date output format (to_char style) per session? Pavel Stehule
• 18:54   Re: Can you set the date output format (to_char style) per session? Joshua Johnston
• 19:33   Re: Optimal database table optimization method John R Pierce
• 19:43   Re: Failed to run initdb: 128 Niranjan Maturi (nmaturi)
• 19:57   Re: Optimal database table optimization method Adrian von Bidder
• 20:30   Connection timeouts from pgAdmin Lee Hachadoorian
• 21:01   Re: Connection timeouts from pgAdmin John R Pierce
• 21:26   Re: Connection timeouts from pgAdmin Lee Hachadoorian
• 21:59   Re: select issue with order v8.1 Terry
• 22:18   Re: join from multiple tables Terry
• 22:21   Re: Optimal database table optimization method Dann Corbit
• 22:34   Re: Auto VACUUM Joshua D. Drake
• 22:53   Restore Data Encountered the ERROR: literal carriage return found in data Error Wang, Mary Y
• 23:19   Foreign key behavior different in a function and outside Mridula Mahadevan

5 March 2010

• 00:03   Re: Optimal database table optimization method John R Pierce
• 01:17   need some advanced books on Postgres Thomas
• 02:45   Re: Foreign key behavior different in a function and outside Tom Lane
• 05:46   Re: Foreign key behavior different in a function and outside Mridula Mahadevan
• 06:17   Re: need some advanced books on Postgres Adrian von Bidder
• 06:55   Re: ERROR: row is too big: size 8176, maximum size 8160 Albe Laurenz
• 07:17   Optimizations Ogden
• 07:27   Re: Optimizations Craig Ringer
• 07:31   Re: ERROR: row is too big: size 8176, maximum size 8160 Scott Marlowe
• 08:00   Re: Failed to run initdb: 128 Richard Huxton
• 08:05   Re: need some advanced books on Postgres Richard Huxton
• 08:13   Re: ERROR: row is too big: size 8176, maximum size 8160 Albe Laurenz
• 08:14   Re: join from multiple tables Grzegorz Jaśkiewicz
• 08:15   Re: Restore Data Encountered the ERROR: literal carriage return found in data Error Richard Huxton
• 08:27   Re: Foreign key behavior different in a function and outside Richard Huxton
• 10:41   Is there any oracle user_source table equivalent in postgre? venkatrao.b@tcs.com
• 10:48   Re: Is there any oracle user_source table equivalent in postgre? Thomas Kellerer
• 10:58   Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? Vibhor Kumar
• 11:04   Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? venkatrao.b@tcs.com
• 11:10   Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? Pavel Stehule
• 11:11   Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? Devrim GÜNDÜZ
• 11:19   Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? Thomas Kellerer
• 11:20   Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? venkatrao.b@tcs.com
• 11:43   Xpath Index in PostgreSQL Chris Roffler
• 12:22   Re: Xpath Index in PostgreSQL Tom Lane
• 12:30   Re: ERROR: row is too big: size 8176, maximum size 8160 Tom Lane
• 12:34   Re: need some advanced books on Postgres Tom Lane
• 12:36   Re: Restore Data Encountered the ERROR: literal carriage return found in data Error Tom Lane
• 13:10   Re: Optimizations Ogden
• 13:19   Re: Xpath Index in PostgreSQL Chris Roffler
• 14:04   Re: Auto VACUUM akp geek
• 14:14   Re: FSM and VM file akp geek
• 14:20   Re: select issue with order v8.1 Adrian Klaver
• 14:22   Re: Xpath Index in PostgreSQL Chris Roffler
• 14:33   Re: Auto VACUUM Joao Ferreira gmail
• 14:35   Re: Auto VACUUM akp geek
• 15:23   XML performance tuning Chris Roffler
• 16:36   character confusion Steve Crawford
• 16:37   kernel version impact on PostgreSQL performance Cyril Scetbon
• 16:37   For Loop using row_data to increase performance John777
• 16:37   kernel version impact on PostgreSQL performance Cyril Scetbon
• 16:37   Re: For Loop using row_data to increase performance John777
• 16:37   Re: need some advanced books on Postgres Thomas
• 16:49   log_statement and syslog severity G Dutton
• 16:50   Re: kernel version impact on PostgreSQL performance Scott Marlowe
• 16:59   Re: kernel version impact on PostgreSQL performance John R Pierce
• 17:12   Re: Foreign key behavior different in a function and outside Mridula Mahadevan
• 18:19   Re: kernel version impact on PostgreSQL performance Greg Smith
• 19:59   Re: Restore Data Encountered the ERROR: literal carriage return found in data Error Wang, Mary Y
• 20:19   Re: character confusion Tom Lane
• 21:07   Re: For Loop using row_data to increase performance Alban Hertroys
• 22:11   Re: need some advanced books on Postgres Pedro Doria Meunier

6 March 2010

• 00:06   What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)? Wang, Mary Y
• 00:37   Re: Optimizations Craig Ringer
• 03:27   9.0 VACUUM FULL vs. ALTER TABLE? Noah Misch
• 09:12   How to find details of arguments in all functions in postgre - One solution venkatrao.b@tcs.com
• 10:52   Re: [NOVICE] How to find details of arguments in all functions in postgre - One solution Michael Wood
• 12:22   Libpq: copy file to bytea column seiliki@so-net.net.tw
• 12:55   Filesysstems Adrian von Bidder
• 14:27   Re: 9.0 VACUUM FULL vs. ALTER TABLE? Tom Lane
• 15:05   Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)? Tom Lane
• 18:01   Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)? Wang, Mary Y
• 19:37   Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)? Dimitri Fontaine
• 20:38   Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)? Tom Lane

7 March 2010

• 00:01   Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)? Scott Ribe
• 00:16   Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)? Tom Lane
• 00:49   Re: non intuitive behaviour of DROP TABLE IF EXISTS Bruce Momjian
• 01:47   Re: XML performance tuning Bruce Momjian
• 01:49   Re: log_statement and syslog severity Bruce Momjian
• 07:45   Avoiding duplicates (or at least marking them as such) in a "cumulative" transaction table. Allan Kamau
• 09:02   XML Index again Chris Roffler
• 09:40   compare two schemas AI Rumman
• 09:44   Re: non intuitive behaviour of DROP TABLE IF EXISTS Adrian von Bidder
• 09:49   Re: compare two schemas Devrim GÜNDÜZ
• 10:11   Re: XML Index again Alban Hertroys
• 10:37   accessing the words in a full text index Massa, Harald Armin
• 11:18   Re: XML Index again Chris
• 11:32   timestamp literal out of line Martijn van Oosterhout
• 13:21   Re: accessing the words in a full text index Dimitri Fontaine
• 14:34   Re: timestamp literal out of line Tom Lane
• 14:39   should I reindex the table of more than 10 millions rows regularly when more data are inserted? zxo102 ouyang
• 14:44   Re: should I reindex the table of more than 10 millions rows regularly when more data are inserted? Szymon Guz
• 16:24   Re: timestamp literal out of line Thomas Kellerer
• 17:10   Evaluation of Postgresql using DBT2 Megha
• 18:04   postgresql 8.2 startup script Aleksandar Sosic
• 18:11   Evaluation of Postgresql using DBT2 Megha
• 18:26   Re: postgresql 8.2 startup script Alban Hertroys
• 23:37   ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error Wang, Mary Y

8 March 2010

• 00:08   Re: Transaction wraparound problem with database postgres Markus Wollny
• 01:26   Re: Transaction wraparound problem with database postgres Scott Marlowe
• 01:49   Re: Avoiding duplicates (or at least marking them as such) in a "cumulative" transaction table. Scott Marlowe
• 02:30   psql uses default user from kerberos ticket not the current user Dmitry Litvintsev
• 02:36   Re: postgresql 8.2 startup script Vick Khera
• 03:05   Re: psql uses default user from kerberos ticket not the current user Tom Lane
• 04:52   How to read oracle table's data from postgre venkatrao.b@tcs.com
• 05:04   Re: How to read oracle table's data from postgre John R Pierce
• 05:07   Re: [NOVICE] How to read oracle table's data from postgre Devrim GÜNDÜZ
• 05:31   Re: Avoiding duplicates (or at least marking them as such) in a "cumulative" transaction table. Allan Kamau
• 05:59   obsessive-compulsive vacuum behavior Ben Chobot
• 06:16   Re: Avoiding duplicates (or at least marking them as such) in a "cumulative" transaction table. Scott Marlowe
• 07:20   Re: obsessive-compulsive vacuum behavior Scott Marlowe
• 07:21   Re: obsessive-compulsive vacuum behavior Scott Marlowe
• 07:22   Re: [NOVICE] How to read oracle table's data from postgre Scott Marlowe
• 07:26   Re: Libpq: copy file to bytea column Albe Laurenz
• 07:26   Re: kernel version impact on PostgreSQL performance Albe Laurenz
• 07:27   Re: Transaction wraparound problem with database postgres Markus Wollny
• 07:27   Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error Albe Laurenz
• 07:36   Re: Transaction wraparound problem with database postgres Scott Marlowe
• 07:45   Re: Avoiding duplicates (or at least marking them as such) in a "cumulative" transaction table. Allan Kamau
• 08:55   Re: FSM and VM file Richard Huxton
• 09:04   Re: Foreign key behavior different in a function and outside Richard Huxton
• 09:06   2 questions when using vs2005 to debug PG chaoyong wang
• 09:11   Fwd: postgresql 8.2 startup script Alban Hertroys
• 09:24   Re: Failed to run initdb: 128 Richard Huxton
• 09:36   Re: Failed to run initdb: 128 Magnus Hagander
• 09:39   Re: XML Index again Chris Roffler
• 10:28   Re: XML Index again Alban Hertroys
• 10:33   Re: XML Index again Alban Hertroys
• 11:12   How to find out if row was modified by EXECUTE UPDATE ... A B
• 11:18   Re: How to find out if row was modified by EXECUTE UPDATE ... Pavel Stehule
• 11:23   Re: XML Index again Chris Roffler
• 11:35   Re: XML Index again Alban Hertroys
• 11:38   Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error Michał Pawlikowski
• 11:50   Re: XML Index again Chris Roffler
• 11:53   Re: Libpq: copy file to bytea column seiliki@so-net.net.tw
• 12:52   Re: Libpq: copy file to bytea column seiliki@so-net.net.tw
• 14:02   PostgreSQL RPM sets for 9.0 Alpha4 released Devrim GÜNDÜZ
• 14:16   Re: obsessive-compulsive vacuum behavior Tom Lane
• 15:59   Entering a character code in a query John Gage
• 16:01   8.3.10 Changes Brad Nicholson
• 16:06   ERROR: Package compat-postgresql-libs-4-1PGDG.rhel4.i386.rpm is not signed Padmanabhan G
• 16:06   2 questions to ask chaoyong wang
• 16:16   Re: 8.3.10 Changes Tom Lane
• 18:35   Enterprise DB's windows package and upgrading windows. John Moran
• 18:47   Re: Enterprise DB's windows package and upgrading windows. Dave Page
• 19:22   DROP column: documentation unclear Adrian von Bidder
• 19:43   managing tablespaces like files? Sam Carleton
• 19:52   Re: managing tablespaces like files? John R Pierce
• 20:07   Re: managing tablespaces like files? John R Pierce
• 20:36   Re: DROP column: documentation unclear Martijn van Oosterhout
• 20:49   Re: managing tablespaces like files? Sam Carleton
• 21:08   Re: managing tablespaces like files? Sam Carleton
• 21:28   autovacuum question Scot Kreienkamp
• 21:46   Re: managing tablespaces like files? John R Pierce
• 23:09   Re: managing tablespaces like files? Sam Carleton
• 23:59   Re: managing tablespaces like files? Tom Lane

9 March 2010

• 01:46   Re: managing tablespaces like files? Scott Mead
• 01:50   Re: autovacuum question Scott Mead
• 02:10   Re: autovacuum question Scot Kreienkamp
• 02:31   Re: autovacuum question Tom Lane
• 04:10   Re: managing tablespaces like files? Sam Carleton
• 05:21   Is it possible to findout actual owner of table? dipti shah
• 05:24   Re: Is it possible to findout actual owner of table? Tom Lane
• 05:27   How to save existing permissions on schema and later on restore it? dipti shah
• 05:29   Re: Is it possible to findout actual owner of table? dipti shah
• 05:50   Re: Is it possible to findout actual owner of table? John R Pierce
• 06:15   Re: [NOVICE] How to read oracle table's data from postgre Greg Smith
• 06:21   Re: kernel version impact on PostgreSQL performance Greg Smith
• 06:35   Re: kernel version impact on PostgreSQL performance John R Pierce
• 06:36   Re: Is it possible to findout actual owner of table? dipti shah
• 06:43   Re: Is it possible to findout actual owner of table? John R Pierce
• 07:21   Re: Is it possible to findout actual owner of table? dipti shah
• 07:50   Unexpected result from selecting an aliased but non-existing column called "name" Ian Barwick
• 07:53   has_schema_privilege function dipti shah
• 08:02   Re: kernel version impact on PostgreSQL performance Rodger Donaldson
• 09:19   Can we overload = operator to word numeric = text venkatrao.b@tcs.com
• 09:29   has_schema_privilege function Jignesh Shah
• 09:37   Re: Can we overload = operator to word numeric = text Pavel Stehule
• 10:47   Re: Can we overload = operator to word numeric = text venkatrao.b@tcs.com
• 11:04   warm standby possible with 8.1? zhong ming wu
• 11:24   Re: Libpq: copy file to bytea column Albe Laurenz
• 11:33   Re: Entering a character code in a query Albe Laurenz
• 12:47   Re: autovacuum question Scot Kreienkamp
• 12:51   Urgent help needed- alias name in update statement venkatrao.b@tcs.com
• 13:21   Re: Unexpected result from selecting an aliased but non-existing column called "name" Adrian Klaver
• 13:26   Re: Urgent help needed- alias name in update statement Adrian Klaver
• 13:28   Re: Urgent help needed- alias name in update statement Raymond O'Donnell
• 13:33   Re: has_schema_privilege function Greg Stark
• 13:39   Re: autovacuum question Greg Stark
• 13:48   Re: autovacuum question Scot Kreienkamp
• 13:56   Re: autovacuum question Scott Marlowe
• 14:01   Re: autovacuum question Scott Mead
• 14:04   Re: autovacuum question Scot Kreienkamp
• 14:06   Re: managing tablespaces like files? Justin Graf
• 14:23   Re: log_statement and syslog severity Greg Sabino Mullane
• 14:23   Re: autovacuum question Scott Mead
• 14:26   Re: autovacuum question Scot Kreienkamp
• 14:32   Re: autovacuum question Bryan Montgomery
• 14:42   How many file descriptors does postgres need? Royce Ausburn
• 14:47   Re: autovacuum question Scot Kreienkamp
• 14:48   Re: How many file descriptors does postgres need? Steve Atkins
• 15:04   Re: Entering a character code in a query John Gage
• 15:06   Re: How many file descriptors does postgres need? Tom Lane
• 15:37   Update view/table rule order of operations or race condition Dan Fitzpatrick
• 15:59   Re: kernel version impact on PostgreSQL performance Greg Smith
• 16:14   \copy command: how to define a tab character as the delimiter Thomas Kellerer
• 16:17   Re: DROP column: documentation unclear Harald Fuchs
• 16:22   Re: \copy command: how to define a tab character as the delimiter Tom Lane
• 16:23   Re: Trying to get a C function built with MSVC Bryan Montgomery
• 16:24   question on 8.4.2 build postgres C functions Steve Coleman
• 16:28   Re: DROP column: documentation unclear Tom Lane
• 16:30   Re: \copy command: how to define a tab character as the delimiter Thomas Kellerer
• 16:33   Re: question on 8.4.2 build postgres C functions Tom Lane
• 16:39   Re: \copy command: how to define a tab character as the delimiter Raymond O'Donnell
• 16:42   Re: Update view/table rule order of operations or race condition Dan Fitzpatrick
• 16:56   Re: question on 8.4.2 build postgres C functions Tom Lane
• 17:00   Re: Update view/table rule order of operations or race condition Tom Lane
• 17:10   Re: \copy command: how to define a tab character as the delimiter Thomas Kellerer
• 17:21   PostgreSQL Conference East, Hotel Discount Deadline Joshua D. Drake
• 17:47   Re: \copy command: how to define a tab character as the delimiter Tom Lane
• 18:20   Re: Update view/table rule order of operations or race condition Dan Fitzpatrick
• 18:22   Re: \copy command: how to define a tab character as the delimiter Adrian Klaver
• 18:45   Re: Not all functions in schema pg_catalog are "visible" Alvaro Herrera
• 18:45   Re: obsessive-compulsive vacuum behavior Ben Chobot
• 18:49   Re: [pgsql-ru-general] Deleting Large Objects Serguei Mokhov
• 20:17   How to? Timestamp with timezone. Andre Lopes
• 20:23   Re: kernel version impact on PostgreSQL performance Rodger Donaldson
• 20:25   Discovering Postgres Server from Windows Clients imageguy
• 20:31   Postgres GIS Question akp geek
• 20:34   Re: Discovering Postgres Server from Windows Clients Vick Khera
• 20:53   Re: Postgres GIS Question Jeff Davis
• 20:55   Re: How to? Timestamp with timezone. Tom Lane
• 21:07   Re: How to? Timestamp with timezone. Andre Lopes
• 21:37   Re: How to? Timestamp with timezone. John R Pierce
• 21:48   Re: warm standby possible with 8.1? Greg Smith

10 March 2010

• 00:06   Re: How to? Timestamp with timezone. Alvaro Herrera
• 00:15   subscribe Andrew Boag
• 00:21   PostgreSQL Conference East, Hotel Discount Deadline Joshua D. Drake
• 00:51   Re: log_statement and syslog severity Bruce Momjian
• 04:32   Postgresql 8.1 AI Rumman
• 04:38   Re: Postgresql 8.1 Ben Chobot
• 05:04   error: C preprocessor "/lib/cpp" fails sanity check AI Rumman
• 05:11   Re: error: C preprocessor "/lib/cpp" fails sanity check John R Pierce
• 05:54   SAS Raid10 vs SATA II Raid10 - many small reads and writes Phillip Berry
• 06:07   Re: error: C preprocessor "/lib/cpp" fails sanity check Peter Eisentraut
• 06:32   Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes Scott Marlowe
• 06:50   Re: managing tablespaces like files? Sam Carleton
• 07:39   Re: log_statement and syslog severity Stuart Bishop
• 07:49   Re: log_statement and syslog severity Magnus Hagander
• 08:00   Re: How to? Timestamp with timezone. Andre Lopes
• 08:33   Re: Urgent help needed- alias name in update statement Albe Laurenz
• 10:54   make available C extensions to others Ivan Sergio Borgonovo
• 11:12   Re: make available C extensions to others Dimitri Fontaine
• 11:42   regexp_replace puzzle Harald Fuchs
• 11:47   Re: How to? Timestamp with timezone. Alvaro Herrera
• 13:37   Re: regexp_replace puzzle Osvaldo Kussama
• 14:01   Licence Jonathan Tripathy
• 14:10   Re: Licence Thom Brown
• 14:20   Re: Licence Bill Moran
• 15:17   Statement Triggers Gordan Bobic
• 15:55   Re: log_statement and syslog severity Ben Chobot
• 15:57   Re: regexp_replace puzzle David W Noon
• 16:03   Re: How to? Timestamp with timezone. Steve Crawford
• 16:35   Re: Licence Steve Crawford
• 17:02   Re: Connection timeouts from pgAdmin Lee Hachadoorian
• 17:22   Re: log_statement and syslog severity dennis jenkins
• 23:07   crosstab functionality for postgres 8.1.4 Amol Chiplunkar

11 March 2010

• 00:17   Naming conventions for lots of stored procedures Chris Travers
• 00:43   Re: log_statement and syslog severity Bruce Momjian
• 01:36   Finding duplicates only. Greenhorn
• 01:37   dst question jgirvin
• 01:56   Re: crosstab functionality for postgres 8.1.4 Merlin Moncure
• 02:13   Re: Naming conventions for lots of stored procedures Justin Graf
• 02:20   Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes Phillip Berry
• 03:11   Re: crosstab functionality for postgres 8.1.4 Tom Lane
• 03:52   Re: Naming conventions for lots of stored procedures Chris Travers
• 04:53   Re: dst question Tom Lane
• 06:00   Re: Finding duplicates only. A. Kretschmer
• 06:14   Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes Magnus Hagander
• 06:35   Re: Statement Triggers A. Kretschmer
• 07:45   Re: SAS Raid10 vs SATA II Raid10 - many small reads and writes Greg Smith
• 10:24   Replacing an index item Carsten Kropf
• 10:58   how to remove super user Jowad Bouzian
• 11:04   Re: how to remove super user Filip Rembiałkowski
• 11:06   Re: how to remove super user Ashesh Vashi
• 12:30   Re: Naming conventions for lots of stored procedures Justin Graf
• 13:18   instaling ossp-uuid dunasoft@dunasoft.es
• 13:26   Re: instaling ossp-uuid Devrim GÜNDÜZ
• 14:20   Re: Replacing an index item Tom Lane
• 15:39   Re: Naming conventions for lots of stored procedures Chris Travers
• 16:07   Re: log_statement and syslog severity Greg Smith
• 16:23   Re: Naming conventions for lots of stored procedures Gerhard Heift
• 16:52   Small install (w/ pSQLODBC support) needed. Ozz Nixon
• 17:54   Joining one-to-one and one-to-many tables Jeff Ross
• 17:54   Re: Small install (w/ pSQLODBC support) needed. Sachin Srivastava
• 17:56   Re: kernel version impact on PostgreSQL performance Cyril Scetbon
• 18:11   Re: Naming conventions for lots of stored procedures Pavel Stehule
• 18:25   Re: Joining one-to-one and one-to-many tables Garrett Murphy
• 19:14   createdb: ... duplicate key value violates unique constraint "pg_database_datname_index" Dave Vitek
• 19:17   Re: createdb: ... duplicate key value violates unique constraint "pg_database_datname_index" Dave Vitek
• 21:35   PgEast Hotel discount deadline today! Joshua D. Drake

12 March 2010

• 00:31   recuperar nodo en estado 3 Miguel Angel Hernandez Moreno
• 00:44   Re: dst question jgirvin
• 03:51   querying the value of the previous row Chris Velevitch
• 04:34   PgEast Hotel discount deadline today! Joshua D. Drake
• 05:13   Re: querying the value of the previous row A. Kretschmer
• 05:15   Re: querying the value of the previous row John R Pierce
• 11:25   REVOKE ... FROM everybody? Adrian von Bidder
• 13:45   Unable to call functions defined in XML2 contrib Franclin Foping
• 14:01   beginning and ending of sessions jody
• 14:04   Re: REVOKE ... FROM everybody? Alvaro Herrera
• 14:05   Re: Postgres GIS Question akp geek
• 14:10   Re: beginning and ending of sessions Guillaume Lelarge
• 14:34   Re: Unable to call functions defined in XML2 contrib Tom Lane
• 15:29   Function with DEFAULT arguments dario.ber@libero.it
• 15:38   Re: Function with DEFAULT arguments hubert depesz lubaczewski
• 15:40   Re: Unable to call functions defined in XML2 contrib Franclin Foping
• 15:50   R: Re: Function with DEFAULT arguments dario.ber@libero.it
• 15:52   Re: Function with DEFAULT arguments Tom Lane
• 16:08   Re: Function with DEFAULT arguments Scott Bailey
• 16:17   [RFC] Comments on PostPic project Domenico Rotiroti
• 16:40   Re: Function with DEFAULT arguments Tom Lane
• 16:40   [RFC] Comments on PostPic project Domenico Rotiroti
• 18:43   Re: Joining one-to-one and one-to-many tables Jeff Ross
• 19:21   Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error Wang, Mary Y
• 19:48   Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error Alvaro Herrera
• 19:51   Re: ERROR: invalid byte sequence for encoding "UTF8":0x93 Error Wang, Mary Y
• 19:57   Re: ERROR: invalid byte sequence for encoding "UTF8":0x93 Error Wang, Mary Y
• 21:04   static build from source on windows Jan
• 21:49   unexplained autovacuum to prevent wraparound Gordon Shannon
• 22:31   Re: unexplained autovacuum to prevent wraparound Alvaro Herrera
• 22:46   Re: unexplained autovacuum to prevent wraparound Gordon Shannon
• 23:20   Re: unexplained autovacuum to prevent wraparound Joshua D. Drake
• 23:38   Re: Function with DEFAULT arguments dario.ber@libero.it

13 March 2010

• 00:19   Re: unexplained autovacuum to prevent wraparound Gordon Shannon
• 01:13   How to remove superuser Harry Gold
• 01:52   Re: How to remove superuser John R Pierce
• 01:56   Re: How to remove superuser Bruce Momjian
• 02:45   Re: How to remove superuser John R Pierce
• 04:20   Re: Function with DEFAULT arguments Pavel Stehule
• 06:19   Re: unexplained autovacuum to prevent wraparound Joshua D. Drake
• 07:34   hardware for a server A B
• 08:25   Re: hardware for a server Scott Marlowe
• 10:23   explicit cast for null::bigint Ivan Sergio Borgonovo
• 10:54   Hints for postgresql package recompilation (FIXED) Angel
• 11:48   restoring a database to its initial state Manlio Perillo
• 12:26   Re: restoring a database to its initial state Pavel Stehule
• 14:06   Re: restoring a database to its initial state Adrian von Bidder
• 15:07   unexplained autovacuum to prevent wraparound Gordon Shannon
• 15:21   Re: restoring a database to its initial state Tom Lane
• 18:19   Re: ERROR: Package compat-postgresql-libs-4-1PGDG.rhel4.i386.rpm is not signed Lacey Powers
• 19:33   libpq: compatibility with server versions fkater@googlemail.com

14 March 2010

• 04:35   Re: unexplained autovacuum to prevent wraparound Gordon Shannon
• 08:54   Options for fsync? A B
• 09:28   Re: Options for fsync? John R Pierce
• 14:43   Re: unexplained autovacuum to prevent wraparound Alvaro Herrera
• 16:29   OIDs depending data -- how to dump/restore? fkater@googlemail.com
• 16:41   Re: OIDs depending data -- how to dump/restore? Raymond O'Donnell
• 17:10   Re: hardware for a server Vick Khera
• 18:19   Re: OIDs depending data -- how to dump/restore? Adrian Klaver
• 18:19   Is there any easy way to determine a default value specified for table column? Belka Lambda
• 18:52   Re: Is there any easy way to determine a default value specified for table column? Thomas Kellerer
• 19:23   Re: Re: Is there any easy way to determine a default value specified for table column? Tom Lane
• 20:10   Re: OIDs depending data -- how to dump/restore? fkater@googlemail.com
• 20:12   Re: unexplained autovacuum to prevent wraparound Gordon Shannon
• 20:22   Re: OIDs depending data -- how to dump/restore? Adrian Klaver

15 March 2010

• 00:27   $libdir/plugins/plugin_debugger.dll Carlo Stonebanks
• 00:27   Yikes: ERROR: out of memory Carlo Stonebanks
• 01:34   Installing Postgresql on Windows XP embedded Jeffrey Ottery
• 06:44   How can I create a database at a different path and not accessible by others Rekha Ravi Pai
• 07:00   Re: How can I create a database at a different path and not accessible by others John R Pierce
• 07:41   Re: Yikes: ERROR: out of memory Martijn van Oosterhout
• 08:22   Re: $libdir/plugins/plugin_debugger.dll Dave Page
• 08:23   Re: Installing Postgresql on Windows XP embedded Dave Page
• 08:42   Re: Yikes: ERROR: out of memory Albe Laurenz
• 08:43   Faicng problem while creating system DSN itishree sukla
• 08:51   Re: libpq: compatibility with server versions Albe Laurenz
• 09:14   Postgres 8.4 Segfault on xpath Frank jansen
• 10:52   Re: Postgres 8.4 Segfault on xpath Dimitri Fontaine
• 11:24   Unable to connect to Postgres database from email marketing software on the same host Major Services
• 11:51   Re: Unable to connect to Postgres database from email marketing software on the same host A. Kretschmer
• 11:55   Re: Unable to connect to Postgres database from email marketing software on the same host Raymond O'Donnell
• 11:56   Re: Postgres 8.4 Segfault on xpath Magnus Hagander
• 12:13   Fwd: Unable to connect to Postgres database from email marketing software on the same host Major Services
• 12:18   Re: Unable to connect to Postgres database from email marketing software on the same host Major Services
• 12:27   Re: Unable to connect to Postgres database from email marketing software on the same host A. Kretschmer
• 12:55   Re: hardware for a server Greg Smith
• 12:56   Re: Unable to connect to Postgres database from email marketing software on the same host Major Services
• 13:02   Re: Options for fsync? Greg Smith
• 13:16   Re: Unable to connect to Postgres database from email marketing software on the same host A. Kretschmer
• 13:26   Re: Postgres 8.4 Segfault on xpath Frank jansen
• 13:33   Re: Installing Postgresql on Windows XP embedded Jeffrey Ottery
• 15:09   Re: libpq: compatibility with server versions Vick Khera
• 15:22   Move to core xml from contrib/xml2 Frank jansen
• 15:25   Re: libpq: compatibility with server versions fkater@googlemail.com
• 15:39   Re: libpq: compatibility with server versions Vick Khera
• 16:54   Re: hardware for a server A B
• 16:55   Re: Postgres 8.4 Segfault on xpath Alvaro Herrera
• 17:00   integer_datetime: 8.2/8.4 differences ? fkater@googlemail.com
• 18:04   Re: Installing Postgresql on Windows XP embedded John R Pierce
• 18:06   Efficient "filter query" with positive and/or negative conditions Anders Steinlein
• 19:03   Re: hardware for a server Bruce Momjian
• 19:15   Re: integer_datetime: 8.2/8.4 differences ? Tom Lane
• 19:27   Re: hardware for a server Vick Khera
• 19:57   Daylight savings time confusion Rob Richardson
• 20:56   Re: Installing Postgresql on Windows XP embedded John R Pierce
• 20:56   Re: hardware for a server John R Pierce
• 20:57   Re: Installing Postgresql on Windows XP embedded Magnus Hagander
• 20:59   Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700) Joseph S
• 21:02   FW: 8.4.2 One Click Installer Arnold, Sandra
• 21:03   Re: Daylight savings time confusion Justin Graf
• 21:05   Re: Daylight savings time confusion Rob Richardson
• 21:19   Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700) Magnus Hagander
• 21:24   Re: Move to core xml from contrib/xml2 Bruce Momjian
• 21:36   Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700) Richard Huxton
• 21:50   Re: FW: 8.4.2 One Click Installer Richard Huxton
• 22:37   Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700) Joseph S
• 23:00   Re: Daylight savings time confusion Steve Crawford
• 23:10   Re: Daylight savings time confusion Adrian Klaver
• 23:42   Re: Daylight savings time confusion Tom Lane

16 March 2010

• 00:48   Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700) Tom Lane
• 06:16   Re: ERROR: Package compat-postgresql-libs-4-1PGDG.rhel4.i386.rpm is not signed Padmanabhan G
• 07:34   Re: hardware for a server Greg Smith
• 07:38   Re: hardware for a server Greg Smith
• 07:52   Re: hardware for a server Greg Smith
• 10:29   Text search Chris Roffler
• 12:12   reuse data in existing data directory Peter Schmidtke
• 12:21   Re: Text search Richard Huxton
• 12:24   Re: reuse data in existing data directory Richard Huxton
• 12:36   Re: Text search Chris Roffler
• 13:06   UPDATE with JOIN not using index Arnaud Lesauvage
• 13:49   Re: Text search Richard Huxton
• 13:50   Re: UPDATE with JOIN not using index Richard Huxton
• 13:57   Re: UPDATE with JOIN not using index Arnaud Lesauvage
• 14:27   Re: hardware for a server Bruce Momjian
• 14:35   Re: UPDATE with JOIN not using index Richard Huxton
• 14:37   Re: UPDATE with JOIN not using index Tom Lane
• 14:40   Re: Text search Richard Huxton
• 14:50   Re: UPDATE with JOIN not using index Arnaud Lesauvage
• 14:59   Re: Text search Chris Roffler
• 15:08   Re: UPDATE with JOIN not using index tv@fuzzy.cz
• 15:09   Re: UPDATE with JOIN not using index Arnaud Lesauvage
• 15:11   Re: UPDATE with JOIN not using index Arnaud Lesauvage
• 15:13   Re: Daylight savings time confusion Alvaro Herrera
• 15:15   Re: restoring a database to its initial state Manlio Perillo
• 15:39   Re: Move to core xml from contrib/xml2 Frank jansen
• 15:47   Re: Move to core xml from contrib/xml2 Tom Lane
• 15:52   Re: UPDATE with JOIN not using index Tom Lane
• 16:36   Re: UPDATE with JOIN not using index Arnaud Lesauvage
• 17:11   Re: reuse data in existing data directory Peter Schmidtke
• 19:28   app table names Jamie Kahgee
• 19:37   Best ISP for Postgres John Gage
• 19:44   Re: app table names Scott Marlowe
• 20:04   Answer to my own question John Gage
• 20:35   Re: app table names Vick Khera
• 21:25   Re: app table names Justin Graf
• 23:43   Result order of Insert ... returning fsfeel
• 23:45   Re: app table names Joshua D. Drake

17 March 2010

• 01:13   return row from plpgsql? zhong ming wu
• 05:38   Re: app table names Joshua D. Drake
• 06:04   Re: return row from plpgsql? A. Kretschmer
• 08:12   Avoiding SQL injection in Dynamic Queries (in plpgsql) Allan Kamau
• 08:43   Re: Avoiding SQL injection in Dynamic Queries (in plpgsql) Craig Ringer
• 09:06   Re: Avoiding SQL injection in Dynamic Queries (in plpgsql) Allan Kamau
• 10:32   Re: stopping processes, preventing connections Herouth Maoz
• 10:53   Re: Avoiding SQL injection in Dynamic Queries (in plpgsql) Pavel Stehule
• 11:07   Re: return row from plpgsql? zhong ming wu
• 11:34   Re: stopping processes, preventing connections Craig Ringer
• 12:04   Bulkdelete and Vacuum operations on custom index Carsten Kropf
• 12:43   Re: stopping processes, preventing connections Herouth Maoz
• 12:56   Re: stopping processes, preventing connections Craig Ringer
• 13:08   Re: stopping processes, preventing connections Herouth Maoz
• 13:58   db error messages when I try to debug with pgadmin josep porres
• 14:04   Re: app table names Vick Khera
• 14:11   Re: Unexpected result from selecting an aliased but non-existing column called "name" Ian Barwick
• 14:37   DBT-2 Error Chokshi, Meghaben
• 14:43   Re: Bulkdelete and Vacuum operations on custom index Tom Lane
• 14:50   Re: stopping processes, preventing connections Tom Lane
• 18:17   Re: stopping processes, preventing connections Greg Smith
• 18:57   building a c function Stuart McGraw
• 19:43   update ... set ... subquery John Smith
• 20:03   Re: building a c function Tom Lane
• 20:06   Re: update ... set ... subquery Szymon Guz
• 20:06   Re: building a c function Carsten Kropf
• 20:20   Re: update ... set ... subquery hubert depesz lubaczewski
• 20:40   Re: update ... set ... subquery John Smith
• 23:06   Re: update ... set ... subquery Alban Hertroys

18 March 2010

• 12:13   definitions of regexp functions required Ehsan Haq
• 13:19   database connections and presenting data on the web Geoffrey
• 13:26   Re: database connections and presenting data on the web Yeb Havinga
• 13:35   tables getting bloated akp geek
• 13:37   Re: tables getting bloated Devrim GÜNDÜZ
• 13:48   Re: tables getting bloated akp geek
• 14:00   compile a program witn libpq64 (error LIBCMT.Lib...) elekis
• 14:16   Re: compile a program witn libpq64 (error LIBCMT.Lib...) Ashesh Vashi
• 14:38   Re: tables getting bloated Vick Khera
• 15:53   Re: definitions of regexp functions required Albe Laurenz
• 17:03   Re: database connections and presenting data on the web Craig Ringer
• 17:07   Re: tables getting bloated Craig Ringer
• 17:12   Re: definitions of regexp functions required Craig Ringer
• 17:13   Re: database connections and presenting data on the web Geoffrey
• 17:30   accounting package Garry Saddington
• 17:52   Re: accounting package Scott Mead
• 17:53   Re: accounting package Roderick A. Anderson
• 19:21   Who is locking me? Abraham, Danny
• 19:29   Re: Who is locking me? Bill Moran
• 19:35    Justin Graf
• 19:37   Re: Who is locking me? Tom Lane
• 19:43   Re: accounting package Ovnicraft
• 19:45   Re: Who is locking me? Tim Bruce - Postgres
• 20:48   Error de postgres con lenguaje C Juan Nunez
• 21:15   Re: database connections and presenting data on the web John R Pierce
• 22:50   Many-to-many problem Raymond O'Donnell
• 23:08   Re: Many-to-many problem Joe Conway
• 23:13   AIX postgresql error Vikram Patil
• 23:14   Re: building a c function Stuart McGraw
• 23:18   Re: Many-to-many problem Grant Allen

19 March 2010

• 07:19   Will multiple CPU cores be used for expensive query Allan Kamau
• 07:22   Re: Will multiple CPU cores be used for expensive query Devrim GÜNDÜZ
• 07:49   Re: accounting package SUNDAY A. OLUTAYO
• 09:23   Re: compile a program witn libpq64 (error LIBCMT.Lib...) elekis
• 13:17   Re: AIX postgresql error Albe Laurenz
• 13:41   Creating a view: ERROR: rules on SELECT must have action INSTEAD SELECT David Waddy
• 15:00   Order of Daily VACUUM, CLUSTER, REINDEX APseudoUtopia
• 15:05   Re: Order of Daily VACUUM, CLUSTER, REINDEX Grzegorz Jaśkiewicz
• 15:07   Re: Many-to-many problem Raymond O'Donnell
• 15:35   MS Access 2007 update write conflict problem & resolution Little, Douglas
• 16:11   Postgres officially accepted in to 2010 Google Summer of Code program Robert Treat
• 16:18   Re: Order of Daily VACUUM, CLUSTER, REINDEX Leonardo F
• 17:05   Re: Order of Daily VACUUM, CLUSTER, REINDEX Alvaro Herrera
• 17:48   Help me with this tricky join Jay
• 17:48   Re: Help me with this tricky join Jay
• 18:13   Re: MS Access 2007 update write conflict problem & resolution justin@magwerks.com
• 18:58   Re: AIX postgresql error Vikram Patil
• 19:26   Query inside a C-Function Enzo Cappa
• 19:41   Re: Query inside a C-Function Joe Conway
• 20:12   Re: MS Access 2007 update write conflict problem & resolution Richard Broersma
• 20:39   Call for translations Peter Eisentraut
• 20:48   Re: MS Access 2007 update write conflict problem & resolution justin@magwerks.com

20 March 2010

• 00:02   returns 0 row from plpgsql function zhong ming wu
• 04:02   Re: MS Access 2007 update write conflict problem & resolution Craig Ringer
• 05:07   Re: returns 0 row from plpgsql function Pavel Stehule
• 05:58   Locale problem S Arvind
• 07:13   Re: Help me with this tricky join Andreas Kretschmer
• 07:28   How to dump JUST procedures/funnctions? Carlo Stonebanks
• 08:17   Re: How to dump JUST procedures/funnctions? Andreas Kretschmer
• 08:48   Transaction table Deepa Thulasidasan
• 09:26   Re: Transaction table Scott Marlowe
• 13:03   Re: Transaction table Scott Mead
• 17:51   Re: stopping processes, preventing connections Herouth Maoz
• 18:31   Re: stopping processes, preventing connections Scott Marlowe
• 21:58   Re: stopping processes, preventing connections Herouth Maoz
• 22:06   Restrict allowed database names? Adam Seering
• 23:12   Re: stopping processes, preventing connections Scott Marlowe

21 March 2010

• 00:29   Re: Help me with this tricky join Jay
• 00:54   Restrict allowed database names? Adam Seering
• 01:01   Re: Restrict allowed database names? Scott Mead
• 01:26   Re: Restrict allowed database names? Steve Atkins
• 05:26   like operation in tsearch AI Rumman
• 06:11   Re: like operation in tsearch Oleg Bartunov
• 06:28   Re: How to dump JUST procedures/funnctions? Carlo Stonebanks
• 06:54   Wordpress-Mu with postgresql AI Rumman
• 07:36   Re: Wordpress-Mu with postgresql Nilesh Govindarajan
• 07:42   Re: How to dump JUST procedures/funnctions? A. Kretschmer
• 07:46   Re: Help me with this tricky join A. Kretschmer
• 10:48   Re: like operation in tsearch AI Rumman
• 10:57   Re: like operation in tsearch Pavel Stehule
• 11:33   Re: stopping processes, preventing connections Craig Ringer
• 12:05   Hans Samses william wayne
• 12:44   Re: stopping processes, preventing connections Scott Marlowe
• 14:27   Re: Restrict allowed database names? Sergey Konoplev
• 17:43   Re: Restrict allowed database names? Daniel Verite
• 17:56   Re: Restrict allowed database names? Sergey Konoplev
• 18:02   Re: Restrict allowed database names? Tom Lane
• 19:21   Problems with "CREATE CAST" John Shott
• 19:30   Re: Transaction table Vick Khera
• 19:31   Re: Problems with "CREATE CAST" Tom Lane
• 19:58   Re: Transaction table John R Pierce
• 20:21   Re: Problems with "CREATE CAST" John Shott
• 20:29   Re: Transaction table Scott Marlowe
• 20:43   unsubscribe dev mas
• 20:44   Re: Licence Lew
• 21:05   strange Szymon Guz
• 21:20   Full Text Search: howto manage multiple languages ? Cédric MOULLET

22 March 2010

• 01:55   DBT-2 Installation error Megha
• 03:53   Re: strange Tom Lane
• 05:49   How to add an external lib to PG chaoyong wang
• 06:28   Re: How to dump JUST procedures/funnctions? Carlo Stonebanks
• 06:29   Re: Full Text Search: howto manage multiple languages ? Oleg Bartunov
• 07:22   Re: Licence Adrian von Bidder
• 07:24   Re: Restrict allowed database names? Adrian von Bidder
• 07:34   Re: Full Text Search: howto manage multiple languages ? Cédric MOULLET
• 08:51   Re: AIX postgresql error Albe Laurenz
• 11:35   Determining the OID of a certain type Carsten Kropf
• 12:06   Re: How to dump JUST procedures/funnctions? Tom Lane
• 12:18   Re: Determining the OID of a certain type Tom Lane
• 13:09   Re: Daylight savings time confusion Rob Richardson
• 13:33   Holger Kalbas william wayne
• 14:15   Reducing excess files in pg_xlog Thom Brown
• 14:19   Re: Reducing excess files in pg_xlog Tom Lane
• 14:21   Warm Standby Setup Documentation Ogden
• 14:22   Re: Reducing excess files in pg_xlog Thom Brown
• 14:29   Re: Reducing excess files in pg_xlog Tom Lane
• 14:36   Re: Reducing excess files in pg_xlog Thom Brown
• 15:15   Re: Determining the OID of a certain type Carsten Kropf
• 15:17   Re: Daylight savings time confusion Alban Hertroys
• 15:23   Re: Determining the OID of a certain type Tom Lane
• 15:25   Re: pgreplay log file replayer released Greg Stark
• 15:38   Re: Determining the OID of a certain type Carsten Kropf
• 15:45   Re: stopping processes, preventing connections Dimitri Fontaine
• 16:06   Re: Reducing excess files in pg_xlog Greg Smith
• 16:08   user variables in session Igor Shevchenko
• 16:11   Re: user variables in session Merlin Moncure
• 16:15   Re: strange Greg Smith
• 16:24   Avoiding deadlocks on mass delete / update Роман Маширов
• 16:37   Re: strange Tom Lane
• 16:37   Re: Reducing excess files in pg_xlog Thom Brown
• 16:47   Re: Reducing excess files in pg_xlog Tom Lane
• 16:59   Create a function that updates the record with and timestamps Chris Barnes
• 17:06   Re: strange Szymon Guz
• 17:14   Re: Create a function that updates the record with and timestamps A. Kretschmer
• 17:39   Postgresql error from interface Bob Pawley
• 17:46   Re: Postgresql error from interface Tom Lane
• 17:55   Re: Create a function that updates the record with and timestamps Chris Barnes
• 19:49   Re: pgreplay log file replayer released Dimitri Fontaine
• 20:04   server-side extension in c++ Igor
• 23:57   Re: How to dump JUST procedures/funnctions? Tony Wasson

23 March 2010

• 00:33   Re: Create a function that updates the record with and timestamps Adrian Klaver
• 01:21   string functions and operators Neil Stlyz
• 03:49   Re: string functions and operators John R Pierce
• 04:12   Replace null values Nilesh Govindarajan
• 04:37   Re: Replace null values John R Pierce
• 04:39   Re: Replace null values Nilesh Govindarajan
• 04:45   Re: Replace null values Nilesh Govindarajan
• 05:56   Re: Create a function that updates the record with and timestamps A. Kretschmer
• 06:17   Re: Replace null values John R Pierce
• 06:42   Re: Replace null values Nilesh Govindarajan
• 06:54   Re: Replace null values Nilesh Govindarajan
• 06:58   Re: Replace null values Ian Haywood
• 08:19   Re: pgreplay log file replayer released Albe Laurenz
• 08:24   Before triggers and usage in partitioned tables Sergio Ramazzina
• 09:43   Re: db error messages when I try to debug with pgadmin josep porres
• 09:59   PL/pgSQL & OVERLAPS operator Tuo Pe
• 10:18   Re: PL/pgSQL & OVERLAPS operator A. Kretschmer
• 11:14   Re: pgreplay log file replayer released Dimitri Fontaine
• 11:38   Re: Creating a view: ERROR: rules on SELECT must have action INSTEAD SELECT Filip Rembiałkowski
• 11:48   Re: strange Filip Rembiałkowski
• 12:12   Re: strange Grzegorz Jaśkiewicz
• 12:13   Re: Before triggers and usage in partitioned tables Scott Mead
• 12:34   Re: Before triggers and usage in partitioned tables Sergio Ramazzina
• 13:21   Re: pgreplay log file replayer released Albe Laurenz
• 13:25   Re: Before triggers and usage in partitioned tables Albe Laurenz
• 13:30   Re: PL/pgSQL & OVERLAPS operator Tuo Pe
• 13:57   Help me with this multi-table query Nilesh Govindarajan
• 14:27   Fwd: Before triggers and usage in partitioned tables Sergio Ramazzina
• 15:05   2nd set of PostgreSQL 9.0 Alpha4 RPMs are available Devrim GÜNDÜZ
• 15:33   Re: PL/pgSQL & OVERLAPS operator Tom Lane
• 15:49   Re: strange Tom Lane
• 16:26   [SPAM] Re: pgreplay log file replayer released Ben Chobot
• 16:41   Re: Fwd: Before triggers and usage in partitioned tables Tom Lane
• 19:20   Re: Help me with this multi-table query Dean Rasheed

24 March 2010

• 04:14   Re: server-side extension in c++ Craig Ringer
• 04:31   Re: Avoiding deadlocks on mass delete / update Craig Ringer
• 05:18   Re: Help me with this multi-table query Nilesh Govindarajan
• 07:45   Re: Help me with this multi-table query Dean Rasheed
• 09:10   Re: PL/pgSQL & OVERLAPS operator (SOLVED!) Tuo Pe
• 10:22   Concatenate Frank jansen
• 11:58   Re: Help me with this multi-table query Nilesh Govindarajan
• 12:25   Out of Memory during Insert yue peng
• 13:09   Re: Out of Memory during Insert Thom Brown
• 13:27   Re: Concatenate Albe Laurenz
• 13:41   Re: Concatenate Merlin Moncure
• 14:18   Re: Concatenate [solved] Frank jansen
• 14:30   Re: Out of Memory during Insert Tom Lane
• 15:09   Re: Warm Standby Setup Documentation Bryan Murphy
• 15:12   Revoking CREATE TABLE Tony Webb
• 15:24   Re: Revoking CREATE TABLE Tom Lane
• 15:52   Clipping values Ovid
• 16:28   Re: Revoking CREATE TABLE Tony Webb
• 16:31   Fw: Clipping values Ovid
• 16:37   Re: Revoking CREATE TABLE Tom Lane
• 16:40   Re: Fw: Clipping values Tom Lane
• 17:13   Re: Revoking CREATE TABLE Tony Webb
• 17:32   question (or feature-request): over ( partition by ... order by LIMIT N) A. Kretschmer
• 18:54   Re: Fw: Clipping values Ovid
• 20:21   Large index operation crashes postgres Frans Hals
• 20:27   Re: Large index operation crashes postgres Tom Lane
• 20:46   Re: Large index operation crashes postgres Paul Ramsey
• 21:21   find a string contained in an attribute Karina Guardado
• 21:25   Re: find a string contained in an attribute Szymon Guz
• 21:28   Re: find a string contained in an attribute Karina Guardado
• 21:48   data type to store a lot of text and tables of data Karina Guardado
• 21:52   Re: data type to store a lot of text and tables of data Szymon Guz
• 21:55   Re: data type to store a lot of text and tables of data Raymond O'Donnell
• 22:02   Re: data type to store a lot of text and tables of data Karina Guardado
• 22:04   Re: data type to store a lot of text and tables of data Raymond O'Donnell
• 22:09   Re: data type to store a lot of text and tables of data Raymond O'Donnell
• 22:29   Re: How to dump JUST procedures/funnctions? Carlo Stonebanks
• 22:39   Re: data type to store a lot of text and tables of data Karina Guardado
• 22:44   Re: data type to store a lot of text and tables of data Raymond O'Donnell

25 March 2010

• 01:12   boualem guechtouli william wayne
• 04:22   "\d pg_class" fails in PG 8.4 Tadipathri Raghu
• 04:27   How to retrive List of Tables in a Database using... Yogi Yang 007
• 04:33   Re: "\d pg_class" fails in PG 8.4 Tom Lane
• 04:35   Re: How to retrive List of Tables in a Database using... Tadipathri Raghu
• 04:37   Re: "\d pg_class" fails in PG 8.4 Tadipathri Raghu
• 05:26   Re: How to retrive List of Tables in a Database using... John R Pierce
• 06:16   Re: How to retrive List of Tables in a Database using... Scott Mead
• 06:30   Re: How to retrive List of Tables in a Database using... John R Pierce
• 06:36   Re: Large index operation crashes postgres Frans Hals
• 07:34   Re: find a string contained in an attribute Pavel Stehule
• 07:50   Side effect of synchronous_commit = off Yan Cheng CHEOK
• 07:57   Re: Revoking CREATE TABLE Adrian von Bidder
• 08:07   Re: Side effect of synchronous_commit = off Guillaume Lelarge
• 09:07   Get the list of permissions/privileges on schema dipti shah
• 09:15   Re: Get the list of permissions/privileges on schema Ashesh Vashi
• 09:25   Re: Get the list of permissions/privileges on schema Sergey Konoplev
• 09:30   Re: Get the list of permissions/privileges on schema Ashesh Vashi
• 09:39   Re: Get the list of permissions/privileges on schema dipti shah
• 10:26   What datatype should I use to store an IP Address? Andre Lopes
• 10:29   Re: What datatype should I use to store an IP Address? Michał Pawlikowski
• 11:22   Re: What datatype should I use to store an IP Address? Devrim GÜNDÜZ
• 12:02   Achieving ordered update Allan Kamau
• 12:53   Re: Achieving ordered update Thom Brown
• 13:21   pgfoundry registration Krzysztof Nienartowicz
• 13:30   How many Mandatory Process are there in Postgres Tadipathri Raghu
• 13:58   Re: How many Mandatory Process are there in Postgres tv@fuzzy.cz
• 14:30   Re: data type to store a lot of text and tables of data Karina Guardado
• 14:39   Re: find a string contained in an attribute Karina Guardado
• 15:04   Re: find a string contained in an attribute Pavel Stehule
• 15:11   Re: How many Mandatory Process are there in Postgres Tadipathri Raghu
• 15:36   Re: How many Mandatory Process are there in Postgres tv@fuzzy.cz
• 17:09   Re: tables getting bloated akp geek
• 17:19   Re: How many Mandatory Process are there in Postgres Scott Mead
• 18:42   Does anyone use in ram postgres database? Chris Barnes
• 20:02   Re: Large index operation crashes postgres Frans Hals
• 20:05   Re: Does anyone use in ram postgres database? Merlin Moncure
• 20:15   Re: Does anyone use in ram postgres database? Scott Marlowe
• 20:31   Re: Large index operation crashes postgres Frans Hals
• 21:18   Performing FETCH ALL from a SCROLL CURSOR failing to return results Eliot Gable
• 21:44   Re: Performing FETCH ALL from a SCROLL CURSOR failing to return results Tom Lane
• 22:23   Re: Get the list of permissions/privileges on schema John R Pierce

26 March 2010

• 02:04   Geoffrey Gowey wants to stay in touch on LinkedIn Geoffrey Gowey
• 02:41   Problem with Memory Leak Pete Kay
• 02:55   Re: Problem with Memory Leak Tom Lane
• 03:04   Re: How many Mandatory Process are there in Postgres Tadipathri Raghu
• 03:52   Re: How many Mandatory Process are there in Postgres Scott Marlowe
• 03:56   Re: Problem with Memory Leak Pete Kay
• 04:42   Re: How to retrieve List of Tables in a Database using... Yogi Yang 007
• 06:38   Re: Problem with Memory Leak Tom Lane
• 10:17   Re: Avoiding deadlocks on mass delete / update Роман Маширов
• 10:29   Invitation to connect on LinkedIn Paresh Masani
• 11:07   Re: Large index operation crashes postgres Frans Hals
• 13:52   How to write Rules on a View to allow all actions as in the physical table? Andre Lopes
• 14:02   Re: Does anyone use in ram postgres database? Alan McKay
• 14:04   Need help on updating an entire column with a list of values, I have. Rajan, Pavithra
• 14:09   Re: Does anyone use in ram postgres database? Alan McKay
• 14:14   Re: Does anyone use in ram postgres database? Ozz Nixon
• 14:15   Re: Need help on updating an entire column with a list of values, I have. Szymon Guz
• 14:18   Re: Need help on updating an entire column with a list of values, I have. Rajan, Pavithra
• 14:18   Re: Need help on updating an entire column with a list of values, I have. Timo Klecker
• 14:24   Re: Need help on updating an entire column with a list of values, I have. Thom Brown
• 14:24   Re: Does anyone use in ram postgres database? Alan McKay
• 14:25   Re: Need help on updating an entire column with a list of values, I have. Grzegorz Jaśkiewicz
• 14:26   Re: Does anyone use in ram postgres database? Gordan Bobic
• 14:28   Re: Need help on updating an entire column with a list of values, I have. Timo Klecker
• 14:36   Solid State Drives with PG (was: in RAM DB) Alan McKay
• 14:37   Re: Need help on updating an entire column with a list of values, I have. Szymon Guz
• 14:38   Using readline for frequently used queries Tim Landscheidt
• 14:40   Re: Need help on updating an entire column with a list of values, I have. Grzegorz Jaśkiewicz
• 14:51   Re: Need help on updating an entire column with a list of values, I have. Timo Klecker
• 14:56   Re: Need help on updating an entire column with a list of values, I have. Rajan, Pavithra
• 15:12   Re: Does anyone use in ram postgres database? John Gage
• 15:30   Error 42501 permission denied for schema akp geek
• 15:41   Re: Does anyone use in ram postgres database? Merlin Moncure
• 15:44   Re: Does anyone use in ram postgres database? Ozz Nixon
• 15:46   Re: Error 42501 permission denied for schema Tom Lane
• 15:59   Re: Error 42501 permission denied for schema akp geek
• 16:05   Re: Large index operation crashes postgres Tom Lane
• 16:25   Re: Large index operation crashes postgres Paul Ramsey
• 16:28   Re: Does anyone use in ram postgres database? John Gage
• 16:34   Re: Need help on updating an entire column with a list of values, I have. Rajan, Pavithra
• 16:48   Re: Solid State Drives with PG (was: in RAM DB) Merlin Moncure
• 17:03   round(x) function Gaietti, Mauro \(SELEX GALILEO Guest, Italy\)
• 17:12   Re: round(x) function Tom Lane
• 17:40   Re: Does anyone use in ram postgres database? John R Pierce
• 17:44   Re: round(x) function Justin Graf
• 17:52   Re: Does anyone use in ram postgres database? Chris Barnes
• 18:19   Re: Error 42501 permission denied for schema Tom Lane
• 18:26   Moving data directory from one server to another Ehsan Haq
• 18:32   Re: Warm Standby Setup Documentation Greg Smith
• 18:33   Re: Solid State Drives with PG Greg Smith
• 18:35   Re: Warm Standby Setup Documentation Ogden
• 19:26   Storing data on a regular lat/lon grid Mike Charles
• 19:28   Re: Solid State Drives with PG Merlin Moncure
• 19:32   Re: Storing data on a regular lat/lon grid Merlin Moncure
• 19:43   Re: Solid State Drives with PG Brad Nicholson
• 19:50   Re: Solid State Drives with PG Merlin Moncure
• 20:06   R: round(x) function Gaietti, Mauro \(SELEX GALILEO Guest, Italy\)
• 20:34   Re: R: round(x) function Tom Lane
• 20:38   Re: Warm Standby Setup Documentation Bryan Murphy
• 21:23   Connection Pooling David Kerr
• 23:17   Re: Large index operation crashes postgres Frans Hals
• 23:43   Re: Large index operation crashes postgres Frans Hals

27 March 2010

• 06:34   Re: Connection Pooling Allan Kamau
• 07:46   Re: Connection Pooling John R Pierce
• 10:04   Re: Get the list of permissions/privileges on schema dipti shah
• 11:17   How can I import a perl module into a plperl function ? Grillo Grillo
• 14:00   Re: How can I import a perl module into a plperl function ? hubert depesz lubaczewski
• 20:16   Re: Large index operation crashes postgres Frans Hals
• 20:27   Re: Large index operation crashes postgres Frans Hals

28 March 2010

• 06:09   simultaneously reducing both memory usage and runtime for a query Faheem Mitha
• 07:14   Re: How many Mandatory Process are there in Postgres Tadipathri Raghu
• 08:09   Why index occupy less amount of space than the table with same structure. Tadipathri Raghu
• 09:54   Designing Postgres Security Model dipti shah
• 11:22   Re: Why index occupy less amount of space than the table with same structure. Alban Hertroys
• 16:22   Re: simultaneously reducing both memory usage and runtime for a query Tom Lane
• 17:30   Re: How many Mandatory Process are there in Postgres Scott Marlowe
• 17:53   Splitting text column to multiple rows Andrus
• 17:53   How to perform text merge Andrus
• 18:04   Re: Splitting text column to multiple rows Pavel Stehule
• 18:25   Re: How to perform text merge Alban Hertroys
• 18:27   How to generate a valid postgre TIMESTAMP with PHP? Andre Lopes
• 18:39   optimizing import of large CSV file into partitioned table? Rick Casey
• 19:02   Re: How to generate a valid postgre TIMESTAMP with PHP? Scott Marlowe
• 20:09   Re: optimizing import of large CSV file into partitioned table? Thom Brown
• 20:22   Re: simultaneously reducing both memory usage and runtime for a query Faheem Mitha
• 20:53   Re: How to perform text merge Andrus
• 20:53   Re: Splitting text column to multiple rows Andrus
• 21:36   Re: Achieving ordered update Bopolissimus Platypus Jr
• 21:46   Re: How many Mandatory Process are there in Postgres Guillaume Lelarge
• 22:11   Re: How to generate a valid postgre TIMESTAMP with PHP? APseudoUtopia
• 22:27   Re: Connection Pooling David Kerr
• 22:57   hstore equality-index performance question Stefan Keller
• 23:37   Re: optimizing import of large CSV file into partitioned table? Filip Rembiałkowski

29 March 2010

• 00:05   Re: Using readline for frequently used queries Tim Landscheidt
• 00:27   Re: warm standby possible with 8.1? Yar Tykhiy
• 00:44   Re: simultaneously reducing both memory usage and runtime for a query Andy Colson
• 00:48   Re: Warm Standby Setup Documentation Yar Tykhiy
• 01:17   Re: optimizing import of large CSV file into partitioned table? Nagy Zoltan
• 01:59   Re: simultaneously reducing both memory usage and runtime for a query Andy Colson
• 04:03   Re: Why index occupy less amount of space than the table with same structure. Tadipathri Raghu
• 04:05   Re: Moving data directory from one server to another Ehsan Haq
• 04:13   Re: Splitting text column to multiple rows Pavel Stehule
• 04:51   Simultaneous write requests Vitali Xevet
• 04:58   Re: Warm Standby Setup Documentation Greg Smith
• 05:11   Re: Warm Standby Setup Documentation Greg Smith
• 05:15   Re: Simultaneous write requests Greg Smith
• 06:29   Re: simultaneously reducing both memory usage and runtime for a query Faheem Mitha
• 06:55   Re: simultaneously reducing both memory usage and runtime for a query Faheem Mitha
• 07:35   Re: Connection Pooling Wappler, Robert
• 07:39   Re: Large index operation crashes postgres Frans Hals
• 08:15   Re: Why index occupy less amount of space than the table with same structure. Alban Hertroys
• 08:23   looking for a powerful frontend/teport generator Clemens Eisserer
• 08:44   need a query AI Rumman
• 09:26   Re: need a query Florent THOMAS
• 09:30   Re: need a query Timo Klecker
• 10:06   Re: need a query Ognjen Blagojevic
• 10:49   one null value in array isnt allowed??? Armand Turpel
• 10:58   Re: one null value in array isnt allowed??? Wappler, Robert
• 11:28   Re: hstore equality-index performance question Sergey Konoplev
• 12:35   Re: Splitting text column to multiple rows Andrus
• 12:39   How to give security to pg_catalogs raghavendra t
• 12:43   Re: Splitting text column to multiple rows Pavel Stehule
• 13:27   best practice in archiving CDR data Juan Backson
• 13:33   Re: best practice in archiving CDR data A. Kretschmer
• 14:18   Re: best practice in archiving CDR data Juan Backson
• 14:19   Re: [pgsql-general] looking for a powerful frontend/teport generator Oliver Kohll - Mailing Lists
• 14:27   Re: Splitting text column to multiple rows Andrus
• 14:36   Re: Splitting text column to multiple rows Pavel Stehule
• 14:48   Re: optimizing import of large CSV file into partitioned table? Dimitri Fontaine
• 14:52   insert into test_b (select * from test_a) with different column order Ole Tange
• 14:53   Re: How to give security to pg_catalogs Tom Lane
• 15:00   Re: Splitting text column to multiple rows Tom Lane
• 15:03   Re: Splitting text column to multiple rows Andrus
• 15:08   Re: Splitting text column to multiple rows Andrus
• 15:10   Re: insert into test_b (select * from test_a) with different column order Leif Biberg Kristensen
• 15:13   Re: Splitting text column to multiple rows Andrus
• 15:20   Re: Splitting text column to multiple rows Pavel Stehule
• 15:20   Re: Splitting text column to multiple rows Tom Lane
• 15:20   Re: Splitting text column to multiple rows Pavel Stehule
• 15:20   Re: Splitting text column to multiple rows Pavel Stehule
• 15:24   Re: best practice in archiving CDR data Edgardo Portal
• 15:24   Re: optimizing import of large CSV file into partitioned table? Rick Casey
• 15:32   Re: Splitting text column to multiple rows Tom Lane
• 15:33   How long will the query take John Gage
• 15:48   help 赤松 建司
• 15:48   Re: ***SPAM*** Re: Splitting text column to multiple rows Andrus
• 15:51   Dblink vs calling a function that returns void Boszormenyi Zoltan
• 15:53    赤松 建司
• 15:53   Re: ***SPAM*** Re: Splitting text column to multiple rows Pavel Stehule
• 16:07   Re: best practice in archiving CDR data David Fetter
• 16:08   Re: Splitting text column tomultiple rows Andrus
• 16:09   Re: How long will the query take A. Kretschmer
• 16:13   Re: How long will the query take Bill Moran
• 16:13   Re: help Raymond O'Donnell
• 16:14   Re: Dblink vs calling a function that returns void Tom Lane
• 16:15   Re: Splitting text column tomultiple rows Pavel Stehule
• 16:25   Re: How long will the query take Andreas Kretschmer
• 16:37   How to implement word wrap Andrus
• 16:42   Re: Warm Standby Setup Documentation Ogden
• 16:42   Processor speed relative to postgres transactions per second Chris Barnes
• 16:44   Re: How to implement word wrap Thom Brown
• 16:44   Re: How to implement word wrap Andreas Kretschmer
• 16:50   Re: How to implement word wrap Thom Brown
• 17:00   Re: Processor speed relative to postgres transactions per second Steve Atkins
• 17:11   Re: How long will the query take Bill Moran
• 17:17   Re: Large index operation crashes postgres Frans Hals
• 17:36   Re: How to perform text merge Harald Fuchs
• 17:38   PostgreSQL on Windows Mark Vantzelfde
• 17:50   Re: Processor speed relative to postgres transactions per second Scott Marlowe
• 17:52   Re: PostgreSQL on Windows Raymond O'Donnell
• 17:54   Re: How to give security to pg_catalogs raghavendra t
• 17:56   Re: PostgreSQL on Windows Mark Vantzelfde
• 18:14   Re: How long will the query take John Gage
• 18:20   Re: Processor speed relative to postgres transactions per second Greg Smith
• 18:42   Re: playr (or similar tool)? Greg Smith
• 18:46   Re: Side effect of synchronous_commit = off Arthur Turrini
• 20:27   COPY ERROR paulo matadr
• 21:11   Re: hstore equality-index performance question Stefan Keller
• 21:46   Re: hstore equality-index performance question Sergey Konoplev
• 23:32   Floating point exception in initdb Vikram Patil
• 23:45   Re: Floating point exception in initdb Tom Lane

30 March 2010

• 00:03   Re: Floating point exception in initdb Vikram Patil
• 00:29   Re: Floating point exception in initdb Tom Lane
• 01:35   Re: Floating point exception in initdb Vikram Patil
• 02:57   set statement_timeout does not work Jun Wang
• 04:50   Re: simultaneously reducing both memory usage and runtime for a query Faheem Mitha
• 07:04   Re: COPY ERROR Albe Laurenz
• 09:32   Re: How to implement word wrap Andrus
• 09:40   Re: Get the list of permissions/privileges on schema dipti shah
• 10:28   Re: insert into test_b (select * from test_a) with different column order Ole Tange
• 10:28   Re: How to implement word wrap Alban Hertroys
• 10:34   Emphasizing "current item" in subclass of QAbstractItemView Davor J.
• 10:42   Re: insert into test_b (select * from test_a) with different column order Szymon Guz
• 11:06   Get the list of permissions on schema for current user dipti shah
• 11:07   Running/cumulative count using windows Oliver Kohll - Mailing Lists
• 11:26   Re: Running/cumulative count using windows A. Kretschmer
• 12:22   different behaviour between select and delete when constraint_exclusion = partition Marc Cousin
• 13:59   createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres" moataz Elmasry
• 14:13   createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres" moataz Elmasry
• 14:22   Re: Processor speed relative to postgres transactions per second Merlin Moncure
• 14:34   Re: different behaviour between select and delete when constraint_exclusion = partition Tom Lane
• 14:48   Re: createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres" Andy Colson
• 15:03   User action accounting Joshua Berry
• 15:27   Re: hstore equality-index performance question Stefan Keller
• 15:44   Re: hstore equality-index performance question Tom Lane
• 15:46   Re: User action accounting Andy Colson
• 15:48   Re: createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres" moataz Elmasry
• 15:49   Re: createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres" moataz Elmasry
• 16:13   Re: User action accounting Joshua Berry
• 17:12   Re: Dblink vs calling a function that returns void Merlin Moncure
• 17:15   Converting time interval to double precision of time unit Mike Toews
• 17:17   Re: User action accounting Andy Colson
• 17:20   Re: Dblink vs calling a function that returns void Tom Lane
• 17:24   Re: User action accounting Steve Atkins
• 17:36   Re: set statement_timeout does not work Jun Wang
• 17:37   Re: Converting time interval to double precision of time unit Alban Hertroys
• 17:44   Re: set statement_timeout does not work Scott Marlowe
• 17:53   Wiki Updates - 9.0 Tyler Hains
• 18:10   Re: Wiki Updates - 9.0 Raymond O'Donnell
• 18:25   Re: Wiki Updates - 9.0 Greg Smith
• 18:55   Re: Converting time interval to double precision of time unit Tom Lane
• 19:36   Re: Converting time interval to double precision of time unit Mike Toews
• 19:58   Running Windows on a Mac partition John Gage
• 21:46   Re: Running Windows on a Mac partition Scott Marlowe
• 22:20   Re: Running Windows on a Mac partition Joshua Berry
• 22:35   Re: Running Windows on a Mac partition Scott Marlowe
• 23:23   Migration - not null default '0' -> not null default 0 - confused Wang, Mary Y
• 23:32   Re: Migration - not null default '0' -> not null default 0 - confused Adrian Klaver
• 23:50   Re: Migration - not null default '0' -> not null default 0 - confused Wang, Mary Y
• 23:56   Re: Migration - not null default '0' -> not null default 0 - confused Adrian Klaver

31 March 2010

• 00:01   Re: pgfoundry registration Jeff Davis
• 00:05   Re: Migration - not null default '0' -> not null default 0 - confused Jeff Davis
• 00:21   Re: Migration - not null default '0' -> not null default 0 - confused Steve Atkins
• 01:03   Re: Migration - not null default '0' -> not null default 0 - confused Adrian Klaver
• 02:09   plPgSQL + CDIR/INET types ... Marc G. Fournier
• 02:21   Re: plPgSQL + CDIR/INET types ... Steve Atkins
• 02:54   Unsubscribe Wojtek
• 05:13   Re: User action accounting Craig Ringer
• 05:18   Re: Running Windows on a Mac partition John Gage
• 05:20   Re: Running Windows on a Mac partition Craig Ringer
• 05:34   Re: Running Windows on a Mac partition John Gage
• 05:36   Re: Running Windows on a Mac partition John Gage
• 06:15   Connect to postgresql database using Perl dipti shah
• 06:23   Re: Connect to postgresql database using Perl Pavel Stehule
• 07:25   Re: Connect to postgresql database using Perl dipti shah
• 07:35   Force PostgreSQL to query a custom index structure Carsten Kropf
• 07:44   Re: Connect to postgresql database using Perl John R Pierce
• 07:54   Re: Connect to postgresql database using Perl dipti shah
• 08:30   Re: User action accounting Guillaume Lelarge
• 10:40   Re: [NOVICE] Connect to postgresql database using Perl Sean Davis
• 11:59   Re: plPgSQL + CDIR/INET types ... Harald Fuchs
• 14:03   Res: COPY ERROR paulo matadr
• 14:04   Enc: Res: COPY ERROR paulo matadr
• 14:12   Re: Migration - not null default '0' -> not null default 0 - confused Tom Lane
• 14:21   Re: Force PostgreSQL to query a custom index structure Tom Lane
• 14:27   Re: Migration - not null default '0' -> not null default 0 - confused Raymond O'Donnell
• 14:28   Re: Running Windows on a Mac partition Joshua Berry
• 14:41   Re: Running Windows on a Mac partition Craig Ringer
• 14:44   Re: Res: COPY ERROR Albe Laurenz
• 14:59   using gist index with dual-temporal timestamp values Anssi Kääriäinen
• 15:34   Re: using gist index with dual-temporal timestamp values Andreas Kretschmer
• 15:39   prevent connection using pgpass.conf Christophe Dore
• 16:26   Re: prevent connection using pgpass.conf Joshua D. Drake
• 16:59   Re: prevent connection using pgpass.conf Raymond O'Donnell
• 17:04   Windows build missing tcl "UNKNOWN" support Carlo Stonebanks
• 18:46   Running vacuum after delete does not remove all space allocated Chris Barnes
• 19:26   Select in temporary table Sylvain Lara
• 19:33   Re: simultaneously reducing both memory usage and runtime for a query Bruce Momjian
• 19:34   Re: Select in temporary table Bill Moran
• 19:47   Re: Running vacuum after delete does not remove all space allocated Scott Marlowe
• 20:22   Re : Select in temporary table Sylvain Lara
• 21:33   Re: Windows build missing tcl "UNKNOWN" support Tom Lane
• 23:04   Re: Windows build missing tcl "UNKNOWN" support Carlo Stonebanks
• 23:05   REINDEX Question raghavendra t
• 23:26   Re: prevent connection using pgpass.conf Joshua D. Drake