pgsql-sql since 2002-03-07 00:00

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

March 7, 2002

Thread Author Time
Coalesce Get Duplicate Record 📎 Lonh SENG 09:30
How to grant a privilege on all tables or views or both of a database to someone? 📎 Eric Du 10:37
Re: \d+ and \dd Thomas Good 13:48
subquery involving 'now' jmycr 14:08
Re: confusing inheritance Stephan Szabo 15:49
Re: PL/pgSQL Syntax Problem daq 16:18
Re: How to grant a privilege on all tables or views or both of a database to someone? Paul Ogden 18:55
7.0.3 pg_dump -> segmentation fault! george young 20:17
Re: 7.0.3 pg_dump -> segmentation fault! Stephan Szabo 20:27
Re: psql question Josh Berkus 20:30
Re: How to grant a privilege on all tables or views or both of a database to someone? Andrew G. Hammond 20:40
Fw: Re: 7.0.3 pg_dump -> segmentation fault! george young 20:44
Re: How to grant a privilege on all tables or views or both of a database to someone? Paul Ogden 21:01
Bad Query?? Extremely slow response Patrick Hatcher 21:46
ALTER CONSTRAINT FOREIGN KEY Charles Hauser 21:53
Re: Fw: Re: 7.0.3 pg_dump -> segmentation fault! Tom Lane 22:24

March 8, 2002

Thread Author Time
Re: [NOVICE] Bad Query?? Extremely slow response Josh Berkus 01:28
Re: ERROR (Bug?) in RULE processing ? Bruce Momjian 01:29
Re: psql question Christopher Kings-Lynne 02:31
URGENT! VIRUS ALERT Carlo Florendo 06:57
Re: PL/pgSQL Syntax Problem rolf.ostvik 09:40
Re: Bad Query?? Extremely slow response Andrew McMillan 11:35
Help reqd: Copying char to date rjb26 11:38
REFERENCES Andre Schubert 12:28
Re: Help reqd: Copying char to date rjb26 13:26
'now' problem jmycr 14:13
problem with RECORD in a stored procedure Dalton Shane 15:06
Re: problem with RECORD in a stored procedure Stephan Szabo 16:16
Re: problem with RECORD in a stored procedure daq 17:53
Support for "nested sets" and PHP (Re: Recursive select) knut.suebert 18:38
Re: PL/pgsql PG Explorer 19:54
New user - creating function question TimothyReaves 20:16

March 9, 2002

Thread Author Time
Retrieving a ' in an SQL statement? Jdou12345 07:51
Line Numbering in SELRCT Output Hubert Palme 23:48

March 10, 2002

Thread Author Time
Re: Line Numbering in SELRCT Output Paul 15:33
Referential integrity implementation - bug or user error? msn 22:19

March 11, 2002

Thread Author Time
Re: Uniqueness of rule, constraint, and trigger names Peter Eisentraut 01:33
Re: Uniqueness of rule, constraint, and trigger names Thomas Lockhart 01:37
Case (in)sensitivity Roberto Mello 05:02
Re: Case (in)sensitivity Christopher Kings-Lynne 05:04
Re: Case (in)sensitivity Peter Eisentraut 05:18
Re: Case (in)sensitivity Joel Burton 07:28
Operator ~ on type aclitem in pgsql 7.2 karin probost 08:30
Re: PL/pgsql adm 10:39
Re: where not exists Dag Arne Matre 10:54
Timestamp with time zone problem Aguinaldo Fagundes Junior 14:37
Calling a trigger from a trigger Mike Finn 18:19
Pg_dump Hunter, Ray 19:45
Re: Pg_dump knut.suebert 21:37
Re: Line Numbering in SELRCT Output Hubert Palme 22:55

March 12, 2002

Thread Author Time
Re: Referential integrity implementation - bug or user error? Lee Harr 01:18
SELECT FOR UPDATE feblec 01:31
Re: SELECT FOR UPDATE Florian Weimer 09:18
GRANT problem ? GRIMOIS Eric 10:16
Re: GRANT problem ? PGMailList 11:58
Re: GRANT problem ? D'Arcy J.M. Cain 11:59
in-date news items Gary Stainburn 12:17
Re: in-date news items Ian Barwick 13:25
Re: in-date news items Gary Stainburn 17:19
Re: in-date news items Andrew G. Hammond 17:24
Re: in-date news items Ian Barwick 17:28
Re: SELECT FOR UPDATE Andrew G. Hammond 17:46
Re: in-date news items Peter Eisentraut 17:50
Support for "nested sets" and PHP (Re: Recursive select) Culley Harrelson 17:55
Re: in-date news items Stephan Szabo 18:23

March 13, 2002

Thread Author Time
to unsubcribe? 📎 Ivan Manuel Andrade Muñoz 02:23
[INIMSS] How to foreign key Dino Cherian K 06:07
Re: to unsubcribe? Serguei Mokhov 06:18
Re: [INIMSS] How to foreign key Stephan Szabo 06:57
Large data sets and FOR LOOP's Bo Lorentsen 09:37
REFERENCES Andre Schubert 10:53
Re: REFERENCES Laszlo Tibor 11:03
how to know if you are granted on a table? Jean-Christophe FABRE 11:14
[No subject] Jean-Christophe FABRE 11:26
[INIMSS] How to use OID? Dino Cherian K 11:43
Re: REFERENCES Andre Schubert 12:19
Re: Large data sets and FOR LOOP's Tom Lane 15:08
Re: Large data sets and FOR LOOP's Bo Lorentsen 15:35
Re: REFERENCES Stephan Szabo 15:57
Re: ALTER CONSTRAINT FOREIGN KEY Stephan Szabo 16:02
Re: subquery involving 'now' Stephan Szabo 16:04
Re: Large data sets and FOR LOOP's Jan Wieck 16:29
Re: subquery involving 'now' Gaetano Mendola 16:58
Re: REFERENCES Jan Wieck 17:35
Re: [INIMSS] How to use OID? Josh Berkus 17:38
Casting Graham Vickrage 17:41
Re: Help reqd: Copying char to date Stephan Szabo 18:18
Re: Referential integrity implementation - bug or user error? Stephan Szabo 19:50
Re: Casting PG Explorer 20:25
Strange Postgresql Indexing Behavior Brian Knox 21:28
Re: Casting Tom Lane 22:10

March 14, 2002

Thread Author Time
Re: Line Numbering in SELRCT Output Stephan Szabo 01:01
Re: Christopher Kings-Lynne 01:27
Re: [INIMSS] How to use OID? Christopher Kings-Lynne 01:29
Re: [INIMSS] How to use OID? Herbert Rabago Ambos 02:09
Re: Strange Postgresql Indexing Behavior Martijn van Oosterhout 02:16
checking for existence of a table in plpgsql. Bhuvan A 05:40
Re: Large data sets and FOR LOOP's Bo Lorentsen 07:57
Re: checking for existence of a table in plpgsql. Bo Lorentsen 08:06
Re: Large data sets and FOR LOOP's Jan Wieck 15:21
Re: Large data sets and FOR LOOP's Bo Lorentsen 15:56
Re: checking for existence of a table in plpgsql. Roberto Mello 16:28
unable to log Jie Liang 16:51
Syslog Jie Liang 17:40
Re: Syslog Joe Conway 18:48
Re: Syslog Jie Liang 18:55
Re: [SQL] Syslog Dan Langille 19:06
Re: Syslog Joe Conway 19:27
Re: Syslog Jie Liang 20:13
Re: [SQL] Syslog Oliver Elphick 21:17
Re: [SQL] Syslog Larry Rosenman 23:35

March 15, 2002

Thread Author Time
Re: [SQL] Syslog Tom Lane 00:03
Boolean test Rudi Starcevic 04:32
Re: Boolean test Christopher Kings-Lynne 04:58
Re: Boolean test Peter Eisentraut 05:10
Re: where not exists Llew Sion Goodstadt 12:46
R: [SQL] UPDATE and SELECT result difference Enrico Mangano 14:28
few admin questions Laurent N 15:41
optimizer tuning/forcing correct index use Kelly Burkhart 16:03
Re: R: [SQL] UPDATE and SELECT result difference Jean-Luc Lachance 16:19
Re: Btree index extension question Tom Lane 17:06
How do I set the system time on production server? Ken Corey 17:29
Btree index extension question Dmitry Tkach 18:04
JDBC for J2ME Frederick Klauschen 18:17
Re: [SQL] Why is it not using an index? Stephan Szabo 18:18
Btree index extension question Dmitry Tkach 18:20
Re: Why is it not using an index? Gregory Wood 18:28
Re: JDBC for J2ME Josh Berkus 18:53
Why is it not using an index? Dmitry Tkach 19:07
Re: Why is it not using an index? (small correction) Dmitry Tkach 19:09
Re: Why is it not using an index? Gregory Wood 19:20
Re: Btree index extension question Dmitry Tkach 19:31
Re: Why is it not using an index? 📎 Dmitry Tkach 20:01
Re: Why is it not using an index? Stephan Szabo 20:12
Re: Why is it not using an index? Jean-Luc Lachance 20:25
Re: Why is it not using an index? Gregory Wood 20:34
Re: Why is it not using an index? Tom Lane 21:00
Re: [GENERAL] Btree index extension question fcanedo 21:15
Re: [GENERAL] Btree index extension question fcanedo 21:57
Re: Btree index extension question Dmitry Tkach 23:09
Re: Btree index extension question Dmitry Tkach 23:37
PL/pgSQL question Dmitry Tkach 23:41

March 16, 2002

Thread Author Time
Re: Why is it not using an index? Sergio Freue 00:03
Re: [GENERAL] Btree index extension question fcanedo 00:09
Re: Btree index extension question Dmitry Tkach 01:50
Debugging C functions... Dmitry Tkach 02:04
Re: Debugging C functions... Dima Tkach 05:26
Re: simple problem Masaru Sugawara 09:23
hashtext function disappears in 7.2? george young 18:28
Variable Substitution for table name Samuel J. Sutjiono 21:52
why the big difference on this explain analyze? Dan Langille 22:07
Re: why the big difference on this explain analyze? Tom Lane 22:19
Re: why the big difference on this explain analyze? Dan Langille 22:22

March 17, 2002

Thread Author Time
Re: Variable Substitution for table name Stephan Szabo 00:07
Re: why the big difference on this explain analyze? Dan Langille 00:18
Re: Btree index extension question Christopher Kings-Lynne 03:51
Re: Btree index extension question Dima Tkach 04:07
Re: Why is it not using an index? Martijn van Oosterhout 23:55

March 18, 2002

Thread Author Time
Re: Boolean test Rudi Starcevic 00:53
Creative use of CASE in a GROUP BY clause Dorian Taylor 13:14
Re: Creative use of CASE in a GROUP BY clause Masaru Sugawara 15:58
Re: Line Numbering in SELRCT Output Stephan Szabo 22:51
Re: hashtext function disappears in 7.2? Bruce Momjian 23:20

March 19, 2002

Thread Author Time
create function problem Kancha . 08:25
Re: create function problem Matteo Beccati 08:36
Re: create function problem Kancha . 10:03
optimizer tuning/forcing correct index use Kelly Burkhart 13:22
Re: create function problem Jan Wieck 14:25
Re: optimizer tuning/forcing correct index use Tom Lane 15:28
Re: optimizer tuning/forcing correct index use 📎 Kelly Burkhart 17:12
Re: optimizer tuning/forcing correct index use Tom Lane 17:32
How to create crude report with psql and/or plpgsql Jean-Luc Lachance 18:07
Re: [SQL] How to create crude report with psql and/or plpgsql Andrew G. Hammond 18:21
Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance 18:33
Yet another indexing issue. David Siebert 18:40
Re: [SQL] How to create crude report with psql and/or plpgsql Andrew G. Hammond 18:41
Re: optimizer tuning/forcing correct index use 📎 Kelly Burkhart 18:51
Re: [SQL] How to create crude report with psql and/or plpgsql Bruce Momjian 18:56
Re: [SQL] How to create crude report with psql and/or plpgsql Bruce Momjian 19:18
Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance 19:18
Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance 19:42
How to use an array string Samuel J. Sutjiono 20:22
Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance 20:45
Re: Yet another indexing issue. Stephan Szabo 20:50
Re: How to create crude report with psql and/or plpgsql Roberto Mello 21:35
Re: Yet another indexing issue. David Siebert 22:06
Re: How to create crude report with psql and/or plpgsql Ross J. Reedstrom 22:12
Re: [SQL] How to create crude report with psql and/or plpgsql Peter Eisentraut 22:45

March 20, 2002

Thread Author Time
Re: Yet another indexing issue. Stephan Szabo 00:01
What is Syntax for multiple FULL OUTER JOINS? Patrick Hatcher 03:28
Re: What is Syntax for multiple FULL OUTER JOINS? Stephan Szabo 04:08
plpgsql how to iterate through record values? german pulido 15:26
Re: How to create crude report with psql and/or plpgsql Jeff Eckermann 15:57
Re: How do I set the system time on production server? Marin Dimitrov 16:12
Re: How do I set the system time on production server? Stephan Szabo 16:24
Re: How do I set the system time on production server? Ross J. Reedstrom 16:38
Re: How do I set the system time on production server? Ian Barwick 16:58
Re: How do I set the system time on production server? Oliver Elphick 17:03
Re: What is Syntax for multiple FULL OUTER JOINS? Patrick Hatcher 17:04
Re: How do I set the system time on production server? Peter Eisentraut 17:22

Browse Archives

Prev | Next