Mailing lists [pgsql-sql]

1 July 2004

• 03:08   Re: rules Jan Norman Pedersen
• 04:13   Re: finding if a foreign key is in use Kenneth Gonsalves
• 07:08   Re: finding if a foreign key is in use Stephan Szabo
• 09:57   Re: finding if a foreign key is in use Phil Endecott
• 10:27   Re: finding if a foreign key is in use Achilleus Mantzios
• 19:20   Table and/or Database Creation Time lbrtchx@hotmail.com (Albretch)
• 20:35   URGENT - Need the DATA TYPES comparison for PostgreSQL and ORACLE and SQL Server Duane
• 21:46   Re: FW: "=" operator vs. "IS" Jeff Boes
• 22:33   How to make a portable application? Bob Hobart
• 22:51   quoting Aaron W. West
• 22:51   Re: Unrecognized node type Alvaro Sanchez-Mariscal

2 July 2004

• 03:56   Re: quoting Tom Lane
• 07:04   Re: quoting Michael Kleiser
• 11:37   Re: best method to copy data across databases reina_ga@hotmail.com (Tony Reina)
• 14:13   Re: best method to copy data across databases Tom Lane
• 18:37   Re: Question about a CIDR based query siganos@gmail.com (George Siganos)

4 July 2004

• 21:22   Why no exprs in format string to RAISE Markus Bertheau
• 22:58   Re: [BUGS] [JDBC] Error in DatabaseMetaData.getColumns() with Views Stephan Szabo

5 July 2004

• 00:46   Re: [BUGS] [JDBC] Error in DatabaseMetaData.getColumns() with Views Stephan Szabo
• 03:34   Re: [BUGS] [JDBC] Error in DatabaseMetaData.getColumns() with Views Stephan Szabo
• 11:34   Re: Why no exprs in format string to RAISE Richard Huxton
• 15:31   Custom type where not all elements are comparable Markus Bertheau
• 16:33   Re: Custom type where not all elements are comparable Tom Lane
• 19:39   Re: Custom type where not all elements are comparable Peter Eisentraut

6 July 2004

• 08:59   Immutable function in index SZŰCS Gábor
• 13:38   Re: Immutable function in index Tom Lane
• 17:26   Re: Why no exprs in format string to RAISE Bruce Momjian

7 July 2004

• 06:45   Triggers - need help !!! Pradeepkumar, Pyatalo (IE10)
• 07:28   Re: Triggers - need help !!! Tomasz Myrta
• 09:18   Re: Triggers - need help !!! Pradeepkumar, Pyatalo (IE10)
• 11:03   Re: Triggers - need help !!! Richard Huxton

8 July 2004

• 11:10   Constraint->function dependency and dump in 7.3 SZŰCS Gábor
• 11:19   Re: Triggers - need help !!! SZUCS Gábor
• 13:36   Newbie (to postgres) question Pedro B.
• 17:28   best method to copy data across databases ctrl@altonsys.com (ctrl)
• 17:30   Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views Dario V. Fassi
• 17:31   Re: best method to copy data across databases ctrl@altonsys.com (ctrl)

9 July 2004

• 05:15   Re: Constraint->function dependency and dump in 7.3 Együd Csaba
• 15:20   Re: [PHP] Secure DB Systems - How to Bruno Wolff III
• 15:34   Re: Constraint->function dependency and dump in 7.3 Verebes Gabor
• 21:35   Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views Dario V. Fassi
• 21:35   Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views Kris Jurka
• 21:39   Re: [BUGS] [JDBC] Error in DatabaseMetaData.getColumns() with Views Dario V. Fassi
• 21:39   Re: [BUGS] [JDBC] Error in DatabaseMetaData.getColumns() with Views Dario V. Fassi
• 21:44   What is PG best practice for storing temporary data in functions? Ben
• 22:15   Re: How to filter on timestamps? Mike Rylander
• 22:16   How to filter on timestamps? B.W.H. van Beest
• 22:18   Re: Triggers - need help !!! Mischa Sandberg
• 22:26   Re: append columns that are null Gerwin Philippo
• 22:26   Re: append columns that are null nobody
• 22:27   Help with sql statement grouping and distinct David Inglis
• 22:27   Re: append columns that are null Gerwin Philippo
• 22:28   Secure DB Systems - How to Sarah Tanembaum
• 22:31   append columns that are null Gerwin Philippo
• 22:31   Re: append columns that are null Hans de Bruin
• 22:32   Re: append columns that are null nobody

10 July 2004

• 06:25   Problem in Stored Procedures Pradeepkumar, Pyatalo (IE10)

11 July 2004

• 06:35   Re: Problem in Stored Procedures Rajesh Kumar Mallah
• 16:22   please help me with text cast to int .... Theodore Petrosky
• 17:02   Re: please help me with text cast to int .... Phil Endecott
• 17:06   Re: please help me with text cast to int .... Stephan Szabo
• 18:52   Re: please help me with text cast to int .... Theodore Petrosky

12 July 2004

• 08:46   Comparing tsearch2 vectors. Rajesh Kumar Mallah
• 11:50   Re: Comparing tsearch2 vectors. Achilleus Mantzios
• 12:30   Re: Constraint->function dependency and dump in 7.3 SZŰCS Gábor
• 12:34   Re: Comparing tsearch2 vectors. Rajesh Kumar Mallah
• 12:51   Re: Constraint->function dependency and dump in 7.3 Rod Taylor
• 12:53   Re: Comparing tsearch2 vectors. Achilleus Mantzios
• 13:08   Re: Constraint->function dependency and dump in 7.3 Együd Csaba
• 14:06   Re: Comparing tsearch2 vectors. Rajesh Kumar Mallah
• 14:07   Re: Secure DB Systems - How to Rajesh Kumar Mallah
• 14:31   Re: Comparing tsearch2 vectors. Achilleus Mantzios
• 16:06   Order of execution of rules Hilary Forbes
• 16:47   Re: Order of execution of rules Stef

13 July 2004

• 03:34   Re: Comparing tsearch2 vectors. Rajesh Kumar Mallah
• 07:27   Re: Comparing tsearch2 vectors. Achilleus Mantzios
• 09:34   Re: [PHP] Secure DB Systems - How to Daniel Struck
• 12:31   Re: [PHP] Secure DB Systems - How to Bruno Wolff III
• 13:17   Re: [PHP] Secure DB Systems - How to Daniel Struck
• 16:30   Re: Constraint->function dependency and dump in 7.3 SZŰCS Gábor
• 17:20   Re: Constraint->function dependency and dump in 7.3 Rod Taylor
• 17:42   Re: Constraint->function dependency and dump in 7.3 SZŰCS Gábor
• 17:54   Certain COPY's ignored from dump? SZŰCS Gábor
• 18:03   Re: Constraint->function dependency and dump in 7.3 Rod Taylor
• 18:21   Re: Constraint->function dependency and dump in 7.3 SZŰCS Gábor
• 20:30   How do I convice postgres to use an index? Vic Ricker

14 July 2004

• 03:48   schemas Kenneth Gonsalves
• 05:29   Re: schemas Bruno Wolff III
• 18:51   Indexable (constant LIKE prefix_keyfield) ? Alexander M. Pravking

15 July 2004

• 00:23   calling function , passing OLD as argument R.Welz
• 03:03   Re: Secure DB Systems - How to Christopher Browne
• 14:29   Re: How do I convice postgres to use an index? SZUCS Gábor
• 14:50   Re: How do I convice postgres to use an index? Achilleus Mantzios
• 17:19   'UPDATE OR INSERT' command Jeff Kowalczyk
• 17:46   Re: 'UPDATE OR INSERT' command Bruno Wolff III
• 17:49   Re: 'UPDATE OR INSERT' command Stephen Frost

16 July 2004

• 08:45   Problem in age on a dates interval Luis Sousa
• 11:52   Re: Problem in age on a dates interval Theodore Petrosky
• 14:34   Re: Problem in age on a dates interval Tom Lane
• 18:52   Sorting problem ruggero.maria.rossi@libero.it (Ruggero)
• 19:21   Re: [PHP] Secure DB Systems - How to Sarah Tanembaum
• 19:44   Re: Sorting problem Stephan Szabo
• 19:54   Query plan discrepancies martian.bob@gmail.com (Bob Arens)
• 19:55   Re: [ADMIN] [PHP] Secure DB Systems - How to Mitch Pirtle
• 19:58   Re: Sorting problem Stu
• 20:18   BYTEA output presentation Peter Wang
• 20:48   Re: BYTEA output presentation Peter Eisentraut

17 July 2004

• 02:28   Re: Query plan discrepancies Rod Taylor

18 July 2004

• 06:29   Re: [JDBC] [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE Tom Lane
• 08:28   Re: [JDBC] [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE Peter Eisentraut
• 20:45   [ocpfree] Query Optimization Help Needed. vaibhav singh
• 20:58   FOR-IN-EXECUTE, why fail? mmarencibia@yahoo.es (Marcos Medina)
• 21:22   Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE Dario V. Fassi
• 21:35   Re: [JDBC] [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE Dario V. Fassi

19 July 2004

• 08:48   Re: How do I convice postgres to use an index? SZUCS Gabor
• 09:02   Re: Problem in age on a dates interval Luis Sousa
• 10:46   Re: Problem in age on a dates interval Alexander M. Pravking
• 18:54   C++ interface problem with libpq.so.3 Kemin Zhou
• 20:04   Re: C++ interface problem with libpq.so.3 Tom Lane
• 22:11   Group by failing on Null values Caleb Simonyi-Gindele
• 22:29   Re: Group by failing on Null values Rosser Schwarz

20 July 2004

• 06:28   locks and triggers. give me an advice please sad
• 08:18   Re: Problem in age on a dates interval Luis Sousa
• 12:16   surrogate key or not? Markus Bertheau
• 13:34   Stored procedures and "pseudo" fields.. Lars Erik Thorsplass
• 13:56   Re: Stored procedures and "pseudo" fields.. Tomasz Myrta
• 14:11   Re: Stored procedures and "pseudo" fields.. Markus Bertheau
• 14:21   Re: How do I convice postgres to use an index? Vic Ricker
• 15:27   SELECT query/subquery problem Caleb Simonyi-Gindele
• 18:25   fail to compare between bytea output in plpgsql Peter Wang
• 18:30   Re: locks and triggers. give me an advice please Steve Crawford
• 22:03   Re: [GENERAL] Stored procedures and "pseudo" fields.. Lars Erik Thorsplass

21 July 2004

• 00:55   date_format in postresql azah azah
• 01:31   Re: surrogate key or not? Iain
• 02:39   Re: date_format in postresql Rod Taylor
• 02:46   Inherited tables and new fields Jeff Boes
• 03:18   Re: FOR-IN-EXECUTE, why fail? Gaetano Mendola
• 03:53   Re: date_format in postresql azah azah
• 07:01   Re: surrogate key or not? Josh Berkus
• 07:07   Re: locks and triggers. give me an advice please sad
• 07:11   Re: Inherited tables and new fields Oliver Elphick
• 07:30   Re: surrogate key or not? Josh Berkus
• 08:34   Please help me.. problem in to_char azah azah
• 08:36   Re: surrogate key or not? sad
• 10:59   Re: surrogate key or not? Markus Bertheau
• 11:22   Re: surrogate key or not? sad
• 12:16   Re: Please help me.. problem in to_char Markus Bertheau
• 12:34   ? on announcement of 7.5 sad
• 12:35   Re: Please help me.. problem in to_char Theodore Petrosky
• 13:19   Re: date_format in postresql Frank Bax
• 14:05   immutable function calling stable function Markus Bertheau
• 14:45   Re: date_format in postresql Rod Taylor
• 14:46   Re: immutable function calling stable function Tom Lane
• 14:50   MySQL-style "create temporary table foo select ..." Geoff Richards
• 14:51   Re: immutable function calling stable function Stephan Szabo
• 15:08   Re: MySQL-style "create temporary table foo select ..." Michael Kleiser
• 15:09   Sorry too many conecctions Javier Tesis Tolosa Trabajo
• 15:11   Re: surrogate key or not? Rod Taylor
• 15:29   Re: MySQL-style "create temporary table foo select ..." Geoff Richards
• 17:27   Re: surrogate key or not? Josh Berkus
• 19:34   Re: Sorry too many conecctions Gregory S. Williamson
• 23:19   Re: ? on announcement of 7.5 Josh Berkus

22 July 2004

• 02:43   Re: surrogate key or not? Iain
• 02:44   Re: Please help me.. problem in to_char azah azah
• 03:00   Re: Please help me.. problem in to_char azah azah
• 03:13   Re: date_format in postresql azah azah
• 04:36   next integer in serial key Kenneth Gonsalves
• 05:33   Re: next integer in serial key Oliver Elphick
• 07:38   LIKE on index not working Chris Cox
• 08:12   connection delay cristi
• 08:57   Re: connection delay Achilleus Mantzios
• 11:47   Re: next integer in serial key 
• 12:15   Re: next integer in serial key Oliver Elphick
• 12:40   Re: surrogate key or not? Karsten Hilbert
• 12:41   Re: LIKE on index not working Peter Eisentraut
• 13:09   Re: next integer in serial key 
• 13:20   Re: next integer in serial key Kenneth Gonsalves
• 13:27   Re: next integer in serial key Kenneth Gonsalves
• 13:37   Re: next integer in serial key 
• 13:52   Re: next integer in serial key Stephan Szabo
• 14:52   Converting a plperlu function to a plpgsql function Devin Whalen
• 15:16   Re: LIKE on index not working Chris Browne
• 16:46   Problem with transaction in functions and tempory tables Gerardo Castillo
• 17:07   Re: surrogate key or not? Josh Berkus
• 17:10   Re: LIKE on index not working Tom Lane
• 17:27   Re: Problem with transaction in functions and tempory tables Stephan Szabo
• 18:23   Re: Converting a plperlu function to a plpgsql function Joe Conway
• 19:09   Re: Converting a plperlu function to a plpgsql function Jeff Eckermann
• 19:21   Re: Converting a plperlu function to a plpgsql function Devin Whalen
• 20:34   Re: Converting a plperlu function to a plpgsql function Tom Lane
• 23:46   Re: LIKE on index not working Chris Cox

23 July 2004

• 06:08   Re: surrogate key or not? sad
• 07:00   Re: surrogate key or not? Karsten Hilbert
• 09:33   Re: surrogate key or not? Kenneth Gonsalves
• 10:00   Re: surrogate key or not? Michael Glaesemann
• 10:35   Re: surrogate key or not? Kenneth Gonsalves
• 11:18   Re: surrogate key or not? Michael Glaesemann
• 12:03   Re: surrogate key or not? Kenneth Gonsalves
• 13:15   Re: surrogate key or not? Achilleus Mantzios
• 13:59   Re: surrogate key or not? Janning Vygen
• 14:08   Re: surrogate key or not? Tom Lane
• 17:17   Re: surrogate key or not? Josh Berkus
• 17:20   Re: surrogate key or not? Josh Berkus

24 July 2004

• 08:46   Re: surrogate key or not? Karsten.Hilbert@gmx.net
• 09:20   Re: surrogate key or not? Karsten Hilbert
• 09:20   Re: surrogate key or not? Karsten Hilbert
• 12:35   Is a backend id or something available for use as a foreign key? Markus Bertheau
• 14:08   Re: surrogate key or not? David Garamond
• 14:31   Trigger functions with dynamic SQL Andreas Haumer
• 14:39   Re: Is a backend id or something available for use as a foreign key? Tom Lane
• 15:01   Re: Trigger functions with dynamic SQL Tom Lane
• 15:46   Re: Trigger functions with dynamic SQL Andreas Haumer
• 16:13   Re: Trigger functions with dynamic SQL Tom Lane

25 July 2004

• 13:20   SELECT from a list Keith Gallant
• 13:56   Re: SELECT from a list Markus Bertheau
• 14:39   Re: SELECT from a list Jean-Luc Lachance
• 16:23   Re: SELECT from a list Markus Bertheau
• 17:34   Re: SELECT from a list Tom Lane
• 19:07   Re: regex engine Markus Bertheau
• 19:41   Re: regex engine Tom Lane
• 21:14   Re: regex engine Markus Bertheau
• 23:46   Re: Please help - performance problems Gaetano Mendola
• 23:46   Re: Object Create Date Gaetano Mendola
• 23:46   Re: constraitnt on case sensetive and case insensetive columns Gaetano Mendola

26 July 2004

• 10:23   Re: surrogate key or not? Iain
• 10:40   Re: surrogate key or not? Iain
• 12:05   Re: surrogate key or not? sad
• 15:04   Re: Trigger functions with dynamic SQL Andreas Haumer
• 20:40   Re: surrogate key or not? Karsten Hilbert

27 July 2004

• 07:28   surrogate keys and replication. sad
• 07:39   Re: surrogate key or not? Kenneth Gonsalves

28 July 2004

• 02:32   Re: surrogate key or not? Markus Bertheau
• 03:42   Re: surrogate key or not? Iain
• 04:07   Re: surrogate key or not? Kenneth Gonsalves
• 12:20   Re: surrogate key or not? Karsten Hilbert
• 12:20   Re: surrogate key or not? Karsten Hilbert

29 July 2004

• 01:08   Re: hey tgl@sss.pgh.pa.us
• 15:40   Issue with plpgsql trigger ohmy9od@yahoo.com (Oeln)
• 15:44   Re: next integer in serial key 
• 15:45   Re: Issue with plpgsql trigger ohmy9od@yahoo.com (Oeln)
• 15:51   PSQL Syntax errors running PL/SQL scripts Oleg Konovalov
• 21:05   Re: Table and/or Database Creation Time Kemin Zhou
• 21:14   Re: C++ interface problem with libpq.so.3 Kemin Zhou

30 July 2004

• 18:46   How to create an aggregate? Ray Aspeitia

31 July 2004

• 00:50   Re: How to create an aggregate? Tom Lane