pgsql-general - May 2006

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)

Browse Archives

Prev | Next

May 1, 2006

Thread Author Time
Re: Is PostgreSQL an easy choice for a large CMS? Tony Lausin 00:03
Re: Is PostgreSQL an easy choice for a large CMS? Christopher Browne 01:11
Re: Is PostgreSQL an easy choice for a large CMS? Harvey, Allan AC 01:54
OT: job offer Uwe C. Schroeder 09:13
Re: Nested Query OK in psql but not in PHP Martijn van Oosterhout 09:29
Authentication & connection problems Christo Romberg 11:41
Re: Is PostgreSQL an easy choice for a large CMS? Stephen Frost 12:41
Re: Nested Query OK in psql but not in PHP Reed Loefgren 12:42
Re: Authentication & connection problems chris smith 12:43
Re: How would I write this query... Michael Glaesemann 13:33
Re: Is PostgreSQL an easy choice for a large CMS? A.M. 13:33
shp2pgsql gouse shaik 14:03
Re: Authentication & connection problems chris smith 14:13
Re: Use of ISpell dictionaries with tsearch2 - what is Teodor Sigaev 14:30
charting performance measures with number or records in table SunWuKung 14:46
Re: Socket command type I unknown Joel Richard 15:19
Re: Use of ISpell dictionaries with tsearch2 - what is the point? Don Walker 16:17
Re: How would I write this query... Ragnar 16:22
Re: How to define + operator for strings Andrus 16:25
Re: Is PostgreSQL an easy choice for a large CMS? Tony Lausin 16:41
Re: Is PostgreSQL an easy choice for a large CMS? Scott Marlowe 16:42
Re: How would I write this query... Guy Rouillier 16:51
Re: Is PostgreSQL an easy choice for a large CMS? Philip Hallstrom 17:08
Leading substrings - alternatives with 8.1.3? Wes 17:16
Re: how can i view deleted records? Ian Harding 17:23
Re: Is PostgreSQL an easy choice for a large CMS? Scott Marlowe 17:41
Re: Leading substrings - alternatives with 8.1.3? Martijn van Oosterhout 17:47
Re: file I/O in plpgsql Jessica M Salmon 18:27
Re: Is PostgreSQL an easy choice for a large CMS? Philip Hallstrom 18:37
Re: Is PostgreSQL an easy choice for a large CMS? Scott Marlowe 18:41
Re: Leading substrings - alternatives with 8.1.3? Wes 18:45
Re: Is PostgreSQL an easy choice for a large CMS? Tony Lausin 19:08
Using the REPLACE command to replace all vowels EbGrooveCb 20:16
Re: Leading substrings - alternatives with 8.1.3? Martijn van Oosterhout 21:05
Re: How would I write this query... John D. Burger 21:23
Re: selecting column comment codeWarrior 21:53
Re: For vim users: Syntax highlighting for PostgreSQL brsaweda 22:15
Re: How would I write this query... Guy Rouillier 22:37

May 2, 2006

Thread Author Time
insert into a view? Karen Hill 00:23
Re: insert into a view? Michael Fuhr 00:31
Re: insert into a view? Tom Lane 00:32
How to join to delete Chris Velevitch 06:53
Return value (instead of reference) for user defined type Don Y 07:00
Re: How to join to delete 📎 Noel Faux 07:03
Re: Return value (instead of reference) for user defined type Tom Lane 07:23
Re: PG_RETURN_? Richard Huxton 08:16
Re: How to join to delete Richard Huxton 08:18
Re: How would I write this query... Alban Hertroys 09:09
Re: How would I write this query... Martijn van Oosterhout 09:15
Re: Alternative for vacuuming queue-like tables Csaba Nagy 09:45
Using a pointer as statetype for an aggregate Florian G. Pflug 09:57
Unnecessary function calls Markus Schiltknecht 11:37
Re: Unnecessary function calls Terry Fielder 11:39
Re: Unnecessary function calls Richard Huxton 11:52
Re: Unnecessary function calls Martijn van Oosterhout 12:02
Re: Unnecessary function calls Markus Schiltknecht 12:16
Re: Unnecessary function calls Markus Schiltknecht 12:27
Re: Unnecessary function calls Terry Fielder 12:31
Re: Use of ISpell dictionaries with tsearch2 - what is Oleg Bartunov 12:35
Re: How to join to delete Chris Velevitch 13:00
number of page slots needed exceeds max_fsm_pages David Brain 13:58
Re: How would I write this query... John D. Burger 14:15
Re: Using a pointer as statetype for an aggregate Tom Lane 14:53
convert LO to BYTEA Markus Schiltknecht 15:12
Re: Socket command type I unknown Joel Richard 15:25
Re: PG_RETURN_? Don Y 15:43
Re: PG_RETURN_? Richard Huxton 15:51
Re: PG_RETURN_? Martijn van Oosterhout 16:12
libpq for palm? Ottavio Campana 16:27
Re: PG_RETURN_? Don Y 17:06
Re: Unexpected behavior Steve V 17:11
Re: PG_RETURN_? Martijn van Oosterhout 17:46
Re: Unexpected behavior Martijn van Oosterhout 17:53
Re: Using a pointer as statetype for an aggregate Florian G. Pflug 17:55
Re: PG_RETURN_? Don Y 18:13
Re: Return value (instead of reference) for user defined Don Y 18:14
8.1.4 anytime soon? Matthew T. O'Connor 18:20
Calling V1 function from within the server Don Y 18:24
FATAL: database "dspace" does not exist" Christo Romberg 19:02
Re: Calling V1 function from within the server Martijn van Oosterhout 19:21
age(datfrozenxid) negative for template0. Is this normal? Denis Gasparin 19:48
Re: 8.1.4 anytime soon? Bruno Wolff III 20:17
Re: convert LO to BYTEA Jerry LeVan 20:44
Re: shp2pgsql Michael Fuhr 21:05
Re: For vim users: Syntax highlighting for PostgreSQL Devrim GUNDUZ 21:42
Recovering a row result Luis Alberto PĂ©rez Paz 22:03
Re: age(datfrozenxid) negative for template0. Is this normal? Tom Lane 22:30
Re: Using the REPLACE command to replace all vowels Tony Wasson 23:54
Re: For vim users: Syntax highlighting for PostgreSQL Fernan Aguero 23:58

May 3, 2006

Thread Author Time
Locking confusion David J N Begley 00:02
Re: Locking confusion Tom Lane 01:32
Re: Calling V1 function from within the server Don Y 01:56
Replicating PostgreSQL DB to lightweight system 📎 pgdb 02:31
Re: Replicating PostgreSQL DB to lightweight system Chris 02:58
Re: Replicating PostgreSQL DB to lightweight system David Fetter 04:00
Re: Locking confusion David J N Begley 04:43
Re: Replicating PostgreSQL DB to lightweight system pgdb 05:11
Re: Replicating PostgreSQL DB to lightweight system Leif B. Kristensen 06:25
logfiles filling up Erik Myllymaki 07:02
Re: Using the REPLACE command to replace all vowels Magnus Hagander 07:38
Re: Using the REPLACE command to replace all vowels Wayne Conrad 07:56
database size grows (even after vacuum (full and analyze)).... Joao Miguel Ferreira 11:02
Re: logfiles filling up Erik Myllymaki 13:35
Re: logfiles filling up Magnus Hagander 13:45
Re: logfiles filling up Erik Myllymaki 13:48
psql is slow and it does not take much resources Javier de la Torre 14:00
Re: psql is slow and it does not take much resources Larry Rosenman 14:07
Re: Replicating PostgreSQL DB to lightweight system Vivek Khera 14:09
Re: psql is slow and it does not take much resources Javier de la Torre 14:11
Re: psql is slow and it does not take much resources Larry Rosenman 14:12
Re: psql is slow and it does not take much resources Leif B. Kristensen 14:28
Re: Replicating PostgreSQL DB to lightweight system Adrian Klaver 14:37
Re: psql is slow and it does not take much resources Javier de la Torre 14:43
Re: database size grows (even after vacuum (full and analyze)).... Bruno Wolff III 14:45
Re: psql is slow and it does not take much resources Larry Rosenman 14:46
Re: psql is slow and it does not take much resources Martijn van Oosterhout 15:28
Re: psql is slow and it does not take much resources Javier de la Torre 15:34
The planner chooses seqscan+sort when there is an index on the sort column Csaba Nagy 15:37
Re: The planner chooses seqscan+sort when there is an index on the sort column John D. Burger 15:48
Re: The planner chooses seqscan+sort when there is an index on the sort column Andreas Kretschmer 15:54
Re: The planner chooses seqscan+sort when there is an Csaba Nagy 15:57
Re: The planner chooses seqscan+sort when there is an Csaba Nagy 16:01
Re: logfiles filling up Magnus Hagander 16:05
Re: logfiles filling up Erik Myllymaki 16:16
Re: The planner chooses seqscan+sort when there is an John D. Burger 16:33
Re: The planner chooses seqscan+sort when there is an Csaba Nagy 16:42
Re: The planner chooses seqscan+sort when there is an Martijn van Oosterhout 16:44
Re: out of memory for query result Sven Willenberger 16:53
Re: insert into a view? Karen Hill 17:02
Re: database size grows (even after vacuum (full and analyze)).... Joao Miguel Ferreira 17:15
Re: out of memory for query result Douglas McNaught 17:16
Re: database size grows (even after vacuum (full and analyze)).... Bruno Wolff III 17:29
Re: insert into a view? David Fetter 17:44
Re: database size grows (even after vacuum (full and analyze)).... Joao Miguel Ferreira 17:57
Re: database size grows (even after vacuum (full and analyze)).... Tom Lane 18:12
Re: database size grows (even after vacuum (full and Joao Miguel Ferreira 18:19
Re: The planner chooses seqscan+sort when there is an Florian G. Pflug 18:20
Re: The planner chooses seqscan+sort when there is an Tom Lane 18:34
Re: The planner chooses seqscan+sort when there is an Scott Marlowe 18:36
How does an application recognize the death of the postmaster Geoffrey 18:44
Re: The planner chooses seqscan+sort when there is an A. Kretschmer 18:45
Re: out of memory for query result Sven Willenberger 18:52
Re: How does an application recognize the death of the postmaster Wayne Conrad 18:57
Re: out of memory for query result Larry Rosenman 18:57
Re: How does an application recognize the death of the postmaster Guy Rouillier 19:09
Re: out of memory for query result Martijn van Oosterhout 19:12
Connection error, help..please Christo Romberg 19:14
Re: psql is slow and it does not take much resources Tom Lane 19:17
Re: Connection error, help..please Tom Lane 19:21
Re: logfiles filling up Magnus Hagander 19:36
Re: database size grows (even after vacuum (full and analyze)).... Bruno Wolff III 20:07
Re: How does an application recognize the death of the Guy Fraser 20:28
ERROR: more than one row returned by a subquery used as an expression Arjan Vroege 21:00
Re: psql is slow and it does not take much resources Joe Healy 23:54

May 4, 2006

Thread Author Time
Catch individual exceptions sconeek 02:16
Re: FATAL: database "dspace" does not exist" Michael Artz 03:26
pg_dumpall error carlosreimer 03:51
ISSTRICT behavior Don Y 06:02
Re: ISSTRICT behavior Tom Lane 06:09
RES: pg_dumpall error carlosreimer 06:29
Re: ISSTRICT behavior Martijn van Oosterhout 06:34
Re: ISSTRICT behavior Don Y 06:43
Re: ISSTRICT behavior Don Y 06:45
Re: ISSTRICT behavior Tom Lane 06:48
Re: ISSTRICT behavior Tom Lane 06:55
Re: ISSTRICT behavior Martijn van Oosterhout 07:06
Re: ISSTRICT behavior Don Y 07:19
Re: ISSTRICT behavior Martijn van Oosterhout 07:23
Re: ISSTRICT behavior Don Y 07:23
Re: ISSTRICT behavior Don Y 07:29
Re: ISSTRICT behavior Martijn van Oosterhout 07:29
Re: ISSTRICT behavior Martijn van Oosterhout 07:36
Re: ISSTRICT behavior Don Y 07:43
Re: ISSTRICT behavior Don Y 07:50
Re: ISSTRICT behavior Don Y 07:54
Re: The planner chooses seqscan+sort when there is an Csaba Nagy 08:09
Re: The planner chooses seqscan+sort when there is an Martijn van Oosterhout 08:18
Re: The planner chooses seqscan+sort when there is an Csaba Nagy 08:36
Re: psql is slow and it does not take much resources Alban Hertroys 09:02
Segfaults with 8.1.3 on amd64 Gavin Hamill 11:22
Re: Segfaults with 8.1.3 on amd64 Martijn van Oosterhout 11:34
linker srinivasa.n 12:33
Re: How does an application recognize the death of the Reid Thompson 12:49
Re: linker Martijn van Oosterhout 12:52
Re: linker Magnus Hagander 12:58
ilike and umlaut simon 13:58
Intel Duo Issues Josh Rovero 13:58
Re: FATAL: database "dspace" does not exist" Christo Romberg 14:56
Adding ON UPDATE CASCADE to an existing foreign key constraint Rich Doughty 15:18
Re: Segfaults with 8.1.3 on amd64 Guy Rouillier 15:29
Re: Adding ON UPDATE CASCADE to an existing foreign key Stephan Szabo 16:17
Googles sommer of Code 2005 - Postgres Project Proposal - where to discuss? who is responsible? who can mentor? Sebastian Wagner 17:18
audit table containing Select statements submitted Hogan, James F. Jr. 17:45
Re: [SQL] audit table containing Select statements submitted Ben K. 17:55
Re: Googles sommer of Code 2005 - Postgres Project Proposal - where to discuss? who is responsible? who can mentor? Sebastian Wagner 18:01
Re: Alternative for vacuuming queue-like tables Jim C. Nasby 19:07
Re: dump Functions Jim C. Nasby 19:27
Re: Alternative for vacuuming queue-like tables Tom Lane 19:30
Re: how can i view deleted records? Jim C. Nasby 19:42
Re: Is PostgreSQL an easy choice for a large CMS? Jim C. Nasby 19:50

Browse Archives

Prev | Next