pgsql-general since 2003-11-03 00:00

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Nov. 3, 2003

Thread Author Time
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

Nov. 4, 2003

Thread Author Time
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

Nov. 5, 2003

Thread Author Time
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

Nov. 6, 2003

Thread Author Time
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
Problems with PLPGSQL Alex 04:13
Re: Problems with PLPGSQL Jason Godden 07:02
Sequences without blank holes MaRcElO PeReIrA 08:01
Re: Sequences without blank holes Peter Eisentraut 08:58
Re: PostgreSQL v7.4 Release Candidate 1 compile errors Peter Eisentraut 09:01
INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE COLUMNS Marco Lazzeri 09:11
Re: Sequences without blank holes Csaba Nagy 09:12
Re: Problems with PLPGSQL Richard Huxton 09:13
Re: Problems with PLPGSQL Alex 09:17
Re: Sequences without blank holes Richard Huxton 09:19
Tools are disabled, except connect & disconnect Rob Cole 09:26
Re: Database Design & Application Server Design Richard Huxton 09:33
Re: Problems with PLPGSQL Alex 10:00
Re: Problems with PLPGSQL Pavel Stehule 10:39
Re: INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE Peter Eisentraut 10:59
Re: Problems with PLPGSQL Richard Huxton 11:08
Re: PostgreSQL v7.4 Release Candidate 1 compile errors Martin Marques 11:24
Re: Problems with PLPGSQL Alex 11:30
Re: Problems with PLPGSQL Alvaro Herrera 12:42
on connect trigger btober 13:52
Re: Problems with PLPGSQL Bruno Wolff III 14:27
Re: Sequences without blank holes Bruno Wolff III 14:33
Re: tsearch2 and gist index bloat George Essig 14:52
Re: Problems with PLPGSQL Tom Lane 14:54
Re: INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE scott.marlowe 15:00
New eRServer patch/fork release Andrew Rawnsley 15:21
Re: INSERT and UPDATE of ALLBALLS/INFINITY dates and Marco Lazzeri 15:25
Fixed column format data Greg Stark 15:30
Re: Sequences without blank holes btober 15:33
Re: INSERT and UPDATE of ALLBALLS/INFINITY dates and scott.marlowe 15:41
Re: Fixed column format data Shridhar Daithankar 15:44

Browse Archives

Prev | Next