Mailing lists [pgsql-sql]

1 September 2001

• 15:44   Re: 2 tables, joins and same name... Josh Berkus
• 17:27   Re: 2 tables, joins and same name... Ross J. Reedstrom

3 September 2001

• 15:17    Joseph Syjuco
• 16:14   duplicated oid Carolyn Lu Wong
• 17:06   Re: Joe Conway
• 17:21   GRANT ALL ON TO GROUP failure posting-list@MailAndNews.com (Jari Aalto)
• 17:23   More on the TO DO wishlist Chris Ruprecht
• 17:49   Re: Peter Eisentraut
• 17:55   Re: Michael Davis
• 18:18   Re: Stephan Szabo
• 18:37   Re: INSERT Syntax Josh Berkus
• 19:18   Re: More on the TO DO wishlist Josh Berkus
• 20:20   Re: More on the TO DO wishlist Peter Eisentraut
• 21:33   Re: On Differing Optimizer Choices ( Again) Tom Lane
• 22:31   Re: Index Scan Backward vs. Sort/Sequential Scan when using ORDER BY Tom Lane

4 September 2001

• 02:16   Re: More on the TO DO wishlist Josh Berkus
• 02:18   Re: 2 tables, joins and same name... Josh Berkus
• 05:23   Need help in composing PostgreSQL query Vladimir V. Zolotych
• 06:55   Re: Need help in composing PostgreSQL query Oliver Elphick
• 08:54   Re: GRANT ALL ON TO GROUP failure Henshall, Stuart - WCP
• 14:32   Re: 2 tables, joins and same name... Jeff Eckermann
• 14:50   Re: [HACKERS] [GENERAL] getting the oid for a new tuple in a BEFORE Bruce Momjian

6 September 2001

• 16:21    postgresql
• 20:30   BUG in 7.1.3 Alessandro Rossi
• 22:57   Re: duplicated oid Carolyn Lu Wong
• 23:23   Re: duplicated oid Stephan Szabo
• 23:36   Re: duplicated oid Tom Lane

7 September 2001

• 12:13   Re: Haller Christoph
• 12:38   ERROR: DefineQueryRewrite: rule plan string too big. Haller Christoph
• 13:20   Re: ERROR: DefineQueryRewrite: rule plan string too big. Tom Lane

8 September 2001

• 02:54   optimizing queries and indexes... Robert J. Sanford, Jr.

9 September 2001

• 02:06   Re: postgresql
• 19:03   Re: optimizing queries and indexes... Josh Berkus
• 23:06   Re: optimizing queries and indexes... Stephan Szabo

10 September 2001

• 00:05   Re: optimizing queries and indexes... Josh Berkus
• 04:03   Re: optimizing queries and indexes... Stephan Szabo
• 14:36   row level locking? Jeff Barrett
• 15:33   calling a shell script from pl/pgsql Jeff Barrett
• 16:18   Re: row level locking? Stephan Szabo
• 16:22   Re: calling a shell script from pl/pgsql Stephan Szabo
• 16:52   Re: calling a shell script from pl/pgsql Larry Rosenman
• 17:17   pl/sh (was Re: calling a shell script from pl/pgsql) Alex Pilosov
• 17:20   Re: pl/sh (was Re: calling a shell script from pl/pgsql) Stephan Szabo
• 17:23   Re: pl/sh (was Re: calling a shell script from pl/pgsql) Alex Pilosov
• 17:42   Re: calling a shell script from pl/pgsql clayton cottingham
• 18:33   Re: calling a shell script from pl/pgsql Jeff Barrett
• 18:50   Re: calling a shell script from pl/pgsql Larry Rosenman
• 19:12   Re: pl/sh (was Re: calling a shell script from pl/pgsql) Peter Eisentraut

11 September 2001

• 01:11   group by weirdness Joseph Shraibman
• 03:06   Re: group by weirdness Josh Berkus
• 07:14   Re: calling a shell script from pl/pgsql Jan Wieck
• 07:18   table inheritance and foreign key troubles Kevin Way
• 07:46   SQL Query Miguel González
• 08:08   Re: table inheritance and foreign key troubles Christof Glaser
• 09:45   Re: table inheritance and foreign key troubles Christof Glaser
• 09:58   Re: table inheritance and foreign key troubles Stephan Szabo
• 13:58   referencing oid impozsible ? patrick.jacquot@anpe.fr
• 15:58   Re: referencing oid impozsible ? Stephan Szabo
• 16:29   Re: referencing oid impozsible ? Josh Berkus

12 September 2001

• 00:25   Re: table inheritance and foreign key troubles Kevin Way
• 07:01   Re: SQL Query Miguel González
• 11:49   Re: How do I extract ONE particular field, when multiple table contain Arne Weiner
• 13:05   cache lookup failed victor
• 14:03   Re: cache lookup failed Peter Eisentraut
• 14:40   ERROR: Cannot insert a duplicate key into a unique index Haller Christoph
• 15:18   plpgsql function case statement Peter Schmidt
• 15:54   Re: ERROR: Cannot insert a duplicate key into a unique index Josh Berkus

13 September 2001

• 14:46   query time Esteban Gutierrez Abarzua
• 17:17   Re: query time Peter Eisentraut
• 20:31   Re: group by weirdness Joseph Shraibman
• 20:53   Re: group by weirdness Joseph Shraibman

14 September 2001

• 03:26   trigger trouble -- procedure not found Kevin Way
• 04:05   Re: trigger trouble -- procedure not found Bhuvan A
• 04:16   Re: trigger trouble -- procedure not found Stephan Szabo
• 05:30   Re: trigger trouble -- procedure not found Kevin Way
• 09:20   SQL request change when upgrade from 7.0.2 to 7.1.3 Richard NAGY
• 10:58   ... Bhuvan A
• 12:38   How to Get Timestamp From SECONDS? Bhuvan A
• 13:19   Re: Peter Eisentraut
• 14:14   Re: Combine query views into one SQL string Maik
• 14:57   Number the lines yaubi@yaubi.com (Yoann)
• 15:57   Re: Combine query views into one SQL string Nils Zonneveld
• 16:52   Urgent: How to set autocommit off in postgres......... Advid@newgen
• 17:23   Re: Combine query views into one SQL string Nils Zonneveld
• 19:04   How do I extract ONE particular field, when multiple table contain the same field name? olle.wijk@systecon.se (Olle Wijk)
• 19:09   array variables in pl/pgsql Jack
• 19:57   To query many tables. trebischt@freemail.hu (trebischt)
• 20:32   array variable in pl/pgsql datactrl
• 20:55   Re: Combine query views into one SQL string eimas@lycos.com (Eimas)
• 21:02   Re: SQL request change when upgrade from 7.0.2 to 7.1.3 A_Schnabel@t-online.de (Andre Schnabel)
• 21:02   Re: Combine query views into one SQL string yaubi@yaubi.com (Yoann)
• 21:13   Re: How do I extract ONE particular field, when multiple table contain the same field name? yaubi@yaubi.Com (Yoann)
• 21:38   Re: How do I extract ONE particular field, when multiple table contain the same field name? Jeff Eckermann
• 22:14   Re: Combine query views into one SQL string Tony Hunt
• 22:34   Re: Combine query views into one SQL string Gledatelj
• 22:41   using LATIN1 ? domingo@dad-it.com (Domingo Alvarez Duarte)
• 22:45   Which SQL query makes it possible to optain the 3 greatest values of an interger list ? yaubi@yaubi.com (Yoann)
• 23:19   array variable in pl/pgsql datactrl
• 23:20   array variable in pl/pgsql jack
• 23:28   Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Richard NAGY
• 23:58   Re: How do I extract ONE particular field, when multiple table Patrik Kudo

15 September 2001

• 00:06   Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Josh Berkus
• 03:12   Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Josh Berkus
• 03:15   Re: Number the lines Jeff Eckermann
• 04:16   Re: Which SQL query makes it possible to optain the 3 greatest Patrik Kudo
• 04:44   Re: How do I extract ONE particular field, when multiple table contain the same field name? Christof Glaser
• 05:17   Re: Which SQL query makes it possible to optain the 3 greatest values of an interger list ? Wei Weng
• 06:55   Re: To query many tables. A_Schnabel@t-online.de (Andre Schnabel)

16 September 2001

• 03:34   Re: optimizing queries and indexes... Tom Lane
• 13:14   Intentional, or bug? Kovacs Baldvin
• 14:00   Correction for the previous letter: Kovacs Baldvin
• 14:04   Re: Intentional, or bug? Tod McQuillin
• 18:12   Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Tom Lane
• 18:31   Re: Intentional, or bug? Tom Lane
• 18:44   Re: Intentional, or bug? Stephan Szabo
• 19:36   Re: optimizing queries and indexes... Josh Berkus
• 21:02   Part 2 of "Intentional, or a bug".... Kovacs Baldvin
• 22:08   Re: Part 2 of "Intentional, or a bug".... Tom Lane

17 September 2001

• 07:20   Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Richard NAGY
• 07:24   Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Richard NAGY
• 07:36   Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Richard NAGY
• 07:47   Re: Part 2 of "Intentional, or a bug".... Kovacs Baldvin
• 11:15   Re: Number the lines Haller Christoph
• 11:17   functions returning Tomasz Myrta
• 11:25   Re: group by weirdness joe.celko@trilogy.com (--CELKO--)
• 12:00   Re: Number the lines Kovacs Baldvin
• 12:09   I could do with some guidance degoble@sgtech (David. E. Goble)
• 13:15   Checking for table existence Julester
• 13:22   How to see the definition of an existing table? ke wang
• 13:26   Re: group by weirdness Carl van Tast
• 13:30   Re: How to Get Timestamp From SECONDS? Hans-Juergen Schoenig
• 13:32   Re: Number the lines missive@frontiernet.net (Lee Harr)
• 13:33   Re: Checking for table existence Hans-Juergen Schoenig
• 14:00   Re: Checking for table existence Stephan Szabo
• 14:23   Checking for table existence Julester
• 14:30   Re: Number the lines missive@frontiernet.net (Lee Harr)
• 14:31   Re: I could do with some guidance Josh Berkus
• 14:31   Re: Checking for table existence Hans-Juergen Schoenig
• 14:32   Checking for table existence Julester
• 14:33   Re: How to Get Timestamp From SECONDS? Hans-Juergen Schoenig
• 14:35   Re: group by weirdness Carl van Tast
• 14:35   Re: Number the lines missive@frontiernet.net (Lee Harr)
• 14:42   Out of free buffers... HELP! Diehl, Jeffrey
• 14:51   Re: How to Get Timestamp From SECONDS? Hans-Juergen Schoenig
• 14:51   Re: Checking for table existence Hans-Juergen Schoenig
• 15:12   Re: group by weirdness Carl van Tast
• 23:35   Re: Checking for table existence Roberto Mello

18 September 2001

• 00:27   Re: Checking for table existence Kovacs Baldvin
• 03:21   Re: Checking for table existence Josh Berkus
• 06:50   Re: Out of free buffers... HELP! Diehl, Jeffrey
• 08:26   Re: How to see the definition of an existing table? Haller Christoph
• 10:18   Re: Out of free buffers... HELP! Haller Christoph
• 11:16   Re: Out of free buffers... HELP! darcy@druid.net (D'Arcy J.M. Cain)
• 14:32   Stored prosedure last run pkasimov@yahoo.com (Pasha)
• 20:35   Re: How to see the definition of an existing table? missive@frontiernet.net (Lee Harr)
• 21:40   Stored prosedure last run pkasimov@yahoo.com (Pasha)
• 21:42   Holiday Calculations? Josh Berkus
• 23:28   Selecting latest value Patrik Kudo
• 23:58   Re: Out of free buffers... HELP! Tom Lane

19 September 2001

• 00:41   Re: Out of free buffers... HELP! Tom Lane
• 00:41   Re: Stored prosedure last run Stephan Szabo
• 00:41   Registring a C function in PostgreSQL Miguel González
• 01:32   PL/PGSQL Regexe rdear
• 01:32   Re: group by weirdness Carl van Tast
• 01:35   Re: Checking for table existence Kovacs Baldvin
• 01:36   Re: Number the lines Christopher Sawtell
• 01:49   URGENT ! Nouveau virus Denis Bucher
• 02:08   Re: Holiday Calculations? Philip Hallstrom
• 02:08   Implicit v Explicit joins... ericnielsen@pop.ne.mediaone.net
• 02:08   Re: Out of free buffers... HELP! Kovacs Baldvin
• 02:09   Stored prosedure last run pkasimov@yahoo.com (Pasha)
• 02:28   Re: Out of free buffers... HELP! Josh Berkus
• 02:43   Re: Holiday Calculations? Brett Schwarz
• 05:24   Re: Out of free buffers... HELP! Mark kirkwood
• 07:13   Re: Registring a C function in PostgreSQL Peter Eisentraut
• 07:38   Re: Registring a C function in PostgreSQL Haller Christoph
• 08:58   Implicit v Explicit joins... ericnielsen@pop.ne.mediaone.net
• 09:37   Re: group by weirdness Carl van Tast
• 09:42   PL/PGSQL Regexe rdear
• 10:06   Re: Registring a C function in PostgreSQL Miguel González
• 10:20   Implicit v Explicit joins... ericnielsen@pop.ne.mediaone.net
• 10:39   Re: group by weirdness Carl van Tast
• 11:50   PL/PGSQL Regexe rdear
• 11:58   Re: Registring a C function in PostgreSQL II Haller Christoph
• 13:48   Re: PL/PGSQL Regexe Tom Lane
• 14:50   Re: Stored prosedure last run Josh Berkus
• 16:45   Re: Checking for table existence (fwd) Kovacs Baldvin
• 17:28   Re: Registring a C function in PostgreSQL II Miguel González
• 18:08   Creating a boolean function Miguel González
• 18:18   URGENT ! Nouveau virus Denis Bucher
• 18:53   Re: Creating a boolean function Stephan Szabo
• 18:59   Re: Creating a boolean function Jeff Eckermann
• 19:58   Re: Holiday Calculations? Brett Schwarz
• 21:05   Re: Holiday Calculations? clayton cottingham
• 21:18   Re: Out of free buffers... HELP! Diehl, Jeffrey
• 21:28   Re: Out of free buffers... HELP! Diehl, Jeffrey
• 21:33   Re: Creating a boolean function Tom Lane
• 21:55   Re: Creating a boolean function Kovacs Baldvin
• 22:32   Re: Holiday Calculations? clayton cottingham
• 23:29   Re: Out of free buffers... HELP! Tom Lane

20 September 2001

• 00:28   Re: Out of free buffers... HELP! Josh Berkus
• 06:57   Re: Out of free buffers... HELP! Tom Lane
• 07:31   Re: Registring a C function in PostgreSQL II Haller Christoph
• 07:31   Trigger Problem Mohammad Faisal
• 08:13   Re: Selecting latest value Haller Christoph
• 09:57   table restruction David M. Richter
• 10:50   Re: Trigger Problem Andreas Joseph Krogh
• 12:58   Re: table restruct... Kovacs Baldvin
• 13:04   Re: Selecting latest value Patrik Kudo
• 13:29   Re: table restruct... David M. Richter
• 13:29   Re: Selecting latest value II Haller Christoph
• 14:03   Re: table restruct... Stephan Szabo
• 14:33   Re: Selecting latest value Stephan Szabo
• 14:55   Re: Selecting latest value Patrik Kudo
• 14:55   Re: table restruct... Thurstan R. McDougle
• 15:31   Re: Selecting latest value Tom Lane
• 15:32   Re: Selecting latest value II Chris Ruprecht
• 15:43   Re: Selecting latest value II Thurstan R. McDougle
• 18:14   Re: Out of free buffers... HELP! Diehl, Jeffrey
• 18:14   Re: Out of free buffers... HELP! Diehl, Jeffrey
• 18:57   Re: Out of free buffers... HELP! Josh Berkus
• 19:32   Re: Out of free buffers... HELP! Diehl, Jeffrey

21 September 2001

• 14:06   select is fast, update based on same where clause is slow Jeff Barrett
• 14:49   Re: select is fast, update based on same where clause is slow Stephan Szabo
• 15:26   Re: select is fast, update based on same where clause is slow Josh Berkus
• 16:04   Re: Selecting latest value II Thurstan R. McDougle
• 16:09   Re: select is fast, update based on same where clause is slow Jeff Barrett
• 23:34   Re: Q on "Re: select is fast, update based on same where clause is slow " Josh Berkus

22 September 2001

• 11:04   more information on JOINs postgresql
• 14:43   Re: more information on JOINs Francesco Casadei
• 15:02   Re: more information on JOINs postgresql
• 16:01   Re: more information on JOINs Stephan Szabo

23 September 2001

• 06:22   confounding, incorrect constraint error Kevin Way
• 19:54   Re: confounding, incorrect constraint error Kevin Way
• 20:30   Request for book reviews/comments Josh Berkus
• 22:55   Bug?: Update on ancestor for a row of a child Kovacs Baldvin

24 September 2001

• 00:27   outer joins strangeness Alex Pilosov
• 01:41   problem loading array Frederick Klauschen
• 02:16   How to enter lists into database. Frederick Klauschen
• 02:16   Re: Bug?: Update on ancestor for a row of a child Kevin Way
• 02:27   loading array_iterator.so does not work with Postgresql 7.0.3/7.1.3 Frederick Klauschen
• 03:57   Re: outer joins strangeness Stephan Szabo
• 04:07   Re: outer joins strangeness Alex Pilosov
• 04:54   Re: loading array_iterator.so does not work with Postgresql Oleg Bartunov
• 07:02   Server crash caused by CHECK on child Kovacs Baldvin
• 10:42   Re: Server crash caused by CHECK on child Kevin Way
• 14:10   Re: How to enter lists into database. Josh Berkus
• 14:10   Re: Request for book reviews/comments Josh Berkus
• 14:14   Re: Bug?: Update on ancestor for a row of a child Josh Berkus
• 15:07   Re: outer joins strangeness Stephan Szabo
• 15:09   Re: [HACKERS] Server crash caused by CHECK on child Stephan Szabo
• 15:10   Re: How to enter lists into database:Example. Josh Berkus
• 15:11   Re: Bug?: Update on ancestor for a row of a child Kevin Way
• 15:29   Re: How to enter lists into database. Oleg Bartunov
• 17:15   Re: confounding, incorrect constraint error Jan Wieck
• 17:38   CHECK problem really OK now... Kovacs Baldvin
• 18:18   Re: CHECK problem really OK now... Josh Berkus
• 18:27   Re: CHECK problem really OK now... Jan Wieck
• 23:18   explain command Esteban Gutierrez Abarzua

25 September 2001

• 03:20   Re: [HACKERS] outer joins strangeness Tom Lane
• 03:50   Re: CHECK problem really OK now... Roberto Mello
• 23:41   PgAdmin Keith Gray

26 September 2001

• 03:27   Re: PgAdmin Josh Berkus
• 11:34   Re: A simple join question that may stump you Thurstan R. McDougle
• 14:14   is it possible to get the number of rows of a table? Frederick Klauschen
• 15:52   Re: is it possible to get the number of rows of a table? Wei Weng
• 16:57   Re: plpgsql function case statement Masaru Sugawara
• 17:16   Re: How to enter lists into database: Problems with solution. Josh Berkus
• 17:51   Query does not work: parse ERROR, Re: How to enter lists into database: Problems with solution. Frederick Klauschen
• 18:09   Re: CHECK problem really OK now... Tom Lane
• 18:10   Re: Query does not work: parse ERROR, Re: How to enter lists into database: Problems with solution. Josh Berkus
• 19:26   PARSER ERROR Frederick Klauschen
• 21:37   Re: Query does not work: parse ERROR, Re: How to enter lists into database: Problems with solution. Carl van Tast
• 22:08   Re: Subquery with IN or EXISTS Carl van Tast

27 September 2001

• 06:44   Re: is it possible to get the number of rows of a table? Haller Christoph
• 13:40   Simple Query HELP!!! bulk@colonnello.org (Paolo Colonnello)
• 13:52   A simple join question that may stump you nospam4@pobox.com (Ross Smith)
• 13:57   HP-UX 11.0 postgres compile error! Youn-Oh, Jung
• 13:58   Re: Subquery with IN or EXISTS anssiman@my-deja.com (A. Mannisto)
• 14:05   Re: getting some tech skills? Jimi Thompson
• 14:10   Re: getting some tech skills? Andy Hibbins
• 14:17   Subquery with IN or EXISTS anssiman@my-deja.com (A. Mannisto)
• 14:20   Re: Request for book reviews/comments Rick Robino
• 14:23   Re: Simple Query HELP!!! reb_01501@yahoo.com (Bob Barrows)
• 14:23   Re: Selecting latest value II Carl van Tast
• 14:24   Re: Simple Query HELP!!! bulk@colonnello.org (Paolo Colonnello)
• 14:25   How to get BLOB length? Oleg Olenin
• 14:32   Re: A simple join question that may stump you prinsarian@zonnet.nl (A. Prins)
• 14:41   Re: PL/PGSQL Regexe rdear
• 14:45   PARSER ERROR persists .... Frederick Klauschen
• 14:45   Re: A simple join question that may stump you Josh Berkus
• 14:45   How to get BLOB size? Oleg Olenin
• 14:45   Re: Simple Query HELP!!! 71062.1056@compuserve.com (--CELKO--)
• 14:56   A bug in triggers PG 7.1.3 or misunderstand ? domingo@dad-it.com (Domingo Alvarez Duarte)
• 14:57   how can i return multiple values from a function srinivas
• 15:08   Aggregate Aggravation Robin's PG-SQL List
• 15:13   Re: HP-UX 11.0 postgres compile error! Tom Lane
• 15:16   TEXT in select Michael Remme
• 15:17   Problem in connection using .odbc.ini meghana mande
• 15:24   LEFT OUTER JOIN problem Ludek Finstrle
• 16:31   Re: PARSER ERROR persists .... Tom Lane
• 16:52   Re: A bug in triggers PG 7.1.3 or misunderstand ? Tom Lane
• 17:14   Re: Aggregate Aggravation Tom Lane
• 20:37   Re: LEFT OUTER JOIN problem Josh Berkus
• 21:26   Re: LEFT OUTER JOIN problem Stephan Szabo
• 21:47   simple question! Esteban Gutierrez Abarzua
• 22:11   format timestamp Laurette Cisneros

28 September 2001

• 07:05   Re: simple question! Josh Berkus

29 September 2001

• 04:54   What is wrong? Wei Weng
• 06:33   Re: TEXT in select Haller Christoph
• 08:13   Re: What is wrong? Stephan Szabo
• 09:24   Entering data in serial column Devrim GUNDUZ
• 13:01   Re: Entering data in serial column david@netventures.com.au