Mailing lists [pgsql-novice]

1 June 2003

• 03:28   Re: Create Table Unique problem... bug? Nabil Sayegh
• 03:31   FOR UPDATE NOWAIT ling
• 03:33   Create Table Unique problem... bug? Mauro Bertoli
• 03:33   UPPER / lower Юрий Морозов
• 08:16   Me again..nOOb alert Herbie McDuck
• 08:36   Re: Me again..nOOb alert Herbie McDuck
• 13:30   Re: Me again..nOOb alert Frank Bax
• 16:11   pl/pgsql noob Don Patou
• 17:39   Re: Me again..nOOb alert Josh Berkus
• 21:09   Postgresql 7.3.2 installation on SuSE Linux 8.2 Professional John

2 June 2003

• 00:44   pg_ctl? Herbie McDuck
• 07:12   Re: pg_ctl? Nabil Sayegh
• 07:47   Calculation error Wil Duis
• 07:52   Re: pg_ctl? Herbie McDuck
• 08:57   Re: nOOB Question.. Dani Oderbolz
• 12:31   Re: nOOB Question.. János Löbb
• 12:59   Re: Calculation error Tom Lane
• 15:04   Re: nOOB Question.. Herbie McDuck
• 16:19   Re: nOOB Question.. Josh Berkus
• 16:24   Re: nOOB Question.. Josh Berkus

4 June 2003

• 22:50   locale support ? root

5 June 2003

• 01:51   Re: locale support ? Tom Lane
• 04:48   Updatable view does not work [oops, quite long!] Thiemo Kellner
• 05:46   Re: Calculation error chestie
• 08:28   7.2 -> 7.3 timespan, interval etc. Nabil Sayegh
• 11:44   Re: 7.2 -> 7.3 timespan, interval etc. Tom Lane
• 12:32   Re: locale support ? root
• 14:20   Re: Updatable view does not work [oops, quite long!] Tom Lane
• 14:52   Re: Calculation error chestie
• 15:35   Re: Calculation error Tom Lane
• 16:52   Re: 7.2 -> 7.3 timespan, interval etc. Nabil Sayegh
• 18:02   Re: Updatable view does not work [oops, quite long!] Manfred Koizar
• 18:40   Re: Updatable view does not work [oops, quite long!] Thiemo Kellner

7 June 2003

• 01:30   IpcMemoryCreate: shmget failed (Permission denied) Theuns
• 01:31   FATAL 1 Wim Vanweersch
• 01:53   locale support Aarni Ruuhimäki
• 02:02   Re: Calculation error Wil Duis
• 08:04   Re: FATAL 1 Jeff Eckermann
• 08:30   Re: IpcMemoryCreate: shmget failed (Permission denied) Jeff Eckermann

8 June 2003

• 00:25   Re: Return Record Rory Campbell-Lange
• 09:34   Question regarding keyword checkboxes in database design Lynna Landstreet
• 11:10   Re: Procedural Postgresql radha.manohar@ndsu.nodak.edu
• 13:41   Re: Procedural Postgresql Jean-Christian Imbeault
• 15:35   Re: Question regarding keyword checkboxes in database design Jean-Christian Imbeault
• 16:09   Re: Updatable view does not work [oops, quite long!] Thiemo Kellner
• 16:31   [bug?] oddity creating table with uppercase initial Paul Makepeace
• 20:48   Strange Encryption Bug Joanne Formoso

9 June 2003

• 05:34   Re: [bug?] oddity creating table with uppercase initial Jeff Eckermann
• 06:44   Re: [bug?] oddity creating table with uppercase initial Bruno Wolff III
• 07:07   Re: [bug?] oddity creating table with uppercase initial Jean-Christian Imbeault
• 07:23   Re: Question regarding keyword checkboxes in database design Bruno Wolff III
• 07:43   Weird Database Encryption Bug Joanne Formoso
• 17:33   Re: FATAL 1 A.Bhuvaneswaran

10 June 2003

• 03:37   Re: IpcMemoryCreate: shmget failed (Permission denied) Jeff Eckermann
• 04:32   Inheritance design question Jean-Christian Imbeault
• 05:35   How to upgrade from 7.3.2 to 7.3.3 Jean-Christian Imbeault
• 08:38   Re: How to upgrade from 7.3.2 to 7.3.3 A.Bhuvaneswaran
• 08:47   Re: How to upgrade from 7.3.2 to 7.3.3 Jean-Christian Imbeault
• 11:55   Re: Question regarding keyword checkboxes in database design Dani Oderbolz
• 12:08   join and where clause equivalent ? Nabil Sayegh
• 14:56   Re: join and where clause equivalent ? Dmitry Tkach
• 16:00   Re: Inheritance design question Josh Berkus
• 16:05   Re: join and where clause equivalent ? Tom Lane

11 June 2003

• 01:02   Converting IBM DB2 TRIGGERs to PostgreSQL Alan Searles
• 05:27   Re: Converting IBM DB2 TRIGGERs to PostgreSQL Josh Berkus
• 07:12   Inheritance question Joanne Formoso
• 08:17   Hints to query parser about indexes Rigmor Ukuhe
• 09:12   zero-length string error ? Aarni
• 09:54   Re: zero-length string error ? Aarni
• 11:03   Strange error in 7.3.1 Duncan Adams (DNS)
• 12:08   Re: zero-length string error ? Bruno Wolff III
• 13:19   Re: zero-length string error ? Aarni
• 13:22   Re: Strange error in 7.3.1 Tom Lane
• 18:16   Re: Question regarding keyword checkboxes in database Lynna Landstreet
• 18:40   Metadata Bovard Yves (DIP)
• 18:40   Installation problem aakash chauhan
• 18:45   Re: Question regarding keyword checkboxes in database Heath Tanner
• 19:08   PGSQL vs. SQL Server questions Lee Matthews
• 19:32   Re: PGSQL vs. SQL Server questions Nabil Sayegh
• 20:26   Re: PGSQL vs. SQL Server questions Josh Berkus
• 20:32   Re: Question regarding keyword checkboxes in database Lynna Landstreet
• 20:55   Re: Tuples radha.manohar@ndsu.nodak.edu
• 21:01   Re: Question regarding keyword checkboxes in database Josh Berkus

12 June 2003

• 00:29   pg_restore ignore specific tables? Robby Russell
• 07:38   Re: PGSQL vs. SQL Server questions Mel Jamero
• 07:51   Re: Question regarding keyword checkboxes in database Dani Oderbolz
• 08:07   Re: PGSQL vs. SQL Server questions Dani Oderbolz
• 08:09   Re: PGSQL vs. SQL Server questions Dani Oderbolz
• 09:47   Re: Converting IBM DB2 TRIGGERs to PostgreSQL Alan Searles
• 11:44   Encoding names? M. Bastin
• 16:19   Re: Metadata Chad Thompson
• 17:05   Re: PGSQL vs. SQL Server questions Josh Berkus
• 20:04   Re: Question regarding keyword checkboxes in database Lynna Landstreet
• 20:44   Re: Question regarding keyword checkboxes in database Josh Berkus
• 21:30   Re: Question regarding keyword checkboxes in database Lynna Landstreet
• 23:05   Multibyte support and accented characters Lynna Landstreet
• 23:17   Re: Question regarding keyword checkboxes in database Josh Berkus
• 23:56   Re: Multibyte support and accented characters M. Bastin

13 June 2003

• 06:21   Exporting data from PostgreSQL Michael Glaesemann
• 07:06   Re: Multibyte support and accented characters Michael Glaesemann
• 07:47   Re: Exporting data from PostgreSQL paul butler
• 09:05   number of rows Marcus Andree S. Magalhaes
• 11:51   Re: Exporting data from PostgreSQL Michael Glaesemann
• 12:14   Re: Converting IBM DB2 TRIGGERs to PostgreSQL Alan Searles
• 13:09   Re: number of rows Nabil Sayegh
• 13:57   Re: Exporting data from PostgreSQL Jeff Eckermann
• 14:12   Re: number of rows Tom Lane
• 16:14   Re: Exporting data from PostgreSQL Josh Berkus
• 18:15   Re: Exporting data from PostgreSQL Jeff Eckermann
• 19:34   Re: Question regarding keyword checkboxes in database Lynna Landstreet
• 20:08   Re: Question regarding keyword checkboxes in database Josh Berkus

14 June 2003

• 13:52   SQL INSERT Statement -- Multi-Row Insert Alan Searles
• 14:08   Re: SQL INSERT Statement -- Multi-Row Insert Bruno Wolff III
• 17:09   Re: SQL INSERT Statement -- Multi-Row Insert Bruno Wolff III
• 17:28   Re: SQL INSERT Statement -- Multi-Row Insert Tom Lane

15 June 2003

• 14:03   Re: Exporting data from PostgreSQL brew@theMode.com

16 June 2003

• 04:22   PGAccess failing.... Smitha V. Babu
• 04:38   Re: PGAccess failing.... brew@theMode.com
• 11:00   How to integrate postgresql to a c application............. Smitha V. Babu
• 11:47   Re: How to integrate postgresql to a c application............. Bruno Wolff III
• 13:24   NOVICE : using variables DAVANNE Eric - NTR ( EDavanne@nanterre.sema.slb.com )
• 17:24   Understanding the explain statement Benjamin Wragg
• 17:24   Re: PGSQL vs. SQL Server questions Lee Matthews
• 17:25   Re: Converting IBM DB2 TRIGGERs to PostgreSQL Robert Treat
• 20:29   using a dumped database file Don Patou
• 20:36   Re: using a dumped database file Reshat Sabiq
• 21:31   Sequence-table association Vamsee Koneru
• 21:50   Re: Sequence-table association Josh Berkus

17 June 2003

• 09:28   Notify postmaster crash?? HK
• 10:19   use cursor in a function Rory Campbell-Lange
• 10:28   Re: use cursor in a function Joe Conway
• 11:23   Re: using a dumped database file Riki Kurniawan
• 12:23   Issues starting postgres on Solaris Brent Howard
• 12:35   Re: use cursor in a function Rory Campbell-Lange
• 14:08   Commit within a PL/PGSQL procedure Harry Broomhall
• 15:43   Re: Commit within a PL/PGSQL procedure Josh Berkus
• 16:05   Re: Commit within a PL/PGSQL procedure Harry Broomhall
• 16:13   Re: Commit within a PL/PGSQL procedure Josh Berkus
• 16:36   Re: Commit within a PL/PGSQL procedure Tom Lane
• 16:39   Re: Commit within a PL/PGSQL procedure Harry Broomhall
• 17:45   Re: use cursor in a function Rory Campbell-Lange
• 18:22   Re: use cursor in a function Joe Conway
• 18:41   Re: Multibyte support and accented characters Lynna Landstreet
• 18:59   Re: use cursor in a function Rory Campbell-Lange
• 19:10   Re: Multibyte support and accented characters M. Bastin
• 20:10   Re: Multibyte support and accented characters Lynna Landstreet
• 21:03   Can't get postmaster to start :-( Shmuel A. Kahn
• 21:49   Re: Commit within a PL/PGSQL procedure Tom Lane
• 23:40   grant select on all tables of a schema Nabil Sayegh
• 23:57   Re: Multibyte support and accented characters Tom Lane

18 June 2003

• 00:14   Re: Can't get postmaster to start :-( deststar
• 02:42   Re: Commit within a PL/PGSQL procedure Mel Jamero
• 03:24   Re: grant select on all tables of a schema Bruno Wolff III
• 08:48   Re: grant select on all tables of a schema Dani Oderbolz
• 08:59   help:steps needed to get the content of table from the database.. . Smitha V. Babu
• 09:00   Re: Commit within a PL/PGSQL procedure Harry Broomhall
• 12:18   sql question (hopefully) Mel Jamero
• 12:44   Re: help:steps needed to get the content of table from the A.Bhuvaneswaran
• 13:19   Re: sql question (hopefully) Ron Johnson
• 13:27   Re: sql question (hopefully) Dani Oderbolz
• 13:46   Re: Commit within a PL/PGSQL procedure Tom Lane
• 14:07   Re: sql question (hopefully) Mel Jamero
• 14:18   Re: sql question (hopefully) Mel Jamero
• 14:19   Re: help:steps needed to get the content of table from the Tom Lane
• 14:34   Re: sql question (hopefully) Bruno Wolff III
• 15:16   Re: sql question (hopefully) Josh Berkus
• 16:17   Vacuum and inserts Fontenot, Paul
• 16:19   Re: sql question (hopefully) Mel Jamero
• 16:25   Re: sql question (hopefully) Josh Berkus
• 16:26   Re: sql question (hopefully) Josh Berkus
• 16:28   Re: Vacuum and inserts Tom Lane
• 17:57   Documentation Tools Juliet May
• 18:18   How to NOT perform an insert Fontenot, Paul
• 19:20   Re: Documentation Tools Nabil Sayegh
• 19:21   Re: Documentation Tools Josh Berkus
• 19:53   Re: Documentation Tools Jorge Ramirez
• 20:38   Re: Documentation Tools Juliet May
• 21:36   Re: How to NOT perform an insert Tom Lane
• 23:34   "Bad date external representation" Lynna Landstreet

19 June 2003

• 01:20   Re: Limiting processor power on queries Ron Mayer
• 02:41   Re: "Bad date external representation" Tom Lane
• 02:47   Re: Limiting processor power on queries Tom Lane
• 06:08   can we use PQstatus for knowing connection status HK
• 13:58   Re: can we use PQstatus for knowing connection status Tom Lane
• 16:35   Indexed access for INET/ CIDR datatype Kaitharam, Ananth
• 16:35   Re: Documentation Tools Douglas Trainor
• 16:35   Re: Documentation Tools Nabil Sayegh
• 16:57   Re: Indexed access for INET/ CIDR datatype Bruno Wolff III
• 17:43   returning recordsets/cursors in plpgsql 7.2.1 Knut P. Lehre
• 17:58   Re: Indexed access for INET/ CIDR datatype Tom Lane
• 18:46   Re: Indexed access for INET/ CIDR datatype Bruno Wolff III
• 19:01   Re: "Bad date external representation" Lynna Landstreet
• 19:13   Re: "Bad date external representation" Lynna Landstreet
• 19:59   [local] idle in transaction Chris Pizzo
• 22:17   Re: "Bad date external representation" Tom Lane
• 22:50   postmaster fatal error LC_TIME:fr when launching jean Bousquet

20 June 2003

• 00:04   [WAS] postmaster fatal error LC_TIME:fr when launching jean Bousquet
• 00:49   Re: [WAS] postmaster fatal error LC_TIME:fr when launching Tom Lane
• 08:25   Help regarding INSERT INTO statement Smitha V. Babu
• 09:33   Re: Help regarding INSERT INTO statement paul butler
• 11:23   Starting psql from Script - how to pass the password? Dani Oderbolz
• 12:22   Re: Starting psql from Script - how to pass the password? Hubert Lubaczewski
• 12:43   Re: Starting psql from Script - how to pass the password? Dani Oderbolz
• 13:49   Re: Commit within a PL/PGSQL procedure Harry Broomhall
• 19:16   Re: Multibyte support and accented characters Ennio-Sr
• 20:05   Re: "Bad date external representation" - solved Lynna Landstreet
• 21:40   connectby(... pos_of_sibling) Nabil Sayegh

21 June 2003

• 04:25   Re: connectby(... pos_of_sibling) Joe Conway
• 18:23   Name limitation question Laura Nichols
• 18:23   connectby(... pos_of_sibling) Nabil Sayegh
• 18:35   Re: Name limitation question Josh Berkus
• 22:21   Re: Name limitation question Tom Lane
• 23:21   Re: connectby(... pos_of_sibling) Nabil Sayegh

22 June 2003

• 00:13   Re: connectby(... pos_of_sibling) Joe Conway
• 01:01   Re: connectby(... pos_of_sibling) Nabil Sayegh
• 01:10   Re: connectby(... pos_of_sibling) Joe Conway
• 05:18   Re: "Bad date external representation" Bruce Momjian
• 19:59   Re: Indexed access for INET/ CIDR datatype Kaitharam, Ananth

23 June 2003

• 09:57   many text files William Mitchell Jr
• 21:36   PostGreSQL remote access David Rickard

24 June 2003

• 03:42   how to update tables and archive the changed data? Wilkinson, Graeme
• 03:59   Re: PostGreSQL remote access Mel Jamero
• 04:29   Re: how to update tables and archive the changed data? Josh Berkus
• 05:50   Re: many text files brew@theMode.com
• 16:34   Re: PostGreSQL remote access David Rickard
• 16:58   Re: PostGreSQL remote access Bruno Wolff III
• 17:58   PG_FUNCTION_ARGS: typeof arg ? Nabil Sayegh
• 20:27   Re: PG_FUNCTION_ARGS: typeof arg ? Joe Conway

25 June 2003

• 00:57   connectby() minor bug in errormessage Nabil Sayegh
• 01:55   recursive function needs static variable Nabil Sayegh
• 02:38   Re: recursive function needs static variable Joe Conway
• 02:44   Re: connectby() minor bug in errormessage Joe Conway
• 03:11   Re: recursive function needs static variable Nabil Sayegh
• 03:16   set up windows client to connect via SSL wei wang
• 04:39   Re: recursive function needs static variable Joe Conway
• 11:50   Re: Name limitation question Kaarel
• 13:37   Re: recursive function needs static variable Nabil Sayegh
• 13:58   Re: Name limitation question Tom Lane
• 15:19   Re: Name limitation question greg@turnstep.com
• 18:15   Re: connectby(... pos_of_sibling) Nabil Sayegh
• 18:18   autotimestamping Michael Hanna
• 18:25   Re: autotimestamping Nabil Sayegh
• 21:42   Re: Name limitation question Bruce Momjian
• 21:53   Which version? Herbie McDuck

26 June 2003

• 01:34   Re: Which version? Bruno Wolff III
• 04:32   Restoring an existing database Michael Glaesemann
• 06:13   Re: Restoring an existing database Josh Berkus
• 09:57   Incremental Dump Herbie McDuck
• 13:53   Re: Incremental Dump Tom Lane
• 13:59   Re: Incremental Dump Herbie McDuck
• 14:06   Re: Incremental Dump Nabil Sayegh
• 17:07   Removing foreign key and adding sequence Chad Thompson
• 17:13   Re: Removing foreign key and adding sequence Josh Berkus
• 17:29   Fw: Removing foreign key and adding sequence Chad Thompson
• 18:18   Re: Fw: Removing foreign key and adding sequence Nabil Sayegh
• 20:04   Best Practice?? phil campaigne
• 20:17   No date = bad date? Lynna Landstreet
• 20:27   Re: No date = bad date? Josh Berkus
• 20:54   basic question Michael Hanna
• 20:59   authentication questions Michael Hanna
• 20:59   Re: basic question Josh Berkus
• 21:05   Re: basic question Marie G. Tuite
• 21:09   Re: No date = bad date? Lynna Landstreet
• 21:17   Re: basic question Nabil Sayegh
• 21:20   Re: Fw: Removing foreign key and adding sequence Chad Thompson
• 21:24   Greater than a value Fontenot, Paul
• 21:28   Re: Fw: Removing foreign key and adding sequence Nabil Sayegh
• 21:44   Re: Greater than a value Josh Berkus
• 23:07   Address Table Rudi Starcevic
• 23:28   Re: Address Table Nabil Sayegh

27 June 2003

• 00:22   test M Spreij
• 00:25   Re: Address Table Rudi Starcevic
• 00:30   Re: authentication questions Mendola Gaetano
• 00:44   Re: Address Table Josh Berkus
• 01:05   enum, set M Spreij
• 01:08   Address Table Rudi Starcevic
• 01:13   Re: enum, set Bruno Wolff III
• 02:43   Re: Best Practice?? Tom Lane
• 02:56   Re: authentication questions Michael Hanna
• 03:11   Re: Address Table Josh Berkus
• 03:38   last id Ramil G. Sagum
• 04:30   Re: last id Josh Berkus
• 07:40   Probably a stupid question Giorgio Ponza
• 08:18   missing postmaster.conf christoph.dellavalle@goetheanum.ch
• 09:50   Re: authentication questions Mendola Gaetano
• 12:21   SELECT too complex? Rory Campbell-Lange
• 12:59   Re: authentication questions Michael Hanna
• 13:11   Re: Address Table Nabil Sayegh
• 13:20   Re: Address Table Nabil Sayegh
• 13:20   Re: Probably a stupid question greg@turnstep.com
• 13:29   Re: missing postmaster.conf greg@turnstep.com
• 13:29   Re: Probably a stupid question Dani Oderbolz
• 13:35   Re: Probably a stupid question greg@turnstep.com
• 13:37   Re: authentication questions Mendola Gaetano
• 13:55   Re: Address Table Nabil Sayegh
• 13:56   Re: Probably a stupid question Nabil Sayegh
• 14:44   Which GRANTS are needed on a Sequnce? Dani Oderbolz
• 14:51   Re: missing postmaster.conf Tom Lane
• 14:56   Re: Which GRANTS are needed on a Sequnce? Bruno Wolff III
• 15:16   Re: Address Table Josh Berkus
• 15:18   Re: authentication questions Tom Lane
• 15:31   Re: Fw: Removing foreign key and adding sequence Chad Thompson
• 15:36   Re: SELECT too complex? Josh Berkus
• 15:40   Re: Which GRANTS are needed on a Sequnce? Tom Lane
• 16:48   Re: Fw: Removing foreign key and adding sequence Nabil Sayegh
• 17:27   plpgsql rowtype Heiko.Kehlenbrink@vermes.fh-oldenburg.de
• 17:27   Re: Probably a stupid question Nabil Sayegh
• 17:29   postmaster generates no socket christoph.dellavalle@goetheanum.ch
• 17:29   Re: Address Table Nabil Sayegh
• 17:29   Probably a stupid question Giorgio Ponza
• 19:36   ERROR: tuplestore_gettuple: invalid state Nabil Sayegh
• 20:17   Re: Probably a stupid question Chad Thompson
• 20:22   Re: connectby_reverselookup() Nabil Sayegh
• 21:41   Re: SELECT too complex? Rory Campbell-Lange
• 23:21   Re: ERROR: tuplestore_gettuple: invalid state Joe Conway
• 23:27   Re: connectby_reverselookup() Joe Conway
• 23:41   Re: connectby_reverselookup() Nabil Sayegh
• 23:42   Re: ERROR: tuplestore_gettuple: invalid state Nabil Sayegh

28 June 2003

• 00:45   Recover database WillyLinux -
• 02:54   Re: postmaster generates no socket Tom Lane

29 June 2003

• 19:26   Re: SELECT too complex? Josh Berkus

30 June 2003

• 11:13   Re: plpgsql rowtype Hubert Lubaczewski
• 11:56   Noobie: Problems with a query Chris Boget
• 11:59   Re: Noobie: Problems with a query Nabil Sayegh
• 12:28   Re: Noobie: Problems with a query Chris Boget
• 12:34   Re: Noobie: Problems with a query Bruno Wolff III
• 12:36   Re: Noobie: Problems with a query Nabil Sayegh
• 13:36   blobs cristi
• 13:40   Re: plpgsql rowtype Rory Campbell-Lange
• 13:42   Re: Noobie: Problems with a query Chris Boget
• 13:49   Vacuum and Vacuum analyze Chris Boget
• 13:50   Re: Noobie: Problems with a query Bruno Wolff III
• 13:57   Re: Vacuum and Vacuum analyze Bruno Wolff III
• 16:54   jobs mailling list: pgsql-jobs@postgresql.org ? Frank Lee
• 17:10   Re: jobs mailling list: pgsql-jobs@postgresql.org ? Robert Treat
• 17:46   Re: jobs mailling list: pgsql-jobs@postgresql.org ? Frank Lee
• 20:22   PGZilla Chad Thompson
• 20:38   Re: PGZilla Bryan Encina
• 21:01   Re: PGZilla Tom Lane