pgsql-sql since 2007-10-24 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

Oct. 24, 2007

Thread	Author	Time
Quick question re foreign keys.	Paul Lambert	02:03
Re: Quick question re foreign keys.	Phillip Smith	02:14
Re: Quick question re foreign keys.	Tom Lane	02:44
Re: request for help with COPY syntax	Adrian Klaver	02:51
Re: Quick question re foreign keys.	Paul Lambert	03:00
Re: Quick question re foreign keys.	Paul Lambert	03:09
Re: Quick question re foreign keys.	D'Arcy J.M. Cain	05:27
Re: request for help with COPY syntax	Chuck D.	06:59
Re: request for help with COPY syntax	Chuck D.	07:02
Re: request for help with COPY syntax	Paul Lambert	07:10
Re: Quick question re foreign keys.	Nis Jørgensen	07:43
Re: request for help with COPY syntax	Harald Fuchs	09:19
get only rows for latest version of contents	Sébastien Meudec	09:29
Re: get only rows for latest version of contents	Christian Kindler	09:55
Re: request for help with COPY syntax	Fernando Hevia	13:56
Re: Quick question re foreign keys.	Robins Tharakan	14:27
Re: Quick question re foreign keys.	D'Arcy J.M. Cain	14:53

Oct. 25, 2007

Thread	Author	Time
ERROR: failed to re-find parent key in "pk_ep07"	Otniel Michael	02:31
Re: ERROR: failed to re-find parent key in "pk_ep07"	Tom Lane	04:45
Re: get only rows for latest version of contents	Sébastien Meudec	06:50
Re: ERROR: failed to re-find parent key in "pk_ep07"	Otniel Michael	08:26
Re: ERROR: failed to re-find parent key in "pk_ep07"	Gregory Stark	08:42
Re: ERROR: failed to re-find parent key in "pk_ep07"	Filip Rembiałkowski	08:50
Re: get only rows for latest version of contents	Erik Jones	14:34
Re: request for help with COPY syntax	Chuck D.	15:35
Re: request for help with COPY syntax	Chuck D.	16:16
(repost) Help understanding expressions in order by clause	Steve Midgley	16:44
Re: request for help with COPY syntax	Bricklen Anderson	16:57
Re: (repost) Help understanding expressions in order by clause	Tom Lane	17:03
JOINing based on whether an IP address is contained within a CIDR range?	Jamie Tufnell	18:22
Re: request for help with COPY syntax	Chuck D.	19:13
Re: JOINing based on whether an IP address is contained within a CIDR range?	Erik Jones	19:21
hidden versioning system	Darnell Brawner	19:32
Re: JOINing based on whether an IP address is contained within a CIDR range?	Tom Lane	19:32
Re: request for help with COPY syntax	Fernando Hevia	21:16

Oct. 26, 2007

Thread	Author	Time
Re: request for help with COPY syntax	Chuck D.	02:16
Re: request for help with COPY syntax	Tom Lane	03:22
Re: request for help with COPY syntax	Chuck D.	04:26
Re: get only rows for latest version of contents	Sébastien Meudec	07:59
Re: JOINing based on whether an IP address is contained within a CIDR range?	Harald Fuchs	11:44
Re: JOINing based on whether an IP address is contained within a CIDR range?	Jonah H. Harris	12:03
Re: request for help with COPY syntax	Chuck D.	16:29

Oct. 28, 2007

Thread	Author	Time
Removing whitespace using regexp_replace	Thomas Kellerer	11:20
Re: Removing whitespace using regexp_replace	Andreas Kretschmer	11:42
Re: Removing whitespace using regexp_replace	Thomas Kellerer	12:15
Re: Removing whitespace using regexp_replace	Andreas Kretschmer	12:32
Re: Removing whitespace using regexp_replace	Thomas Kellerer	14:35
Select into with dynamic criteria in a plpgsql function	Paul Lambert	23:11
Re: Select into with dynamic criteria in a plpgsql function	Paul Lambert	23:19

Oct. 29, 2007

Thread	Author	Time
update from select	dev	09:18
Re: update from select	A. Kretschmer	10:45
Re: update from select	Pavel Stehule	11:03
Re: update from select	Tom Lane	14:30
Re: update from select	dev	15:28
Re: update from select	Pavel Stehule	15:46
Re: update from select	Tom Lane	18:42

Oct. 30, 2007

Thread	Author	Time
Perfomance benefit using Min() against order by & limit 1?	Fernando Hevia	20:42
puzzled by SELECT INTO	Gerardo Herzig	20:43
Re: puzzled by SELECT INTO	Rodrigo De León	20:57
Re: Perfomance benefit using Min() against order by & limit 1?	Fernando Hevia	21:00

Oct. 31, 2007

Thread	Author	Time
Re: puzzled by SELECT INTO	Gerardo Herzig	12:28
Returning the total number of rows as a separate column when using limit	Andreas Joseph Krogh	15:55
Backup Database	Joanne Salerno	17:14
Re: Backup Database	Andrew Sullivan	19:04

Nov. 1, 2007

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

Nov. 4, 2007

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

Nov. 5, 2007

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

Nov. 6, 2007

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

Nov. 7, 2007

Thread	Author	Time
EPOCH TIMESTAMP Conversion Problem	Amitanand Chikorde	10:37
Temporal databases	Philippe Lang	13:22
Re: EPOCH TIMESTAMP Conversion Problem	Tom Lane	15:35

Nov. 8, 2007

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

Nov. 9, 2007

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

Nov. 10, 2007

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

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

Browse Archives

Prev | Next