Peripheral Links

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

pgsql-general - November 2003

2003-11-01

• Re: [OT] Choosing a scripting language. Martijn van Oosterhout (00:25)
• Re: slow query performance Martijn van Oosterhout (00:31)
• Re: problem with huge joins Martijn van Oosterhout (00:43)
• PostgreSQL License Question Ryan Mack (01:36)
• AS operator and subselect result names: PostgreSQL vs. Oracle Neil Zanella (04:44)
• Re: 7.3.5 release (was: Re: SELECT with row>32k hangs over Bruce Momjian (04:56)
• How to set up a table where 2 columns together must be unique? Scott Chapman (06:03)
• Re: How to set up a table where 2 columns together must be unique? Dann Corbit (06:19)
• Re: regular backups - super user Paul Thomas (12:13)
• Re: PG_RESTORE/DUMP Question Alex (13:20)
• Re: Best Perl Option? Network Administrator (13:22)
• Re: PG_RESTORE/DUMP Question Martijn van Oosterhout (13:33)
• Re: ALTER Table (another) Network Administrator (13:56)
• Re: database speed Network Administrator (14:13)
• Re: regular backups - super user Joshua D. Drake (16:21)
• Re: grant all to database inheritence Bruno Wolff III (16:37)
• Re: regular backups - super user Bruno Wolff III (17:27)
• Re: [SQL] connectby George Essig (18:38)
• Re: Versioning control in PostgreSQL? elein (21:22)
• Re: 7.3.5 release (was: Re: SELECT with row>32k hangs over Lynn.Tilby (23:23)

2003-11-02

• IF EXISTS? Henrik W. Hansen (10:52)
• Re: Where are the database files located? Simon Stiefel (16:43)
• Re: Perl and Postgres Will Trillich (17:18)
• Re: Constraint Problem Tom Lane (17:48)
• Re: PostgreSQL License Question Marc G. Fournier (20:59)
• Re: Custom types and arrays mlunnon @ RWA (21:02)
• Re: AS operator and subselect result names: PostgreSQL Peter Eisentraut (21:10)
• Re: retrieve statement from catalogs Jaime Casanova (21:31)
• Re: AS operator and subselect result names: PostgreSQL vs. Oracle Tom Lane (21:34)
• Re: AS operator and subselect result names: PostgreSQL Stephan Szabo (22:16)
• Re: PostgreSQL License Question Tom Lane (22:22)

2003-11-03

• Re: Custom types and arrays Joe Conway (02:33)
• Re: Constraint Problem Ron St-Pierre (02:46)
• Re: slow query performance Alvaro Herrera (03:12)
• Please help CY (04:34)
• Re: Please help Ang Chin Han (06:06)
• [Fwd: [LIH]OpenOffice.org 1.1 <-> PostgreSQL connectivity] Shridhar Daithankar (06:46)
• Internet based database Russell Crosser (07:21)
• Re: PostgreSQL License Question Paul Thomas (09:18)
• How to use dblink within pl/pgsql function: Clive Page (09:57)
• Re: [Fwd: [LIH]OpenOffice.org 1.1 <-> PostgreSQL connectivity] Paul Thomas (10:07)
• Re: [Fwd: [LIH]OpenOffice.org 1.1 <-> PostgreSQL connectivity] Andreas Fromm (10:10)
• Re: [GENERAL] [Fwd: [LIH]OpenOffice.org 1.1 <-> PostgreSQL connectivity] Richard Huxton (11:39)
• plpgsql question Jennifer Lee (12:58)
• slow down on UPDATE using IN statements MaRcElO PeReIrA (13:52)
• Re: slow down on UPDATE using IN statements Martijn van Oosterhout (14:09)
• question Alexandr S (15:27)
• Re: slow down on UPDATE using IN statements Stephan Szabo (15:28)
• Re: insert data of composite type Greg Stark (15:28)
• Re: slow down on UPDATE using IN statements mallah (15:34)
• Re: Internet based database Stuart Johnston (15:36)
• Re: Internet based database mallah (15:50)
• Re: table locking.. FK tables locking on insert Jan Wieck (15:52)
• Re: slow down on UPDATE using IN statements mallah (15:53)
• Re: Help on update that subselects other records in table, uses joins Jeff Kowalczyk (16:57)
• Re: ALTER Table (another) Andrew Ayers (17:03)
• Re: foxpro to postgresql7.1 Josué Maldonado (17:05)
• Re: Fixed field text import Harald Fuchs (17:15)
• Re: Cartesian product bug? scott.marlowe (17:41)
• Re: INSERT performance Razvan Surdulescu (18:16)
• transposed query? javier garcia - CEBAS (18:23)
• Re: Constraint Problem Ron St-Pierre (18:35)
• Re: question Tom Lane (19:54)
• Re: Constraint Problem scott.marlowe (20:00)
• C functions quicker than Plpgsql? Martin Hart (20:00)
• Re: Constraint Problem Greg Stark (20:12)
• Re: Cartesian product bug? Greg Stark (20:21)
• Re: Constraint Problem Martin Marques (20:26)
• Re: C functions quicker than Plpgsql? Peter Eisentraut (20:38)
• Re: Help on update that subselects other records in table, uses joins Manfred Koizar (20:45)
• Query to pg_stat_activity Carmen Gloria Sepulveda Dedes (21:08)
• Re: Query to pg_stat_activity Tom Lane (21:19)
• Re: table locking.. FK tables locking on insert Stephan Szabo (23:34)
• Re: transposed query? Nick Barr (23:37)
• Re: table locking.. FK tables locking on insert Jan Wieck (23:39)
• Re: transposed query? Nick Barr (23:40)
• Re: Internet based database Karsten Hilbert (23:57)

2003-11-04

• Re: transposed query? Joe Conway (02:11)
• Re: plpgsql question Joe Conway (05:40)
• Re: How to use dblink within pl/pgsql function: Joe Conway (05:59)
• Foreign Key to Inherited table Greg Hulands (06:24)
• Re: Please help Ang Chin Han (06:50)
• Using SUBSELECT in CHECK expressions Najib Abi Fadel (09:01)
• Obtain boolean value of expression in PLPGSQL Max Speransky (10:06)
• now() problem Hijax (10:25)
• SELECT question Alex (10:54)
• Re: Obtain boolean value of expression in PLPGSQL Richard Huxton (11:12)
• Re: SELECT question Richard Huxton (11:14)
• Re: Obtain boolean value of expression in PLPGSQL Martin Hart (11:17)
• pg7.3.4: pg_atoi: zero-length string Rob Fielding (11:21)
• Re: pg7.3.4: pg_atoi: zero-length string Andrew Sullivan (11:32)
• Re: pg7.3.4: pg_atoi: zero-length string Markus Wollny (11:46)
• Very strange selectproblem Victor Spång Arthursson (12:10)
• Re: pg7.3.4: pg_atoi: zero-length string Rob Fielding (12:19)
• Re: Very strange selectproblem Francois Suter (12:31)
• Re: Very strange selectproblem Csaba Nagy (12:32)
• Re: pg7.3.4: pg_atoi: zero-length string Bruno Wolff III (13:19)
• Re: pg7.3.4: pg_atoi: zero-length string Rob Fielding (13:26)
• Databases with different encodings Jan Poslusny (13:37)
• Re: Databases with different encodings Peter Eisentraut (13:54)
• Problem with Pg_dumpall Edwin Quijada (14:03)
• Re: Obtain boolean value of expression in PLPGSQL Pavel Stehule (14:11)
• Re: pg7.3.4: pg_atoi: zero-length string Andrew Sullivan (14:18)
• PostgreSQL v7.4 Release Candidate 1 Marc G. Fournier (15:06)
• Re: Problem with Pg_dumpall Tom Lane (15:16)
• Re: pg7.3.4: pg_atoi: zero-length string Rob Fielding (15:18)
• Re: Constraint Problem Ron St-Pierre (16:39)
• question Alexandr S (16:50)
• Re: PostgreSQL v7.4 Release Candidate 1 Network Administrator (16:56)
• Re: Constraint Problem Csaba Nagy (16:59)
• Re: PostgreSQL v7.4 Release Candidate 1 Vivek Khera (17:03)
• Re: PostgreSQL v7.4 Release Candidate 1 Dennis Gearon (17:24)
• Re: Constraint Problem Stephan Szabo (17:40)
• Re: PostgreSQL v7.4 Release Candidate 1 Marc G. Fournier (17:40)
• Re: PostgreSQL v7.4 Release Candidate 1 Marc G. Fournier (17:41)
• Re: PostgreSQL v7.4 Release Candidate 1 Peter Eisentraut (17:44)
• Re: Constraint Problem Greg Stark (17:45)
• Re: PostgreSQL v7.4 Release Candidate 1 Peter Eisentraut (17:53)
• Re: PostgreSQL v7.4 Release Candidate 1 Joseph Shraibman (17:56)
• Re: Help on update that subselects other records in table, uses joins Michael Glaesemann (17:58)
• Re: PostgreSQL v7.4 Release Candidate 1 Uwe C. Schroeder (18:22)
• Re: Constraint Problem Ron St-Pierre (18:25)
• Re: PostgreSQL v7.4 Release Candidate 1 Martin Marques (18:51)
• Re: Constraint Problem Alvaro Herrera (19:03)
• Re: Constraint Problem Greg Stark (19:10)
• Re: PostgreSQL v7.4 Release Candidate 1 Peter Eisentraut (19:13)
• Re: Constraint Problem Jan Wieck (19:15)
• Re: PostgreSQL v7.4 Release Candidate 1 Martin Marques (19:24)
• Re: PostgreSQL v7.4 Release Candidate 1 Martin Marques (19:30)
• Re: Constraint Problem Ron St-Pierre (19:30)
• Re: PostgreSQL v7.4 Release Candidate 1 Joshua D. Drake (19:36)
• Re: PostgreSQL v7.4 Release Candidate 1 Larry Rosenman (19:42)
• Re: Constraint Problem Greg Stark (19:59)
• Re: SELECT question Brent Wood (20:20)
• Re: Using SUBSELECT in CHECK expressions Stephan Szabo (21:19)
• Re: Foreign Key to Inherited table Stephan Szabo (21:21)
• Re: Using SUBSELECT in CHECK expressions Tom Lane (21:26)
• Re: SELECT question Alvaro Herrera (21:34)
• Re: INSERT performance Tom Lane (21:35)
• Re: INSERT performance Razvan Surdulescu (22:57)
• Re: SELECT question Jan Wieck (23:25)

2003-11-05

• Re: PostgreSQL v7.4 Release Candidate 1 ljb (00:50)
• access linux command from SQL Query Alam Surya (02:46)
• Calculating default values on insert? Robin Munn (03:51)
• Changes in Rel. 7.4 Alex (04:27)
• Re: Changes in Rel. 7.4 Dolly (04:47)
• Re: Changes in Rel. 7.4 Bruno Wolff III (06:06)
• Re: access linux command from SQL Query Mike Mascari (06:20)
• Re: Database design question: ugliness or referential integrity? Jaime Casanova (07:46)
• select/update performance? Bjørn T Johansen (09:24)
• Re: Help on update that subselects other records in table, uses joins Manfred Koizar (09:25)
• Re: select/update performance? Rob Fielding (09:42)
• Re: select/update performance? Bjørn T Johansen (09:49)
• Re: How to use dblink within pl/pgsql function: Clive Page (10:02)
• Re: select/update performance? Csaba Nagy (10:04)
• SET AUTOCOMMIT OFF Thierry Missimilly (10:21)
• Re: select/update performance? Richard Huxton (10:31)
• Re: question Richard Huxton (10:33)
• Re: select/update performance? Rob Fielding (10:46)
• Matlab Mex Interface Paul Olamba (10:59)
• Re: select/update performance? Bjørn T Johansen (11:02)
• How to know column constraints via system catalog tables Damon (11:41)
• System crash and trying to run vacuum getting errors Dave Smith (14:21)
• Re: How to know column constraints via system catalog tables Damon (14:29)
• How to store pg_constraint's int2[] data type in C++ Damon (14:34)
• Re: PostgreSQL v7.4 Release Candidate 1 Tom Lane (14:59)
• Re: SET AUTOCOMMIT OFF Tom Lane (15:20)
• Re: Help on update that subselects other records in table, uses joins Michael Glaesemann (15:50)
• Re: System crash and trying to run vacuum getting errors Tom Lane (16:30)
• Re: System crash and trying to run vacuum getting errors Dave Smith (16:33)
• Getting time from date field Alejandro Javier Pomeraniec (17:12)
• Re: Using SUBSELECT in CHECK expressions Michael Glaesemann (17:14)
• Re: System crash and trying to run vacuum getting errors Tom Lane (17:22)
• Re: System crash and trying to run vacuum getting errors Greg Stark (17:34)
• Re: Using SUBSELECT in CHECK expressions Tom Lane (17:38)
• invalid command \ Jan Poslusny (17:42)
• Re: Using SUBSELECT in CHECK expressions Michael Glaesemann (17:49)
• 7.4 is great! Oliver Siegmar (18:08)
• Re: Using SUBSELECT in CHECK expressions Tom Lane (18:12)
• Re: Using SUBSELECT in CHECK expressions Michael Glaesemann (18:25)
• Database Design & Application Server Design Lane Beneke (19:42)
• Question on database structure Simon Stiefel (19:56)
• tsearch2 and gist index bloat George Essig (20:27)
• Re: Getting time from date field Bruno Wolff III (20:47)
• Multi-master asynchronous replication Chris M. Gamble (20:57)
• Re: Multi-master asynchronous replication Marc G. Fournier (21:21)
• Re: tsearch2 and gist index bloat George Essig (21:24)
• Re: SET AUTOCOMMIT OFF Kathy Zhu (21:26)
• Re: Multi-master asynchronous replication Andrew Sullivan (21:55)
• Select for update and locking problem Steve Crawford (22:08)
• SQL_ASCII encoding CSN (22:26)
• Re: SQL_ASCII encoding Tom Lane (22:42)

2003-11-06

• Re: Question on database structure Gaetano Mendola (00:36)
• [No subject] sgupta5 (00:44)
• Re: tsearch2 and gist index bloat Joshua D. Drake (01:18)
• Re: Getting time from date field Alvaro Herrera (01:34)
• Re: pgtcl patch, lost messages? / was: PostgreSQL v7.4 Release Candidate 1 ljb (01:40)
• PostgreSQL v7.4 Release Candidate 1 compile errors Martin Marques (02:43)
• [No subject] sgupta5 (02:44)
• Re: PostgreSQL v7.4 Release Candidate 1 compile errors Tom Lane (03:39)