pgsql-sql since 2007-11-11 00:00

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

Nov. 11, 2007

Thread Author Time
general question on optimizer chester c young 00:23

Nov. 12, 2007

Thread Author Time
Re: Select in From clause Bart Degryse 08:23
Re: Temporal databases Philippe Lang 09:07
show value of backslashes in string array argument Sabin Coanda 09:15
Re: show value of backslashes in string array argument Sabin Coanda 09:51
Re: show value of backslashes in string array argument Achilleas Mantzios 09:58
plpgsql language not aware of standard_conforming_strings ? Sabin Coanda 10:20
Re: show value of backslashes in string array argument Achilleas Mantzios 10:20
Re: plpgsql language not aware of standard_conforming_strings ? Sabin Coanda 11:10
Re: show value of backslashes in string array argument Tom Lane 16:05
Re: plpgsql language not aware of standard_conforming_strings ? Sabin Coanda 16:19
Re: show value of backslashes in string array argument Sabin Coanda 17:12
Problem with UNION-queries Andreas Joseph Krogh 20:27
Re: design of tables for sparse data Fernando Hevia 21:48

Nov. 13, 2007

Thread Author Time
Re: design of tables for sparse data Andreas 02:10
Re: design of tables for sparse data Erik Jones 15:33

Nov. 14, 2007

Thread Author Time
Originally created and last_mod by whom and when ? Aarni Ruuhimäki 11:06
Re: Originally created and last_mod by whom and when ? Richard Huxton 11:28
Re: ALL() question Richard Huxton 11:56
Re: Originally created and last_mod by whom and when ? Aarni Ruuhimäki 12:39
Re: ALL() question Bart Degryse 12:57
Re: ALL() question Richard Huxton 13:20
Re: ALL() question Richard Huxton 13:21
Re: ALL() question hubert depesz lubaczewski 13:31
ALL() question Julien Cigar 13:39
Re: Temporal databases Philippe Lang 13:47
Re: ALL() question Julien Cigar 14:50
Re: ALL() question Julien Cigar 14:57
Re: ALL() question Osvaldo Rosario Kussama 15:46
Re: ALL() question Julien Cigar 15:50
postgres bogged down beyond tolerance Tena Sakai 17:52
Re: postgres bogged down beyond tolerance Richard Broersma Jr 18:35

Nov. 15, 2007

Thread Author Time
Re: postgres bogged down beyond tolerance Gregory Stark 09:33
trap for any exception Sabin Coanda 13:45
Re: trap for any exception Sabin Coanda 13:52
Re: trap for any exception Sabin Coanda 13:54
Re: trap for any exception Stephan Szabo 15:35
Is there anything special about pg_dump's compression? Jean-David Beyer 16:05
Re: Is there anything special about pg_dump's compression? Andrew Sullivan 16:11
Re: trap for any exception Stephan Szabo 18:36
Erlang & PostgreSQL native driver Daniel Caune 19:06

Nov. 16, 2007

Thread Author Time
Re: Is there anything special about pg_dump's compression? Jean-David Beyer 05:00
Re: Is there anything special about pg_dump's compression? Tom Lane 05:29
Re: trap for any exception Bart Degryse 07:56
Re: Is there anything special about pg_dump's compression? Jean-David Beyer 12:54
Re: Is there anything special about pg_dump's compression? Shane Ambler 16:40
Re: Is there anything special about pg_dump's compression? Jean-David Beyer 20:36

Nov. 19, 2007

Thread Author Time
EXPLAIN ANALYZE inside functions Sabin Coanda 13:17
Re: EXPLAIN ANALYZE inside functions Sabin Coanda 14:48
Aggregate question (Sum) Luiz K. Matsumura 20:46
Re: Aggregate question (Sum) Rodrigo De León 21:11
Re: Aggregate question (Sum) Luiz K. Matsumura 23:17

Nov. 20, 2007

Thread Author Time
Run Function With First Priority Otniel Michael 09:21
Loading 8.2 data into 8.1 Andreas Joseph Krogh 10:21
dynmic column names inside trigger? Louis-David Mitterrand 16:12
Re: dynmic column names inside trigger? Tom Lane 16:56

Nov. 21, 2007

Thread Author Time
Re: string function Phillip Smith 03:14
Re: dynmic column names inside trigger? Bart Degryse 08:14
PL argument max size, and doubt Martin Marques 13:23
Re: PL argument max size, and doubt Rodrigo De León 15:29
Re: PL argument max size, and doubt Martin Marques 17:46
Re: PL argument max size, and doubt Tom Lane 18:05
string function gunartha 18:54

Nov. 22, 2007

Thread Author Time
update on join ? Andreas 02:58
Re: update on join ? Frank Bax 03:34
Re: update on join ? Richard Broersma Jr 03:38
Re: update on join ? chester c young 03:41
Bad Schema Design or Useful Trick? Richard Broersma Jr 07:44
How to have a unique primary key on two tables Daniel "bodom_lx" Graziotin 11:01
Re: How to have a unique primary key on two tables Bart Degryse 11:11
Re: How to have a unique primary key on two tables A. Kretschmer 11:19
Re: Loading 8.2 data into 8.1 Peter Eisentraut 13:19
Re: [SQL] Bad Schema Design or Useful Trick? Richard Huxton 13:46
Re: How to have a unique primary key on two tables D'Arcy J.M. Cain 13:48
Re: dynmic column names inside trigger? Louis-David Mitterrand 13:54
Re: dynmic column names inside trigger? Louis-David Mitterrand 13:54
Re: dynmic column names inside trigger? Bart Degryse 14:11
Re: SQL state: 22P02 Rodrigo De León 16:06
SQL state: 22P02 📎 Franklin Haut 16:24
Re: PL argument max size, and doubt Martin Marques 21:36

Nov. 23, 2007

Thread Author Time
Re: PL argument max size, and doubt Tom Lane 06:40
Aleatory exception Sabin Coanda 09:23
Re: Aleatory exception Sabin Coanda 09:26
Re: PL argument max size, and doubt Martin Marques 10:37
Re: Aleatory exception - found cause Sabin Coanda 11:42
Re: dynmic column names inside trigger? Louis-David Mitterrand 17:06
Re: dynmic column names inside trigger? Michael Glaesemann 20:54

Nov. 26, 2007

Thread Author Time
Re: dynmic column names inside trigger? Bart Degryse 08:13
PG trouble with index-usage in sort Andreas Joseph Krogh 21:08
materialize Ehab Galal 21:17
Re: materialize Tom Lane 21:53

Nov. 27, 2007

Thread Author Time
pg_clog (?) problem with VACUMM Gerardo Herzig 20:06
Re: pg_clog (?) problem with VACUMM Gregory Stark 20:17
Re: pg_clog (?) problem with VACUMM Gerardo Herzig 21:46
Re: pg_clog (?) problem with VACUMM Stefan Becker 22:05

Nov. 28, 2007

Thread Author Time
Strang behaviour SELECT ... LIMIT n FOR UPDATE Daniel Caune 00:16
NULLIF problem Gera Mel Handumon 02:04
Re: NULLIF problem Michael Glaesemann 02:47
Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Tom Lane 04:46
Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Bruce Momjian 04:50
obtaining column names from tables or views John van Zantvoort 15:13
Re: obtaining column names from tables or views Richard Huxton 15:29
Re: NULLIF problem Erik Jones 19:00
Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Daniel Caune 19:50
Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Tom Lane 20:33
Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Daniel Caune 21:28
Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Tom Lane 22:08

Nov. 29, 2007

Thread Author Time
Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Alvaro Herrera 01:08
Re: NULLIF problem Gera Mel Handumon 09:43
Re: NULLIF problem Michael Glaesemann 12:46
statement-level trigger sample out there? Christian Kindler 13:01
Re: statement-level trigger sample out there? Pavel Stehule 13:48
Re: statement-level trigger sample out there? Stephen Cook 14:16
Re: statement-level trigger sample out there? Pavel Stehule 14:26
[No subject] Christian Kindler 14:44
Re: statement-level trigger sample out there? Christian Kindler 15:04
Re: statement-level trigger sample out there? Alvaro Herrera 19:17
Re: statement-level trigger sample out there? Gerardo Herzig 19:18
Re: statement-level trigger sample out there? Gerardo Herzig 20:08

Nov. 30, 2007

Thread Author Time
Re: statement-level trigger sample out there? hubert depesz lubaczewski 09:41
Using schema Daniel Caune 15:00

Dec. 1, 2007

Thread Author Time
Re: Using schema Scott Marlowe 03:33
Crosstab limitation... ronald tabada 03:47
Re: Crosstab limitation... Tom Lane 04:07

Dec. 3, 2007

Thread Author Time
alias required by standard or PostgreSQL? Joost Kraaijeveld 05:52
Re: alias required by standard or PostgreSQL? Tom Lane 06:13

Dec. 4, 2007

Thread Author Time
Calling functions from within pl/pgsql Achilleas Mantzios 12:16
Re: Calling functions from within pl/pgsql Pavel Stehule 12:59
Re: Calling functions from within pl/pgsql Achilleas Mantzios 13:23
Re: Calling functions from within pl/pgsql Pavel Stehule 13:41
marking tuples Ehab Galal 22:25

Dec. 5, 2007

Thread Author Time
Error OID Yohanes Purnomo 02:24
Re: Error OID Guillaume Lelarge 07:36
Re: marking tuples Gregory Stark 08:44
plpythonu and "hello concurrent world" Gerardo Herzig 13:10
Re: marking tuples Ehab Galal 13:34
Re: plpythonu and "hello concurrent world" Tom Lane 14:42
Re: plpythonu and "hello concurrent world" Gerardo Herzig 15:19

Dec. 6, 2007

Thread Author Time
Re: Error OID Yohanes Purnomo 02:08
execute system command from storage procedure Sabin Coanda 16:32
Re: execute system command from storage procedure Erik Jones 17:05
Re: execute system command from storage procedure Andreas Kretschmer 17:07
polymorphic functions and domains TJ O'Donnell 18:48
Rule rewrite to possible union? Erik Jones 22:03

Dec. 7, 2007

Thread Author Time
Re: polymorphic functions and domains Tom Lane 00:51
INSERT INTO relational tables Stefan Scheidegger 13:22
Re: INSERT INTO relational tables Andreas Kretschmer 15:16

Dec. 8, 2007

Thread Author Time
Re: polymorphic functions and domains TJ O'Donnell 18:32

Dec. 9, 2007

Thread Author Time
Re: INSERT INTO relational tables Steve Midgley 07:50

Dec. 10, 2007

Thread Author Time
join on three tables is slow Gerry Reno 01:31
Re: join on three tables is slow Gerry Reno 02:16
Re: join on three tables is slow Shane Ambler 04:45
SQL INSERT/TRIGGER Help Poovendran Moodley 06:36
Re: SQL INSERT/TRIGGER Help A. Kretschmer 06:44
Re: SQL INSERT/TRIGGER Help Poovendran Moodley 07:27
Re: SQL INSERT/TRIGGER Help A. Kretschmer 07:43
Re: SQL INSERT/TRIGGER Help Poovendran Moodley 09:13
Re: INSERT INTO relational tables Stefan Scheidegger 10:42
Re: INSERT INTO relational tables A. Kretschmer 11:08
Re: INSERT INTO relational tables A. Kretschmer 11:29
Re: INSERT INTO relational tables Stefan Scheidegger 13:21
Re: SQL INSERT/TRIGGER Help Alvaro Herrera 14:08

Dec. 11, 2007

Thread Author Time
Insert Rule, Multiple Insert, Update Problem Scott 04:23
Re: join on three tables is slow Gerry Reno 04:24
Re: Insert Rule, Multiple Insert, Update Problem Richard Broersma Jr 04:50
Re: join on three tables is slow Pavel Stehule 06:00
Re: join on three tables is slow Gerry Reno 13:23
Re: join on three tables is slow Pavel Stehule 14:55
case sensitivity for tables, columns, and constraint names Ertel, Steve 17:05
Re: case sensitivity for tables, columns, and constraint names A. Kretschmer 17:24
Re: case sensitivity for tables, columns, and constraint names Andrew Sullivan 17:30
Re: case sensitivity for tables, columns, and constraint names Richard Huxton 17:35
Re: join on three tables is slow Gerry Reno 18:18
Foreign Key for multi PK or design question PostgreSQL Admin 18:20
Re: Foreign Key for multi PK or design question Erik Jones 18:35
Re: Foreign Key for multi PK or design question A. Kretschmer 18:53
Re: Foreign Key for multi PK or design question PostgreSQL Admin 19:12
Re: Foreign Key for multi PK or design question Alvaro Herrera 19:42
Re: join on three tables is slow Pavel Stehule 19:46
Re: Foreign Key for multi PK or design question A. Kretschmer 19:48
Re: Foreign Key for multi PK or design question PostgreSQL Admin 20:04

Dec. 12, 2007

Thread Author Time
Query design assistance - getting daily totals Paul Lambert 01:34
Re: join on three tables is slow Tom Lane 04:35
Function result using execute Paul Lambert 05:15
Re: Function result using execute Tom Lane 06:01
Re: Function result using execute Erik Jones 06:25
Re: Function result using execute Paul Lambert 06:30
Re: Query design assistance - getting daily totals A. Kretschmer 06:31
Re: Query design assistance - getting daily totals Paul Lambert 06:39
Re: Query design assistance - getting daily totals A. Kretschmer 07:29
Re: join on three tables is slow Gerry Reno 14:29
Re: Query design assistance - getting daily totals Scott Marlowe 15:48
Query Assistance Gary Chambers 16:58
Re: Query Assistance D'Arcy J.M. Cain 17:31
Re: Query Assistance Gary Chambers 18:00
Re: Query design assistance - getting daily totals Rodrigo De León 19:53
Re: Query Assistance Richard Huxton 20:21
Trigger definition . . . puzzled Rolf A. de By 21:38
Re: Trigger definition . . . puzzled Erik Jones 22:30

Dec. 13, 2007

Thread Author Time
Re: Trigger definition . . . puzzled Rolf A. de By 07:19

Browse Archives

Prev | Next