Peripheral Links

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

pgsql-sql - April 2001

April 1, 2001

• Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP Tom Lane (00:14)
• Re: Vacuum Error Tom Lane (00:18)
• Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP Tom Lane (00:53)
• Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP Bruce Momjian (00:58)
• Trigger Function and Html Output Stef Telford (07:50)
• ON DELETE rule J.Fernando Moyano (08:09)
• Re: Trigger Function and Html Output Richard Huxton (16:35)
• Re: Trigger Function and Html Output Stef Telford (17:21)
• Re: ON DELETE rule Tom Lane (19:34)

April 2, 2001

• RE: [HACKERS] Error in the date field (with NULL value...).Thanks! Christopher Kings-Lynne (01:31)
• very very slow ..... J.Fernando Moyano (02:44)
• Re: Trigger Function and Html Output Christopher Masto (03:17)
• passing parameters between forms Sharmad Naik (07:22)
• Re: Trigger Function and Html Output Richard Huxton (08:43)
• Calling functions inside a function: behavior Edipo Elder Fernandes de Melo (11:50)
• Re: passing parameters between forms Richard Huxton (12:14)
• Re: Calling Java from psql (was Re: requesting help) Peter T Mount (13:17)
• Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP Bruce Momjian (15:07)
• Re: Calling functions inside a function: behavior Roberto Mello (15:07)
• Sql error comp (15:09)
• Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP Peter Eisentraut (15:15)
• Re: Error:TypeCreate: type links already defined Richard Huxton (16:38)
• Re: Indexes vs indices Tom Lane (16:47)
• Re: Indexes vs indices Bruce Momjian (16:58)
• Fwd: Calling functions inside a function: behavior Josh Berkus (17:20)
• Re: Re: Indexes vs indices Lamar Owen (17:20)
• Can anyone explain how this works? RbrtBrn3 (18:01)
• Re: Fwd: Calling functions inside a function: behavior edipoelder (20:47)
• using for rec inside a function: behavior very slow Jie Liang (22:10)

April 3, 2001

• select statement inside a function: behavior bad Jie Liang (00:04)
• Re: using for rec inside a function: behavior very slow Tom Lane (01:16)
• Re: very very slow ..... Tom Lane (01:19)
• Appropriate indices to create for these queries Gerald Gutierrez (01:49)
• passing null parameter to plpgsq functions Picard, Cyril (07:00)
• Re: Appropriate indices to create for these queries Richard Huxton (08:03)
• Re: passing null parameter to plpgsq functions Richard Huxton (08:05)
• RE: passing null parameter to plpgsq functions Picard, Cyril (09:39)
• Re: passing null parameter to plpgsq functions Richard Huxton (11:51)
• Re: serial type; race conditions postgresql (13:33)
• Error:TypeCreate: type links already defined Najm Hashmi (14:20)
• pg_dumpall and password access Christophe Labouisse (22:47)
• Re: pg_dumpall and password access Tom Lane (23:29)
• Re: Implicit/Explicit casting of the unknown type Stephen Jackson (23:45)

April 4, 2001

• Re: Implicit/Explicit casting of the unknown type Josh Berkus (03:34)
• Inserting binary data (BLOBs) in v7.1 David Lizano (09:05)
• Re: pg_dumpall and password access J.H.M. Dassen Ray (09:07)
• Re: pg_dumpall and password access David Lizano (09:32)
• performance of functions - or rather lack of it Peter Galbavy (10:12)
• Re: performance of functions - or rather lack of it Peter Galbavy (10:48)
• restoring indices Koen Antonissen (11:01)
• outer joins Algirdas Šakmanas (11:03)
• Historical dates in Timestamp Albert REINER (11:04)
• max( bool )? Cedar Cox (12:32)
• Re: outer joins tjk@tksoft.com (14:22)
• Re: outer joins Poet/Joshua Drake (14:49)
• [7.0.3] optimizing a LIKE query ... The Hermit Hacker (14:59)
• RE: outer joins Picard, Cyril (15:01)
• Re: max( bool )? Tom Lane (15:16)
• Query broken under 7.1RC2 Kyle (15:24)
• Strategy for unlocking query Graham Vickrage (15:34)
• Re: Query broken under 7.1RC2 Tom Lane (15:54)
• Re: Strategy for unlocking query Tom Lane (16:07)
• Re: Historical dates in Timestamp Tom Lane (16:36)
• Re: performance of functions - or rather lack of it Tom Lane (17:01)
• Memory and performance edipoelder (17:15)
• Need to do an ALTER TABLE. jkakar (17:57)
• Memory exhaustion Srikanth Rao (18:45)
• [pgsql-general] Baffling Performance Poet/Joshua Drake (18:53)
• Re: Need to do an ALTER TABLE. Tom Lane (18:55)
• searching for dates Birgit Jansen (19:27)
• Re: searching for dates Oliver Elphick (20:14)
• Re: Memory exhaustion J.H.M. Dassen Ray (20:33)
• Re: Memory and performance Richard Huxton (20:34)
• UNION in a VIEW? Gordon A. Runkle (20:47)
• Re: max( bool )? Cedar Cox (22:02)
• Re: max( bool )? Tom Lane (22:02)
• performance inconsistency Phuong Ma (22:12)
• Re: UNION in a VIEW? Tom Lane (22:13)
• Re: Memory and performance Edipo Elder Fernandes de Melo (22:15)
• Re: [SQL] performance inconsistency Tom Lane (22:47)
• Re: [7.0.3] optimizing a LIKE query ... Tom Lane (23:06)
• Re: Need to do an ALTER TABLE. Josh Berkus (23:07)
• Re: UNION in a VIEW? Josh Berkus (23:18)
• Re: UNION in a VIEW? Gordon A. Runkle (23:41)
• Re: UNION in a VIEW? Gordon A. Runkle (23:57)

April 5, 2001

• RE: RE: serial type; race conditions Gerald Gutierrez (00:24)
• Re: Memory and performance Tom Lane (01:53)
• [Tip] Using list-aggregates for faster batching Joel Burton (01:59)
• Index on View ? Keith Gray (04:18)
• Re: performance of functions - or rather lack of it Peter Galbavy (07:29)
• Re: Index on View ? Richard Huxton (08:45)
• SELECT ... FOR UPDATE Loïc Bourgeois (12:29)
• Re: Memory and performance Tim Perdue (12:52)
• Re: UNION in a VIEW? Gordon A. Runkle (13:30)
• Re: Re: UNION in a VIEW? Josh Berkus (14:29)
• Project Development Kyle (14:39)
• Re: Memory and performance Tom Lane (14:46)
• Re: Memory and performance Tim Perdue (14:57)
• Re: Re: UNION in a VIEW? Gordon A. Runkle (15:21)
• RE: RE: serial type; race conditions Jeff Eckermann (15:35)
• FW: RE: serial type; race conditions Jeff Eckermann (15:59)
• please help Loïc Bourgeois (16:14)
• Re: Project Development Joel Burton (16:24)
• Double-nesting quotes? Josh Berkus (18:48)
• Re: please help Peter Eisentraut (19:40)
• Re: Index on View ? Keith Gray (23:14)
• Re: Index on View ? Ian Harding (23:19)

April 6, 2001

• Re: very very slow ..... J.Fernando Moyano (00:36)
• get all online user? guard (02:52)
• Re: please help Loïc Bourgeois (07:19)
• help Loïc Bourgeois (07:49)
• Re: Index on View ? Richard Huxton (08:54)
• Casting numeric to text Hans-Jürgen Schönig (11:08)
• how to do this join ? juerg.rietmann (12:10)
• Aliasing on tables ... Hans-Jürgen Schönig (12:24)
• 7.1 out soon? lbottorff (14:05)
• Re: 7.1 out soon? The Hermit Hacker (14:33)
• Re: 7.1 out soon? The Hermit Hacker (14:34)
• Re: how to do this join ? Tom Lane (14:46)
• Re: how to do this join ? Peter Eisentraut (14:51)
• pg_dump and oid Richard (16:45)
• Does pg_dump stable on v7.0 Jie Liang (17:37)
• "row_count" reserved? Josh Berkus (23:32)

April 7, 2001

• Re: "row_count" reserved? Tom Lane (00:03)
• Memory And Performance Mark Kirkwood (03:31)
• Update Kyle (18:37)
• 7.1 grant/revoke speed Kyle (20:22)
• Need help with EXECUTE function Josh Berkus (21:09)

April 8, 2001

• Re: [GENERAL] Re: Permissons on database Louis-David Mitterrand (09:10)
• Re: Maybe a Bug, maybe bad SQL Louis-David Mitterrand (09:36)
• Re: Can anyone explain how this works? Joel Burton (09:50)
• Re: Casting numeric to text Peter Eisentraut (10:05)
• open and closed paths ... Hans-Jürgen Schönig (13:59)
• Re: open and closed paths ... Peter Eisentraut (21:15)
• Re: please help Cedar Cox (22:55)
• Re: Double-nesting quotes? Cedar Cox (23:03)
• Re: Casting numeric to text Cedar Cox (23:20)
• Re: Need help with EXECUTE function Cedar Cox (23:57)

April 9, 2001

• Re: open and closed paths ... Hans-Jürgen Schönig (08:02)
• install pgSQL 7.1 datactrl (08:10)
• create function Tomáš Nohejl (08:42)
• Re: Casting numeric to text Peter Eisentraut (15:57)
• Re: please help Peter Eisentraut (16:01)
• Re: Casting numeric to text Ross J. Reedstrom (16:26)
• pg_dump and BLOB Richard (16:49)
• Re: Casting numeric to text Peter Eisentraut (16:53)
• Re: Re: open and closed paths ... Peter Eisentraut (16:55)
• Re: Casting numeric to text Ross J. Reedstrom (17:02)
• Re: select substr??? Tim Johnson (17:05)
• Re: Re: select substr??? Peter Eisentraut (18:38)
• Sorting and then... Wei Weng (23:22)

April 10, 2001

• Inheritance Semantics Mark Butler (01:59)
• Re: Sorting and then... Roberto Mello (02:40)
• Re: Inheritance Semantics Bruce Momjian (03:00)
• problem with copy command Jaruwan Laongmal (08:14)
• Foreign Key between different databases Stan van de Mortel (08:53)
• RE: Sorting and then... Michael Ansley (09:30)
• Re: 7.1 out soon? Peter Peltonen (11:07)
• Copying null values Amanda Riera (12:17)
• The Momjian Tome / DBA Certification Thomas Good (12:26)
• Re: Copying null values Christof Glaser (14:21)
• Re: problem with copy command Joel Burton (15:36)
• Re: Re: select substr??? Albert REINER (16:38)
• Re: Sorting and then... Jason Earl (17:32)
• Semantics of Typed Numeric Constants Mark Butler (18:02)
• Re: \i command Joel Burton (18:37)
• a select statement that sometimes joins Mark Stosberg (19:13)
• Re: Re: \i command Joel Burton (19:14)
• Re: a select statement that sometimes joins Oliver Elphick (20:05)
• RE: Re: select substr??? Jeff Eckermann (22:41)
• RE: Re: select substr??? Jeff Eckermann (23:08)
• Re: [GENERAL] install pgSQL 7.1 datactrl (23:44)

April 11, 2001

• Re: Re: 7.1 out soon? The Hermit Hacker (00:58)
• Re: Foreign Key between different databases Cedar Cox (08:56)
• Re: problem with copy command George Moga (09:27)
• Savepoints Hans-Jürgen Schönig (10:09)
• Concatenate fields Amanda Riera (11:31)
• Re: problem with copy command Oliver Elphick (11:59)
• enumerating rows Kovacs Zoltan (12:02)
• Re: Concatenate fields Oliver Elphick (12:14)
• Re: Re: \i command cbell (13:05)
• Re: enumerating rows Poul L. Christiansen (13:29)
• Re: enumerating rows Kovacs Zoltan (14:37)
• \i command Najm Hashmi (15:07)
• RE: enumerating rows Koen Antonissen (15:56)
• Dropping users with no name Hans-Jürgen Schönig (16:29)
• Re: enumerating rows Kovacs Zoltan (16:43)
• Re: enumerating rows Oliver Elphick (16:46)
• Making SELECT COUNT(seed) FROM fast Gerald Gutierrez (17:58)
• Re: Re: \i command Najm Hashmi (18:16)
• Re: enumerating rows Josh Berkus (18:29)
• Re: Making SELECT COUNT(seed) FROM fast Peter Eisentraut (18:30)
• Problem in writing functions Kris (18:50)
• Re: enumerating rows Oliver Elphick (20:08)
• Re: enumerating rows Joel Burton (21:53)
• DB porting questions... Diehl, Jeffrey (23:02)
• RE: DB porting questions... Michael Ansley (23:29)
• Re: DB porting questions... Josh Berkus (23:29)
• Re: DB porting questions... Joel Burton (23:34)

April 12, 2001

• Timezone conversion Roberto Mello (02:08)