Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
pgsql-sql - November 2007
Prev | Next
2007-11-01
- Scrolling cursors in PL/PgSQL Dawid Kuroczko (20:19)
- Re: Scrolling cursors in PL/PgSQL Raymond O'Donnell (21:02)
- Re: Scrolling cursors in PL/PgSQL Pavel Stehule (21:05)
- Re: Scrolling cursors in PL/PgSQL Tom Lane (21:22)
2007-11-04
- omitting redundant join predicate Ehab Galal (13:14)
- Re: omitting redundant join predicate Tom Lane (16:35)
- SELECT DISTINCT ... ORDER BY UPPER(column_name) fails Aymeric Levaux (16:49)
- Re: SELECT DISTINCT ... ORDER BY UPPER(column_name) fails Tom Lane (17:12)
- Partitioning and Foreign Keys Volkan YAZICI (17:57)
2007-11-05
- Returning the total number of rows as a separate column when using limit Andreas Joseph Krogh (07:36)
- Re: Backup Database Asko Oja (09:30)
- changing encoding of a postgres database Kenneth Gonsalves (11:55)
- Re: Returning the total number of rows as a separate column when using limit Tom Lane (14:18)
- Re: Returning the total number of rows as a separate column when using limit Andreas Joseph Krogh (14:38)
- Re: Returning the total number of rows as a separate column when using limit Tom Lane (15:00)
- Re: omitting redundant join predicate Ehab Galal (15:15)
- Re: Returning the total number of rows as a separate column when using limit Gregory Stark (15:27)
- Re: omitting redundant join predicate Tom Lane (16:08)
- Re: Returning the total number of rows as a separate column when using limit Andreas Joseph Krogh (16:33)
- Re: Returning the total number of rows as a separate column when using limit Gregory Stark (18:54)
2007-11-06
- Re: Returning the total number of rows as a separate column when using limit Gregory Stark (06:58)
- Treating result of subselect as row Ottó Havasvölgyi (10:09)
- Bitemporal - problem with correalated subquery? Keith Carr (12:51)
2007-11-07
- EPOCH TIMESTAMP Conversion Problem Amitanand Chikorde (10:37)
- Temporal databases Philippe Lang (13:22)
- Re: EPOCH TIMESTAMP Conversion Problem Tom Lane (15:35)
2007-11-08
- Re: Partitioning and Foreign Keys Vivek Khera (16:45)
- Obtaining the primary key of the record just inserted Oliveiros Cristina (17:56)
- Re: Obtaining the primary key of the record just inserted Scott Marlowe (18:03)
- Re: Obtaining the primary key of the record just inserted Oliveiros Cristina (19:10)
- quote_nullable alternative? Philippe Lang (20:05)
2007-11-09
- Re: quote_nullable alternative? Philippe Lang (07:14)
- design of tables for sparse data Andreas (13:39)
- Re: Temporal databases Keith Carr (14:01)
- Select in From clause Ray Madigan (17:21)
- Re: Select in From clause Alvaro Herrera (18:35)
- functions are returns columns Michele Petrazzo - Unipex srl (19:46)
- Re: functions are returns columns Pavel Stehule (20:35)
2007-11-10
- Re: functions are returns columns Michele Petrazzo - Unipex srl (17:37)
- Re: functions are returns columns Gregory Stark (19:36)
- Re: functions are returns columns Tom Lane (19:46)
- Re: functions are returns columns Gregory Stark (21:04)
- Re: functions are returns columns Tom Lane (23:14)
2007-11-11
- general question on optimizer chester c young (00:23)
2007-11-12
- 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)
2007-11-13
- Re: design of tables for sparse data Andreas (02:10)
- Re: design of tables for sparse data Erik Jones (15:33)
2007-11-14
- 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)
2007-11-15
- 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)
2007-11-16
- 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)
2007-11-19
- 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)
2007-11-20
- 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)
2007-11-21
- 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)
2007-11-22
- 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)
2007-11-23
- 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)
2007-11-26
- 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)
2007-11-27
- 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)
2007-11-28
- 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)
2007-11-29
- 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)
2007-11-30
- Re: statement-level trigger sample out there? hubert depesz lubaczewski (09:41)
- Using schema Daniel Caune (15:00)