pgsql-general since 2009-10-16 00:00

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Oct. 16, 2009

Thread Author Time
PGCluster vs CyberCluster Yadira Lizama Mue 02:03
Re: could not open process token: error code 5 Andale 05:02
Re: Can't find documentation for ~=~ operator Viktor Rosenfeld 07:23
Wrong estimation of rows for hash join Christian Schröder 08:59
pgsql2shp : Encoding headache Arnaud Lesauvage 09:36
Re: pgsql2shp : Encoding headache Raymond O'Donnell 10:09
Urgent Help required Neha Patel 10:26
Re: [postgis-users] pgsql2shp : Encoding headache InterRob 10:28
Re: pgsql2shp : Encoding headache Arnaud Lesauvage 10:34
savepoint name vs prepared transaction name Grzegorz Jaśkiewicz 10:55
Re: Wrong estimation of rows for hash join Alban Hertroys 12:59
Re: pgsql2shp : Encoding headache Arnaud Lesauvage 13:30
Re: savepoint name vs prepared transaction name Tom Lane 14:38
Re: Wrong estimation of rows for hash join Tom Lane 14:42
Re: savepoint name vs prepared transaction name Grzegorz Jaśkiewicz 14:57
Re: [postgis-users] pgsql2shp : Encoding headache InterRob 15:35
Re: Urgent Help required Grzegorz Jaśkiewicz 16:20
Re: Urgent Help required David Fetter 16:27
Re: Urgent Help required Neha Patel 16:31
Re: Inheritance on foreign key decibel 16:56
Re: Urgent Help required John R Pierce 17:03
Re: contrib/plantuner - enable PostgreSQL planner hints decibel 17:04
db not dumping properly, or at least not restoring Kirk Wythers 17:25
Re: db not dumping properly, or at least not restoring Thom Brown 18:14
slightly off-topic: Central Auth Scot Kreienkamp 18:38
Re: slightly off-topic: Central Auth Scott Mead 18:49
Re: slightly off-topic: Central Auth Scot Kreienkamp 18:56
Partitioned tables as a poor mans columnar index? Peter Hunsberger 19:19
Re: slightly off-topic: Central Auth Raymond O'Donnell 19:38
Re: slightly off-topic: Central Auth Scot Kreienkamp 19:43
Re: contrib/plantuner - enable PostgreSQL planner hints Christophe Pettus 19:51
Re: Partitioned tables as a poor mans columnar index? marcin mank 20:31
Re: [HACKERS] contrib/plantuner - enable PostgreSQL planner hints Jeff Davis 20:35
Re: Urgent Help required Jeff Davis 20:55
Re: Partitioned tables as a poor mans columnar index? Peter Hunsberger 21:01
Re: db not dumping properly, or at least not restoring Scott Marlowe 21:51
Re: slightly off-topic: Central Auth Tom Lane 22:40
Re: slightly off-topic: Central Auth Magnus Hagander 22:49
pgadmin3 hangs during dump Dennis Gearon 23:43

Oct. 17, 2009

Thread Author Time
Re: db not dumping properly, or at least not restoring Kirk Wythers 00:11
Re: contrib/plantuner - enable PostgreSQL planner hints Greg Stark 01:38
Re: Inheritance on foreign key decibel 03:51
Re: Urgent Help required Mike Christensen 05:21
XPath PostgreSQL 8.4 Karl Koster 06:37
10/13 SFPUG meeting, "The Mighty GUCS," video now available Christophe Pettus 06:55
Re: 10/13 SFPUG meeting, "The Mighty GUCS," video now available Gerhard Wiesinger 09:03
Re: 10/13 SFPUG meeting, "The Mighty GUCS," video now available Gerhard Wiesinger 09:05
Re: db not dumping properly, or at least not restoring Scott Marlowe 09:48
Re: slightly off-topic: Central Auth Raymond O'Donnell 10:14
Re: How ad an increasing index to a query result? LaMi 12:58
Problem with using snprintf in C-function Ilya Urikh 14:12
Re: Problem with using snprintf in C-function Pavel Stehule 14:20
Re: pgadmin3 hangs during dump Peter Geoghegan 14:36
Re: Problem with using snprintf in C-function Ilya Urikh 14:40
Re: Problem with using snprintf in C-function Pavel Stehule 15:39
Re: XPath PostgreSQL 8.4 Tim Landscheidt 15:57
Re: XPath PostgreSQL 8.4 Tim Landscheidt 16:02
Re: Problem with using snprintf in C-function Tom Lane 16:46
Re: 10/13 SFPUG meeting, "The Mighty GUCS," video now available Christophe Pettus 22:55

Oct. 18, 2009

Thread Author Time
Delete fails with out of memory yuliada 03:02
Re: Delete fails with out of memory Filip Rembiałkowski 08:15
Re: How ad an increasing index to a query result? Alban Hertroys 10:30
Re: How ad an increasing index to a query result? Thom Brown 10:46
Determining dead/unused space in a table? David Spadea 11:11
Re: Determining dead/unused space in a table? Tom Lane 15:53
Re: How ad an increasing index to a query result? Raymond O'Donnell 16:00
Re: Delete fails with out of memory Simon Riggs 19:13
Function returning 2 columns evaluated twice when both columns are needed Gerhard Wiesinger 20:05
Re: Function returning 2 columns evaluated twice when both columns are needed Tom Lane 21:00
Re: db not dumping properly, or at least not restoring Brent Wood 21:32
Re: 10/13 SFPUG meeting, "The Mighty GUCS," video now available Eric Walstad 21:41

Oct. 19, 2009

Thread Author Time
Catalog help Scott Ribe 00:02
Re: Catalog help Erik Jones 04:22
Re: Catalog help Scott Ribe 04:36
unsubscribe 窦德厚 (ddh) 05:18
Re: Function returning 2 columns evaluated twice when both columns are needed Gerhard Wiesinger 05:39
Re: pgadmin3 hangs during dump Albe Laurenz 07:58
Best practices for effective_io_concurrency Sergey Konoplev 12:20
Re: Function returning 2 columns evaluated twice when both columns are needed Tom Lane 14:09
Un successful Restoration of DATA using WAL files Mitesh51 14:18
Index Question Bierbryer, Andrew 14:33
Re: Index Question Tom Lane 14:54
Re: Best practices for effective_io_concurrency Greg Smith 15:12
autovacuum and immediate shutdown issues Brad Nicholson 15:53
cast numeric with scale and precision to numeric plain Sim Zacks 16:03
Re: autovacuum and immediate shutdown issues Tom Lane 16:07
Re: cast numeric with scale and precision to numeric plain Tom Lane 16:21
Re: autovacuum and immediate shutdown issues Brad Nicholson 16:30
Re: autovacuum and immediate shutdown issues Tom Lane 16:44
Re: autovacuum and immediate shutdown issues Scott Marlowe 16:53
Re: autovacuum and immediate shutdown issues Brad Nicholson 17:06
Re: autovacuum and immediate shutdown issues Scott Marlowe 17:16
Re: autovacuum and immediate shutdown issues Brad Nicholson 17:25
Re: autovacuum and immediate shutdown issues Tom Lane 17:27
Re: Function returning 2 columns evaluated twice when both columns are needed Gerhard Wiesinger 17:49
Re: Function returning 2 columns evaluated twice when both columns are needed Christophe Pettus 18:01
Re: Function returning 2 columns evaluated twice when both columns are needed Tom Lane 18:02
Re: autovacuum and immediate shutdown issues Scott Marlowe 18:26
Re: autovacuum and immediate shutdown issues Christophe Pettus 18:35
Re: autovacuum and immediate shutdown issues Brad Nicholson 18:52
Re: autovacuum and immediate shutdown issues Tom Lane 19:01
Re: autovacuum and immediate shutdown issues Brad Nicholson 19:09
Re: autovacuum and immediate shutdown issues Brad Nicholson 19:14
Free Tool to design Postgres Databases Andre Lopes 19:18
Re: autovacuum and immediate shutdown issues Tom Lane 19:20
Re: Best practices for effective_io_concurrency Sergey Konoplev 20:38
Re: Free Tool to design Postgres Databases Peter Hunsberger 20:52
How to find the row corresponding to a given toast value? David Boreham 20:57
Mac OS Roman import? Christophe Pettus 21:54
Re: Mac OS Roman import? Sam Mason 22:30
Re: Mac OS Roman import? Scott Ribe 22:32
Re: Mac OS Roman import? Tom Lane 22:47
Re: Mac OS Roman import? Scott Ribe 23:39
Re: Mac OS Roman import? Christophe Pettus 23:43

Oct. 20, 2009

Thread Author Time
When much of a DB is large objects - PG 8.4 David Wall 01:11
Re: How ad an increasing index to a query result? Merlin Moncure 01:39
Re: When much of a DB is large objects - PG 8.4 Merlin Moncure 02:21
Re: Free Tool to design Postgres Databases Guy Rouillier 02:48
Re: Un successful Restoration of DATA using WAL files Craig Ringer 03:08
Re: Un successful Restoration of DATA using WAL files Craig Ringer 03:26
About could not connect to server: Connection timed out 黄永卫 04:12
Re: About could not connect to server: Connection timed out Craig Ringer 04:33
Re: About could not connect to server: Connection timed out Johan Nel 04:37
Re: Free Tool to design Postgres Databases David Fetter 04:38
CSV files & empty strings Nate Randall 04:55
Re: 10/13 SFPUG meeting, "The Mighty GUCS," video now available Viktor Rosenfeld 06:02
答复: [GENERAL] About could not connect to server: Connection timed out 黄永卫 07:01
OT - 2 of 4 drives in a Raid10 array failed - Any chance of recovery? Ow Mun Heng 07:11
different execution times of the same query Luca Ferrari 08:34
Re: OT - 2 of 4 drives in a Raid10 array failed - Any chance of recovery? Scott Marlowe 08:41
Re: different execution times of the same query Scott Marlowe 08:44
Re: Free Tool to design Postgres Databases Mirko Sertic 08:50
Re: Free Tool to design Postgres Databases Wolfgang Keller 10:27
Re: Free Tool to design Postgres Databases Grzegorz Jaśkiewicz 10:36
Re: cast numeric with scale and precision to numeric plain 📎 Sim Zacks 10:39
Re: Free Tool to design Postgres Databases Grzegorz Jaśkiewicz 10:44
Re: different execution times of the same query Luca Ferrari 10:51
Re: 答复: [GENERAL] About could not connect to server: Connection timed out Craig Ringer 10:52
Re: OT - 2 of 4 drives in a Raid10 array failed - Any chance of recovery? Craig Ringer 11:02
Re: different execution times of the same query Craig Ringer 11:09
PGDay.EU 2009 - approaching fast! Dave Page 11:14
Re: could not open process token: error code 5 Andale 11:21
Re: could not open process token: error code 5 Andale 11:22
Re: PGDay.EU 2009 - approaching fast! Thom Brown 11:52
Re: Free Tool to design Postgres Databases Martin Gainty 11:56
PostgreSQL driver for Joomla review Thom Brown 12:02
Re: PostgreSQL driver for Joomla review Csaba Nagy 12:52
Re: PostgreSQL driver for Joomla review 📎 Thom Brown 13:00
Re: cast numeric with scale and precision to numeric plain Adrian Klaver 13:24
Re: PostgreSQL driver for Joomla review 📎 Thom Brown 13:28
Re: PostgreSQL driver for Joomla review Merlin Moncure 13:46
multi-company design/structure ? John 13:50
Re: PostgreSQL driver for Joomla review Thom Brown 14:02
Re: CSV files & empty strings Raymond O'Donnell 14:15
Re: [sfpug] 10/13 SFPUG meeting, "The Mighty GUCS," video now available David Fetter 14:18
PANIC : right sibling's left-link doesn't match Ow Mun Heng 14:30
PANIC : right sibling's left-link doesn't match Ow Mun Heng 14:31
Re: cast numeric with scale and precision to numeric plain Tom Lane 14:53
Re: Re: 答复: [GENERAL] About could not connect to server: Connection timed out Tom Lane 14:56
Re: Free Tool to design Postgres Databases David Fetter 14:57
Re: PANIC : right sibling's left-link doesn't match Tom Lane 15:09
Sharedbuffers and WorkMem Waldomiro 15:22
OT: Re: [sfpug] 10/13 SFPUG meeting, "The Mighty GUCS," video now available Viktor Rosenfeld 15:32
Re: Sharedbuffers and WorkMem Grzegorz Jaśkiewicz 15:34
Re: different execution times of the same query Viktor Rosenfeld 15:40
Re: cast numeric with scale and precision to numeric plain Sim Zacks 15:40
Re: When much of a DB is large objects - PG 8.4 David Wall 16:00
Re: Sharedbuffers and WorkMem Greg Smith 16:18
Re: OT: Re: [sfpug] 10/13 SFPUG meeting, "The Mighty GUCS, " video now available Christophe Pettus 16:35
Re: OT: Re: [sfpug] 10/13 SFPUG meeting, "The Mighty GUCS," video now available Gerhard Wiesinger 16:41
Count occurrences of pattern in string [email protected] 17:04
Re: multi-company design/structure ? Wolfgang Keller 17:11
Re: Count occurrences of pattern in string Andreas Kretschmer 17:24
Re: PostgreSQL driver for Joomla review Alban Hertroys 17:29
Re: multi-company design/structure ? John 18:45
Re: multi-company design/structure ? Rich Shepard 18:59
Re: PostgreSQL driver for Joomla review Thom Brown 19:00
Re: cast numeric with scale and precision to numeric plain Scott Marlowe 19:23
Re: cast numeric with scale and precision to numeric plain Adrian Klaver 20:46
Re: Function returning 2 columns evaluated twice when both columns are needed Pavel Stehule 21:12

Oct. 21, 2009

Thread Author Time
Re: Function returning 2 columns evaluated twice when both columns are needed Merlin Moncure 00:12
Re: multi-company design/structure ? John 00:43
Re: Function returning 2 columns evaluated twice when both columns are needed Pavel Stehule 04:37
Re: multi-company design/structure ? Roderick A. Anderson 05:05
How much lines per day? Tatsuo Ishii 05:40
Re: OT - 2 of 4 drives in a Raid10 array failed - Any chance of recovery? Greg Smith 06:10
Re: OT - 2 of 4 drives in a Raid10 array failed - Any chance of recovery? Scott Marlowe 06:25
Re: OT - 2 of 4 drives in a Raid10 array failed - Any chance of recovery? Greg Smith 06:30
Re: [postgis-users] pgsql2shp : Encoding headache Arnaud Lesauvage 06:47
Re: OT - 2 of 4 drives in a Raid10 array failed - Any chance of recovery? Greg Smith 06:59
Re: Free Tool to design Postgres Databases Mike Christensen 07:17
Re: multi-company design/structure ? Ivano Luberti 08:23
How to send multiple parameters to a pl/pgsql function Sgarbossa Domenico 08:34
Re: PostgreSQL driver for Joomla review Csaba Nagy 08:52
PostgreSQL 8.4.1 is supported on RHEL 4 and RHEL 5.2 utsav 09:13
Re: OT - 2 of 4 drives in a Raid10 array failed - Any chance of recovery? Ow Mun Heng 09:14
Re: PostgreSQL driver for Joomla review Thom Brown 09:17
Re: How to send multiple parameters to a pl/pgsql function Pavel Stehule 09:23
Index Scan/Bitmap Index Scan for queries with FTS and ORDER+LIMIT Sergey Konoplev 12:48
How to use Logical Operators in Fulltext Search? Gaini Rajeshwar 13:12

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31