Home > mailing lists

Mailing lists [pgsql-sql]

1 March 2002

10:20 Re: GROUPing by expressions, and subSELECTs Shane Wright
11:59 sub SELECT Charles Hauser
12:04 Re: Removing duplicates gnews84@hotmail.com (OV)
12:07 Urgent, Many-to-many relationships.....HELP!!!! Dalton Shane
12:28 Re: Urgent, Many-to-many relationships.....HELP!!!! Dan Langille
12:57 About persistent connections... David BOURIAUD (by way of David BOURIAUD
13:38 About persistent connections... David BOURIAUD
14:16 Re: About persistent connections... Gary Stainburn
14:30 LIMIT and OFFSET Samuel J. Sutjiono
15:41 Re: About persistent connections... Josh Berkus
15:46 Re: sub SELECT Josh Berkus
17:58 sequential joins Oleg Lebedev
18:29 Re: sequential joins Josh Berkus
20:23 Re: sequential joins Oleg Lebedev
21:15 Re: sequential joins Josh Berkus
21:23 Re: sequential joins Oleg Lebedev
21:43 Re: sequential joins Tom Lane

6 March 2002

08:49 Re: getting pid of backend Laszlo Tibor
12:00 inserting arrays from plpgsql. Bhuvan A
12:18 assigning values to arrays in plpgsql Bhuvan A
13:32 simple problem Daniel Ordobas Bortolas
16:24 SELECT currval within a transaction Frank Joerdens
17:10 Re: simple problem Stephan Szabo
17:42 Re: SELECT currval within a transaction Stephan Szabo
17:47 where not exists Llew
18:10 Re: simple problem Tom Lane
18:14 Re: simple problem PG Explorer
18:19 Fun with SQL Josh Berkus
18:29 Re: where not exists Jie Liang
18:29 Re: where not exists Josh Berkus
18:59 \d+ and \dd Thomas Good
20:43 Re: \d+ and \dd Greg Sabino Mullane

7 March 2002

07:51 Coalesce Get Duplicate Record Lonh SENG
08:36 How to grant a privilege on all tables or views or both of a database to someone? Eric Du
11:45 Re: [HACKERS] Uniqueness of rule, constraint, and trigger names Rod Taylor
12:00 PL/pgsql Ismail Bouabdallah
12:54 PL/pgSQL Syntax Problem Hubert Palme
12:56 Re: \d+ and \dd Thomas Good
12:58 confusing inheritance Andreas F.
14:25 Re: confusing inheritance Stephan Szabo
14:29 Re: PL/pgSQL Syntax Problem daq
17:33 Re: How to grant a privilege on all tables or views or both of a database to someone? Paul Ogden
18:18 7.0.3 pg_dump -> segmentation fault! george young
18:30 Re: 7.0.3 pg_dump -> segmentation fault! Stephan Szabo
18:31 Re: psql question Josh Berkus
18:43 Re: How to grant a privilege on all tables or views or both of a database to someone? Andrew G. Hammond
18:46 Fw: Re: 7.0.3 pg_dump -> segmentation fault! george young
18:59 Re: How to grant a privilege on all tables or views or both of a database to someone? Paul Ogden
20:25 Re: Fw: Re: 7.0.3 pg_dump -> segmentation fault! Tom Lane
23:33 Re: [NOVICE] Bad Query?? Extremely slow response Josh Berkus
23:33 Re: ERROR (Bug?) in RULE processing ? Bruce Momjian

8 March 2002

00:31 Re: psql question Christopher Kings-Lynne
05:02 URGENT! VIRUS ALERT Carlo Florendo
08:06 Re: [GENERAL] PL/pgSQL Syntax Problem rolf.ostvik@axxessit.no
13:08 problem with RECORD in a stored procedure Dalton Shane
14:16 Re: problem with RECORD in a stored procedure Stephan Szabo
16:05 Re: problem with RECORD in a stored procedure daq
17:00 Support for "nested sets" and PHP (Re: Recursive select) knut.suebert@web.de
17:57 Re: PL/pgsql PG Explorer
18:19 New user - creating function question TimothyReaves@westfieldgrp.com

11 March 2002

03:01 Case (in)sensitivity Roberto Mello
03:04 Re: Case (in)sensitivity Christopher Kings-Lynne
03:14 Re: Case (in)sensitivity Peter Eisentraut
05:24 Re: Case (in)sensitivity Joel Burton
06:30 Operator ~ on type aclitem in pgsql 7.2 karin probost
12:41 Timestamp with time zone problem Aguinaldo Fagundes Junior
17:47 Pg_dump Hunter, Ray
19:40 Re: Pg_dump knut.suebert@web.de
23:24 SELECT FOR UPDATE feblec@ig.com.br

12 March 2002

09:06 GRANT problem ? GRIMOIS Eric
09:57 Re: GRANT problem ? PGMailList
10:00 Re: GRANT problem ? D'Arcy J.M. Cain
10:19 in-date news items Gary Stainburn
15:26 Re: in-date news items Gary Stainburn
15:29 Re: in-date news items Andrew G. Hammond
16:00 Re: SELECT FOR UPDATE Andrew G. Hammond
16:00 Support for "nested sets" and PHP (Re: Recursive select) Culley Harrelson
16:03 Re: in-date news items Peter Eisentraut
16:23 Re: in-date news items Stephan Szabo
21:56 simple problem Daniel Ordobas Bortolas
21:56 function error: ERROR: fmgr_info: function 56664:cache lookup failed Ismail Bouabdallah
22:03 Re: PL/pgSQL Syntax Problem hubert.palme@web.de (Hubert Palme)

13 March 2002

00:23 to unsubcribe? Ivan Manuel Andrade Muñoz
04:10 [INIMSS] How to foreign key Dino Cherian K
04:57 Re: [INIMSS] How to foreign key Stephan Szabo
07:37 Large data sets and FOR LOOP's Bo Lorentsen
08:51 REFERENCES Andre Schubert
09:05 Re: REFERENCES Laszlo Tibor
09:26 Jean-Christophe FABRE
09:49 [INIMSS] How to use OID? Dino Cherian K
10:17 Re: REFERENCES Andre Schubert
11:24 Re: simple problem Hano de la Rouviere
11:26 createlang pltclu W. McCloud
11:29 Re: where not exists Llew
11:29 Re: where not exists Llew
11:52 subquery involving 'now' jmycr@cs.com
13:10 REFERENCES Andre Schubert
13:21 Re: Large data sets and FOR LOOP's Tom Lane
13:23 ALTER CONSTRAINT FOREIGN KEY Charles Hauser
13:47 Help reqd: Copying char to date rjb26@hotmail.losethis.nothere.com
13:54 Retrieving a ' in an SQL statement? jdou12345@aol.com (Jdou12345)
14:21 Re: Help reqd: Copying char to date rjb26@hotmail.losethis.nothere.com
14:32 'now' problem jmycr@cs.com
14:53 Re: REFERENCES Stephan Szabo
15:00 Re: ALTER CONSTRAINT FOREIGN KEY Stephan Szabo
15:03 Re: subquery involving 'now' Gaetano Mendola
15:14 Re: Large data sets and FOR LOOP's Bo Lorentsen
15:40 Re: [INIMSS] How to use OID? Josh Berkus
15:54 Re: REFERENCES Jan Wieck
16:02 Re: subquery involving 'now' Stephan Szabo
16:53 Referential integrity implementation - bug or user error? msn
16:53 Re: PL/pgsql adm
16:56 Re: Line Numbering in SELRCT Output Paul
16:58 Re: Help reqd: Copying char to date Stephan Szabo
17:01 Casting Graham Vickrage
17:08 Calling a trigger from a trigger Mike Finn
17:28 how to know if you are granted on a table? Jean-Christophe FABRE
18:04 Re: Large data sets and FOR LOOP's Jan Wieck
18:20 Re: SELECT FOR UPDATE Florian Weimer
18:21 Re: Line Numbering in SELRCT Output Hubert Palme
18:21 Re: in-date news items Ian Barwick
18:34 Re: where not exists Dag Arne Matre
18:40 Re: in-date news items Ian Barwick
18:45 Re: to unsubcribe? Serguei Mokhov
19:08 Line Numbering in SELRCT Output Hubert Palme
19:18 Re: Referential integrity implementation - bug or user error? missive@frontiernet.net (Lee Harr)
19:21 Re: Casting PG Explorer
19:22 Re: Referential integrity implementation - bug or user error? Stephan Szabo
20:45 Re: Casting Tom Lane
23:20 Re: Line Numbering in SELRCT Output Stephan Szabo
23:44 Re: [INIMSS] How to use OID? Christopher Kings-Lynne

14 March 2002

00:13 Re: Christopher Kings-Lynne
00:43 Re: [INIMSS] How to use OID? Herbert Rabago Ambos
03:45 checking for existence of a table in plpgsql. Bhuvan A
05:58 Re: Large data sets and FOR LOOP's Bo Lorentsen
06:06 Re: checking for existence of a table in plpgsql. Bo Lorentsen
13:35 Re: Large data sets and FOR LOOP's Jan Wieck
13:56 Re: Large data sets and FOR LOOP's Bo Lorentsen
14:28 Re: checking for existence of a table in plpgsql. Roberto Mello
14:48 unable to log Jie Liang
15:36 Syslog Jie Liang
16:48 Re: [ADMIN] Syslog Joe Conway
16:52 Re: [ADMIN] Syslog Jie Liang
17:06 Re: [ADMIN] Syslog Dan Langille
17:27 Re: [ADMIN] Syslog Joe Conway
18:12 Re: [ADMIN] Syslog Jie Liang
19:17 Re: [ADMIN] Syslog Oliver Elphick
21:35 Re: [ADMIN] Syslog Larry Rosenman
22:04 Re: [ADMIN] Syslog Tom Lane

15 March 2002

02:35 Boolean test Rudi Starcevic
02:57 Re: Boolean test Christopher Kings-Lynne
03:06 Re: Boolean test Peter Eisentraut
12:27 R: [GENERAL] UPDATE and SELECT result difference Enrico Mangano
14:52 Btree index extension question Dmitry Tkach
15:07 Re: Btree index extension question Tom Lane
16:03 Re: Btree index extension question Dmitry Tkach
16:06 Why is it not using an index? Dmitry Tkach
16:06 Re: Why is it not using an index? (small correction) Dmitry Tkach
16:17 JDBC for J2ME Frederick Klauschen
16:18 Re: Why is it not using an index? Stephan Szabo
16:54 Re: JDBC for J2ME Josh Berkus
19:42 Re: [GENERAL] Btree index extension question Dmitry Tkach
20:08 Re: [GENERAL] Btree index extension question Dmitry Tkach
20:13 PL/pgSQL question Dmitry Tkach
22:21 Re: [GENERAL] Btree index extension question Dmitry Tkach
22:35 Debugging C functions... Dmitry Tkach

16 March 2002

03:36 Re: Debugging C functions... Dima Tkach
07:22 Re: simple problem Masaru Sugawara
16:28 hashtext function disappears in 7.2? george young
19:58 Variable Substitution for table name Samuel J. Sutjiono
20:07 why the big difference on this explain analyze? Dan Langille
20:20 Re: why the big difference on this explain analyze? Tom Lane
20:23 Re: why the big difference on this explain analyze? Dan Langille
22:08 Re: [GENERAL] Variable Substitution for table name Stephan Szabo
22:18 Re: why the big difference on this explain analyze? Dan Langille

17 March 2002

01:58 Re: Btree index extension question Christopher Kings-Lynne
02:03 Re: Btree index extension question Dima Tkach
22:57 Re: Boolean test Rudi Starcevic

18 March 2002

11:18 Creative use of CASE in a GROUP BY clause Dorian Taylor
13:56 Re: Creative use of CASE in a GROUP BY clause Masaru Sugawara
20:51 Re: Line Numbering in SELRCT Output Stephan Szabo
21:20 Re: hashtext function disappears in 7.2? Bruce Momjian

19 March 2002

06:26 create function problem Kancha .
06:36 Re: create function problem Matteo Beccati
08:04 Re: create function problem Kancha .
11:22 optimizer tuning/forcing correct index use Kelly Burkhart
12:27 Re: create function problem Jan Wieck
15:12 Re: optimizer tuning/forcing correct index use Kelly Burkhart
15:32 Re: optimizer tuning/forcing correct index use Tom Lane
16:04 How to create crude report with psql and/or plpgsql Jean-Luc Lachance
16:21 Re: How to create crude report with psql and/or plpgsql Andrew G. Hammond
16:29 Re: How to create crude report with psql and/or plpgsql Jean-Luc Lachance
16:46 Re: How to create crude report with psql and/or plpgsql Andrew G. Hammond
16:49 Re: optimizer tuning/forcing correct index use Tom Lane
17:05 Re: optimizer tuning/forcing correct index use Kelly Burkhart
17:19 Re: How to create crude report with psql and/or plpgsql Bruce Momjian
17:31 Re: How to create crude report with psql and/or plpgsql Jean-Luc Lachance
17:32 Re: How to create crude report with psql and/or plpgsql Bruce Momjian
17:49 Re: How to create crude report with psql and/or plpgsql Jean-Luc Lachance
18:28 How to use an array string Samuel J. Sutjiono
18:43 Re: [GENERAL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance
19:50 Re: How to create crude report with psql and/or plpgsql Roberto Mello
20:15 Re: How to create crude report with psql and/or plpgsql Ross J. Reedstrom
20:42 Re: How to create crude report with psql and/or plpgsql Peter Eisentraut

20 March 2002

01:29 What is Syntax for multiple FULL OUTER JOINS? Patrick Hatcher
02:08 Re: What is Syntax for multiple FULL OUTER JOINS? Stephan Szabo
11:41 Re: where not exists Llew Sion Goodstadt
11:56 optimizer tuning/forcing correct index use Kelly Burkhart
11:57 few admin questions Laurent N
12:02 Re: R: [GENERAL] UPDATE and SELECT result difference Jean-Luc Lachance
12:07 Btree index extension question Dmitry Tkach
12:18 How do I set the system time on production server? Ken Corey
13:45 plpgsql how to iterate through record values? german pulido
14:04 Re: [GENERAL] How to create crude report with psql and/or plpgsql Jeff Eckermann
14:34 Re: How do I set the system time on production server? Marin Dimitrov
14:40 Re: How do I set the system time on production server? Stephan Szabo
14:41 Re: How do I set the system time on production server? Ross J. Reedstrom
15:00 Re: How do I set the system time on production server? Ian Barwick
15:13 Re: How do I set the system time on production server? Oliver Elphick
15:16 Re: What is Syntax for multiple FULL OUTER JOINS? Patrick Hatcher
15:46 Re: How do I set the system time on production server? Peter Eisentraut
20:46 delete -> copy in -> WAL problem..? Mike Biamonte
21:40 Migrating a MySQL schema with an enum Keith Gray
21:41 Re: How do I set the system time on production server? Andrew G. Hammond
21:54 Re: Migrating a MySQL schema with an enum Bruce Momjian
21:59 Re: Migrating a MySQL schema with an enum Peter Eisentraut

21 March 2002

00:31 Re: Migrating a MySQL schema with an enum Christopher Kings-Lynne
02:42 Re: delete -> copy in -> WAL problem..? Tom Lane
02:47 Re: Migrating a MySQL schema with an enum Peter Eisentraut
09:31 Re: Migrating a MySQL schema with an enum Martín Marqués
09:43 Re: Migrating a MySQL schema with an enum Martín Marqués
09:47 [OOT] timestamp / time ('now') in postgresql 7.2? Johny Jugianto
12:29 Re: [OOT] timestamp / time ('now') in postgresql 7.2? Christopher Kings-Lynne
12:48 Re: Migrating a MySQL schema with an enum Vincent Stoessel
14:02 Re: Migrating a MySQL schema with an enum Ross J. Reedstrom
15:21 Sequence not updated after a copy ? GRIMOIS Eric
17:01 Re: Sequence not updated after a copy ? Oliver Elphick
17:43 A general database question! Dmitry Tkach
18:13 A bug in gistPageAddItem()/gist_tuple_replacekey() ??? Dmitry Tkach
18:34 Re: Sequence not updated after a copy ? Jeff Eckermann
23:59 Re: Sequence not updated after a copy ? Christopher Kings-Lynne

22 March 2002

09:19 Re: Migrating a MySQL schema with an enum Martín Marqués
10:43 How to return more than one variable from PgPlSQL procedure? Ivan Babikov
14:23 Re: How to return more than one variable from PgPlSQL procedure? Richard Huxton

23 March 2002

14:10 false No rows returned error Jim Martinez
15:14 Re: false No rows returned error Tom Lane
15:35 Re: false No rows returned error Dan Langille
15:38 Re: false No rows returned error Dan Langille
16:17 Binary data in bytea field Iklódi Lajos
16:34 Re: false No rows returned error Jim Martinez
16:49 Re: Binary data in bytea field Joe Conway
21:18 Re: Binary data in bytea field Iklódi Lajos
21:27 Re: Binary data in bytea field Joe Conway

25 March 2002

01:37 About temporary table jack
01:42 About EXECUTE in pl/pgsql jack
01:54 Re: About temporary table Bruce Momjian
01:55 Re: About EXECUTE in pl/pgsql Bruce Momjian
02:11 Re: About temporary table jack
02:15 Re: About temporary table Dan Langille
02:39 Re: [ADMIN] no drop column?! Dan Langille
02:52 Re: [ADMIN] no drop column?! Serguei Mokhov
02:56 Re: [ADMIN] no drop column?! Dan Langille
05:45 Re: About EXECUTE in pl/pgsql Tom Lane
08:05 Declaring arrays in plpgsql functions Daniel Lundin
08:18 Re: About temporary table jack
08:38 Re: About EXECUTE in pl/pgsql jack
08:38 call the same pl/pgsql procedure twice in the same connection session jack
09:29 Re: Recursive functions aren't possible, are they? Ivan Babikov
09:29 Recursive functions aren't possible, are they? Ivan Babikov
11:42 posting rules andrew lahser
13:15 Re: posting rules Dan Langille
13:34 Re: [ADMIN] no drop column?! Joel Burton
14:29 Re: posting rules Stephan Szabo
14:51 16 parameter andrew lahser
16:11 Re: 16 parameter Marin Dimitrov
17:39 Re: Declaring arrays in plpgsql functions Tom Lane
17:43 Re: Declaring arrays in plpgsql functions Tom Lane
18:13 Cleaning up template 1 Josh Berkus
18:18 Re: Declaring arrays in plpgsql functions Daniel Lundin
18:18 quickest query to check a table for existance of a value in a field Shane Wright
18:53 Re: Cleaning up template 1 Thomas Swan
18:57 Re: Cleaning up template 1 Thomas Good
18:57 Re: Cleaning up template 1 -> template0 cloning Thomas Good
18:58 Re: About EXECUTE in pl/pgsql Bruce Momjian
19:04 Re: About EXECUTE in pl/pgsql Tom Lane
19:05 Re: About temporary table Bruce Momjian
19:06 Re: call the same pl/pgsql procedure twice in the same connection Bruce Momjian
19:16 Re: Cleaning up template 1 Thomas Swan
19:17 Re: 16 parameter Bruce Momjian
19:24 Re: About EXECUTE in pl/pgsql Bruce Momjian
19:42 Re: quickest query to check a table for existance of a value in a field chester c young
19:46 Re: call the same pl/pgsql procedure twice in the same connection Jan Wieck
22:35 Re: call the same pl/pgsql procedure twice in the same connection Tom Lane

26 March 2002

06:13 Arrays Design Question Achilleus Mantzios
10:00 C Function with Arrays Question Achilleus Mantzios
11:51 Re: Cleaning up template 1 Arguile
12:17 Re: Cleaning up template 1 Arguile
14:44 Re: Arrays Design Question Josh Berkus
14:46 Re: Cleaning up template 1 Josh Berkus
16:25 Possible to do this in one query? John Oakes
17:48 Changeing Sequence Peter Atkins
18:12 Re: Changeing Sequence Stephan Szabo
18:12 Re: Changeing Sequence Dan Langille
18:17 Re: Changeing Sequence PG Explorer
18:33 Re: Changeing Sequence PG Explorer
21:56 Re: quickest query to check a table for existance of a value in a field Shane Wright

27 March 2002

00:30 resetting sequence Kancha .
01:09 Re: Possible to do this in one query? Ian Barwick
03:30 Re: resetting sequence Philip Hallstrom
05:22 Re: Arrays Design Question Achilleus Mantzios
10:01 Non-use of index ? Peter Galbavy
10:23 Problem how to combine to two tables Torsten Willrich
12:58 Re: Possible to do this in one query? Andrew G. Hammond
13:07 Re: resetting sequence Andrew G. Hammond
13:23 Re: Problem how to combine to two tables Andrew G. Hammond
13:45 Re: Problem how to combine to two tables Masaru Sugawara
13:51 Re: Non-use of index ? Tom Lane
18:00 function error Travis Hoyt
18:06 Re: function error PG Explorer
18:11 Re: function error Travis Hoyt
18:30 Re: function error Jan Wieck
18:37 Re: function error Stephan Szabo
23:49 psql and password Rudi Starcevic

28 March 2002

03:08 Re: psql and password Rudi Starcevic
03:56 Database / table sizeof Rudi Starcevic
04:06 Re: Database / table sizeof Christopher Kings-Lynne
04:29 Re: Database / table sizeof Rudi Starcevic
04:58 create view problem Mathieu Arnold
05:04 Re: create view problem Christopher Kings-Lynne
05:11 Re: psql and password Oliver Elphick
11:01 Left outer join with WHERE clause? DI Hasenöhrl
11:22 Re: Left outer join with WHERE clause? Dan Langille
11:54 Re: Left outer join with WHERE clause? DI Hasenöhrl
13:34 Re: Left outer join with WHERE clause? DI Hasenöhrl
13:35 Re: function error Jeff Eckermann
13:52 Re: function error Travis Hoyt
16:36 Table constraints Oleg Lebedev
16:36 Re: Left outer join with WHERE clause? Josh Berkus
17:14 Re: Table constraints Stephan Szabo
18:14 Re: Table constraints Oleg Lebedev
18:37 Re: Table constraints Stephan Szabo

29 March 2002

14:09 Optimization Advice Hunter, Ray
20:04 dead session terminate Jie Liang
21:09 system tables Jie Liang
21:13 Re: system tables Bruce Momjian
21:19 Re: system tables Jie Liang
22:28 Re: system tables Stephan Szabo