Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-general - March 2007

2007-03-01

• Why does "group by" need to match select fields? Omar Eljumaily (00:19)
• Re: why can't I increase shared buffers to higher value? Bill Moran (00:24)
• Re: Select retrieval slowdown after db drop/reload. Suggestions? Naz Gassiep (00:38)
• PG periodic Error on W2K Paul Lambert (00:44)
• Re: Why does "group by" need to match select fields? Bill Moran (00:47)
• Re: PG periodic Error on W2K Joshua D. Drake (00:52)
• Re: Why does "group by" need to match select fields? Omar Eljumaily (00:57)
• Re: PG periodic Error on W2K Paul Lambert (01:06)
• Re: Esay question, about the numeric format Bruno Wolff III (01:19)
• Assistance with Query Optimisation? Shaun Johnston (01:25)
• Re: [HACKERS] urgent: upgraded to 8.2, getting kernel panics Bruno Wolff III (03:48)
• Re: [HACKERS] urgent: upgraded to 8.2, getting kernel panics Bruno Wolff III (03:53)
• 2d array issues John Gant (05:53)
• Re: PG periodic Error on W2K Magnus Hagander (08:56)
• usage for 'with recursive'? hubert depesz lubaczewski (09:02)
• Please Help ! Error with Access 2003 hengky liwandouw (10:31)
• Re: Please Help ! Error with Access 2003 Magnus Hagander (11:57)
• Re: Assistance with Query Optimisation? Isak Hansen (12:52)
• Re: usage for 'with recursive'? Kenneth Downs (13:13)
• cast bytea to text Willy-Bas Loos (13:15)
• Re: [HACKERS] urgent: upgraded to 8.2, getting kernel panics Merlin Moncure (13:32)
• Re: Please Help ! Error with Access 2003 Bill Moran (13:38)
• Re: cast bytea to text Raymond O'Donnell (13:41)
• Re: [HACKERS] urgent: upgraded to 8.2, getting kernel panics Magnus Hagander (13:50)
• Re: cast bytea to text Peter Eisentraut (14:09)
• Can I getting a unique ID from a select Timasmith (14:16)
• TSearch2: Can't build gendict output Hannes Dorbath (14:59)
• Bug in row locking? Ing. Pavel =?iso-8859-2?Q?Han=E1k?= (14:59)
• Re: TSearch2: Can't build gendict output Hannes Dorbath (15:06)
• Re: Recursive/Wildcard Object Ownership Change Brian A. Seklecki (15:31)
• Re: why can't I increase shared buffers to higher value? Brian A. Seklecki (15:34)
• Re: PG periodic Error on W2K Tom Lane (15:45)
• Re: PG periodic Error on W2K Magnus Hagander (15:51)
• Re: General Ledger db design Merlin Moncure (16:09)
• creating a function with a variable table name George Nychis (16:17)
• Re: supporting 2000 simultaneous connections. Hannes Dorbath (16:18)
• Re: supporting 2000 simultaneous connections. Bill Moran (16:22)
• Re: Can I getting a unique ID from a select Bill Moran (16:24)
• Re: supporting 2000 simultaneous connections. Joshua D. Drake (16:26)
• Re: Why does "group by" need to match select fields? Erik Jones (16:27)
• Re: creating a function with a variable table name Joshua D. Drake (16:27)
• Re: /libexec/ld-elf.so.1: Shared object "libpq.so.4" not found Palle Girgensohn (16:30)
• Re: strange behaviour with sub-select and pl/pgSQL Martijn van Oosterhout (16:30)
• Re: postgres init script reports failure, but postmaster started Tom Lane (16:31)
• Re: supporting 2000 simultaneous connections. Joshua D. Drake (16:34)
• ftell mismatch with expected position Jan Muszynski (16:38)
• Re: Constructors for dates, times, and timestamps Tom Lane (16:38)
• Re: cast bytea to text Albe Laurenz (16:39)
• Re: creating a function with a variable table name A. Kretschmer (16:39)
• Re: Constructors for dates, times, and timestamps Martijn van Oosterhout (16:39)
• get username of user calling function? George Nychis (16:40)
• Re: creating a function with a variable table name George Nychis (16:47)
• Re: Why does "group by" need to match select fields? Martijn van Oosterhout (16:48)
• Re: Why does "group by" need to match select fields? Martijn van Oosterhout (16:49)
• Re: creating a function with a variable table name A. Kretschmer (16:52)
• Re: get username of user calling function? A. Kretschmer (16:54)
• Re: Bug in row locking? Tom Lane (17:05)
• Re: How often do I need to reindex tables? Vivek Khera (17:10)
• Re: get username of user calling function? George Nychis (17:19)
• Re: US Highschool database in postgres Ron Johnson (17:21)
• Re: PG periodic Error on W2K MargaretGillon (17:24)
• Re: get username of user calling function? David Legault (17:30)
• Re: supporting 2000 simultaneous connections. Bill Moran (17:33)
• Re: get username of user calling function? George Nychis (17:35)
• Re: cast bytea to text Willy-Bas Loos (17:42)
• Re: get username of user calling function? David Legault (17:47)
• Re: Josh Berkus (18:49)
• PostgreSQL primary (sequence) key issue (Ruby/Rails) Andrew Madu (19:15)
• Re: PostgreSQL primary (sequence) key issue (Ruby/Rails) Joshua D. Drake (19:23)
• Re: PostgreSQL primary (sequence) key issue (Ruby/Rails) Russ Brown (19:51)
• Connections over SSH tunnels closing after idle time Jerry Sievers (20:03)
• hardware question - LSI MegaRaid 8480e Alan Hodgson (20:12)
• who uses tsearch2 John Smith (20:35)
• Re: Constructors for dates, times, and timestamps Andrew T. Robinson (20:58)
• Re: hardware question - LSI MegaRaid 8480e Merlin Moncure (21:05)
• Re: who uses tsearch2 Magnus Hagander (21:33)
• Re: PG periodic Error on W2K Paul Lambert (21:54)
• Re: strange behaviour with sub-select and pl/pgSQL Tom Lane (22:00)
• is pg_standby over nfs expected to work? Merlin Moncure (22:11)
• Re: Assistance with Query Optimisation? Shaun Johnston (23:37)

2007-03-02

• Re: supporting 2000 simultaneous connections. Mariano Mara (00:09)
• Re: rpm containing pgdump Jorge Godoy (00:28)
• Fun with Cursors- how to rewind a cursor Postgres User (00:29)
• Constraint validation Demian Lessa (00:42)
• Add items to a record variable eddy sanchez (00:54)
• Re: US Highschool database in postgres mobiledreamers (01:04)
• Re: Fun with Cursors- how to rewind a cursor Tom Lane (01:04)
• Re: Constraint validation Tom Lane (01:16)
• Thanks to all Paul Lambert (01:30)
• Re: Thanks to all Terry Fielder (01:42)
• SOLVED: Re: PostgreSQL primary (sequence) key issue (Ruby/Rails) Andrew Madu (03:22)
• Re: Fun with Cursors- how to rewind a cursor Postgres User (03:39)
• Re: Add items to a record variable Postgres User (04:48)
• Re: supporting 2000 simultaneous connections. Shiva Sarna (05:03)
• Re: Add items to a record variable Eddy D. Sanchez (05:12)
• Re: Fun with Cursors- how to rewind a cursor Tom Lane (05:33)
• Re: Fun with Cursors- how to rewind a cursor Postgres User (06:04)
• Re: Add items to a record variable Postgres User (06:20)
• Re: How often do I need to reindex tables? Tom Lane (06:26)
• Re: [GENERAL] Fun with Cursors- how to rewind a cursor Tom Lane (07:06)
• Re: Differences in identical queries Richard Huxton (07:53)
• Re: usage for 'with recursive'? hubert depesz lubaczewski (08:28)
• Re: 8.1.8 Installer Fails on Win2k Server andyk (11:46)
• Re: usage for 'with recursive'? Kenneth Downs (12:32)
• Re: Thanks to all Richard Huxton (14:09)
• Re: How often do I need to reindex tables? Bill Moran (14:25)
• pg_dump, serial Laurent ROCHE (15:01)
• Re: Differences in identical queries Rob Schall (15:02)
• Re: Differences in identical queries Richard Huxton (15:38)
• psql client quits after 1st command Vincenzo Romano (15:56)
• Re: supporting 2000 simultaneous connections. Scott Marlowe (16:00)
• Re: pg_dump, serial Tom Lane (16:03)
• Re: psql client quits after 1st command Douglas McNaught (16:07)
• Re: PostgreSQL primary (sequence) key issue (Ruby/Rails) Scott Ribe (16:12)
• Re: psql client quits after 1st command Vincenzo Romano (16:26)
• Re: Add items to a record variable Martijn van Oosterhout (16:35)
• Re: psql client quits after 1st command Martijn van Oosterhout (16:47)
• Re: Differences in identical queries Richard Huxton (16:51)
• Re: Thanks to all Erik Jones (17:20)
• COPY FROM and multiple null strings Angva (17:26)
• Re : pg_dump, serial Laurent ROCHE (17:54)
• Re: Differences in identical queries Rob Schall (18:11)
• Re: Re : pg_dump, serial Tom Lane (18:18)
• Re: psql client quits after 1st command Tom Lane (18:43)
• WITH/RECURSIVE plans Joshua D. Drake (18:52)
• Re : Re : pg_dump, serial Laurent ROCHE (18:56)
• PG Dump 8.2 Laurent ROCHE (19:00)
• Re: [HACKERS] WITH/RECURSIVE plans David Fetter (19:09)
• Re: Re : Re : pg_dump, serial Tom Lane (19:10)
• How Can I set a non standard date format? clark (19:20)
• Custom session variables? Adam Rich (19:53)
• Re: [HACKERS] WITH/RECURSIVE plans Joshua D. Drake (20:00)
• Large aggregate query running out of memory in ExecutorState Casey Duncan (20:15)
• Re: Custom session variables? Kenneth Downs (20:18)
• Re: How often do I need to reindex tables? Jeff Davis (20:18)
• Re: PG Dump 8.2 Andrej Ricnik-Bay (20:24)
• Re: How Can I set a non standard date format? Andrej Ricnik-Bay (20:36)
• I'd love to know what the rest of this error message is. dlivesay (20:59)
• Re: Custom session variables? David Fetter (21:11)
• Re: I'd love to know what the rest of this error message is. Joshua D. Drake (21:14)
• Re: I'd love to know what the rest of this error message is. Bill Moran (21:19)
• Re: I'd love to know what the rest of this error message is. Raymond O'Donnell (21:19)
• Re: I'd love to know what the rest of this error message is. Bill Moran (21:32)
• Re: I'd love to know what the rest of this error messageis. dlivesay (21:33)
• Re: Large aggregate query running out of memory in ExecutorState Tom Lane (21:34)
• Re: How often do I need to reindex tables? Tom Lane (21:39)
• Re: [HACKERS] WITH/RECURSIVE plans Joshua D. Drake (21:44)
• Re: Custom session variables? Tom Lane (21:45)
• Re: Custom session variables? Adam Rich (21:57)
• Re: I'd love to know what the rest of this error message is. Bill Moran (22:01)
• Re: Why does "group by" need to match select fields? Bruno Wolff III (22:08)
• Re: How often do I need to reindex tables? Jeff Davis (22:27)
• Re: ftell mismatch with expected position Bruce Momjian (22:31)
• Re: Custom session variables? Tom Lane (22:33)
• Re: Thanks to all Bruce Momjian (23:28)
• Support for idempotent schema changes? David Lowe (23:31)

2007-03-03

• Re: I'd love to know what the rest of this error message is. Dave Livesay (00:13)
• Re: I'd love to know what the rest of this error message is. Jan Muszynski (01:47)
• Re: I'd love to know what the rest of this error message is. Dave Livesay (02:20)
• pljava for mac osx 10.4.8 Eddy D. Sanchez (03:31)
• Re: PG Dump 8.2 Mikko Partio (05:47)
• Interface to posgresql makhan (09:02)
• Re: Interface to posgresql Shane Ambler (10:56)
• Re: I'd love to know what the rest of this error message is. Hannes Dorbath (11:37)
• Re: I'd love to know what the rest of this error message is. Magnus Hagander (12:09)
• Re: ftell mismatch with expected position Magnus Hagander (12:12)
• Re: I'd love to know what the rest of this error messagei s. Dave Page (13:17)
• pg temp tables Anton Melser (15:33)
• Re: PG Dump 8.2 Joshua D. Drake (17:10)
• Re: How Can I set a non standard date format? Joshua D. Drake (19:03)
• Re: COPY FROM and multiple null strings Joshua D. Drake (19:12)
• Partition Table Martin Gainty (20:00)
• Re: Partition Table Joshua D. Drake (20:26)
• Re: Partition Table Martin Gainty (21:16)
• Re: How Can I set a non standard date format? Shane Ambler (21:29)

2007-03-04

• Re: Can I getting a unique ID from a select Bruno Wolff III (00:12)
• Re: Can I getting a unique ID from a select Timasmith (00:46)
• Configure can't find com_err on OpenBSD for --with-krb5 Jim Rosenberg (02:20)
• Re: Configure can't find com_err on OpenBSD for --with-krb5 Tom Lane (04:24)
• Re: Configure can't find com_err on OpenBSD for --with-krb5 Jim Rosenberg (05:23)
• Re: Configure can't find com_err on OpenBSD for --with-krb5 Tom Lane (05:40)
• Re: PG Dump 8.2 Mikko Partio (06:39)
• Re: PG Dump 8.2 Joshua D. Drake (07:22)
• Re: Support for idempotent schema changes? Peter Eisentraut (07:44)
• Re: Configure can't find com_err on OpenBSD for --with-krb5 Stefan Kaltenbrunner (08:31)
• Re: Support for idempotent schema changes? Flemming Frandsen (10:35)
• Re: Interface to posgresql Shane Ambler (10:47)
• Re: Can I getting a unique ID from a select Bruno Wolff III (12:44)
• date format Garry Saddington (12:47)
• Re: date format Jorge Godoy (12:58)
• Re: postgresql vs mysql Andreas 'ads' Scherbaum (13:04)
• Re: PG Dump 8.2 Leonel Nunez (13:09)
• Re: postgresql vs mysql Andreas 'ads' Scherbaum (13:39)
• Re: postgresql vs mysql Andreas 'ads' Scherbaum (13:44)
• Re: postgresql vs mysql Andreas 'ads' Scherbaum (13:53)
• xpath and xml namespaces Peter Schonefeld (14:30)
• Re: Configure can't find com_err on OpenBSD for --with-krb5 Jim Rosenberg (14:59)
• issue with select currval Alain Roger (15:20)
• Re: date format Raymond O'Donnell (15:28)
• Re: Support for idempotent schema changes? David Lowe (16:02)