Home > mailing lists

Mailing lists [pgsql-sql]

5 May 2002

04:40 Re: difficult query Masaru Sugawara
05:01 Re: More long-string woes Tom Lane
05:19 Re: difficult query Joel Burton
16:47 Re: More long-string woes Tom Lane

6 May 2002

10:43 summary VIEW Gary Stainburn
11:15 Re: Odd behavior with timestamp/interval arithmetic Josh Berkus
13:07 Re: summary VIEW Gary Stainburn

7 May 2002

00:02 Optimizing the implementation of an optimized tree Christian Rishoej
01:04 Re: Optimizing the implementation of an optimized tree Christopher Kings-Lynne
10:03 Re: Optimizing the implementation of an optimized tree Christian Rishoej
10:55 Re: Optimizing the implementation of an optimized tree Oleg Bartunov
11:39 Re: [DOCS] Migrating Oracle to PostgreSQL Jean-Paul ARGUDO
17:33 blanking out repeated columns in rows Sean McCorkle
22:02 Performance issues with compaq server Samuel J. Sutjiono

8 May 2002

05:16 data loss due to improper handling of postmaster .... Rajesh Kumar Mallah.
13:43 postgresql 7.1 file descriptor jade
13:44 Re: [GENERAL] Performance issues with compaq server Martijn van Oosterhout
13:59 Re: [GENERAL] Performance issues with compaq server Holger Marzen
16:14 Re: psql: question Josh Berkus
16:51 Performance on update from join Jean-Luc Lachance
16:51 Re: [HACKERS] postgresql 7.1 file descriptor Tom Lane
16:55 CURSOR/FETCH vs LIMIT/OFFSET Charles Hauser
17:02 Re: blanking out repeated columns in rows Masaru Sugawara
17:20 Re: [GENERAL] Performance issues with compaq server Doug McNaught
20:10 Re: CURSOR/FETCH vs LIMIT/OFFSET Philip Hallstrom
20:11 Bad performance on update from a join Jean-Luc Lachance
20:21 having trouble w/ having clause... Mike Diehl
20:27 Migrating from 7.1 to 7.2 Edipo Elder Fernandes de Melo
20:29 Re: Performance on update from join Tom Lane
21:44 Re: Performance on update from join Jean-Luc Lachance
22:01 Re: blanking out repeated columns in rows Masaru Sugawara
22:39 Re: having trouble w/ having clause... Ian Barwick

9 May 2002

00:50 Re: Migrating from 7.1 to 7.2 Christopher Kings-Lynne
04:22 Re: psql: question Rajesh Kumar Mallah.
10:39 Can this query be faster? Gabriel Dovalo Carril
11:16 Re: postgresql 7.1 file descriptor mlw
11:17 Re: [HACKERS] postgresql 7.1 file descriptor Scott Marlowe
11:17 Re: [GENERAL] Performance issues with compaq server Holger Marzen
11:17 Re: [HACKERS] postgresql 7.1 file descriptor jade
11:17 Re: [GENERAL] Performance issues with compaq server Curt Sampson
11:18 Can this query be faster? Gabriel Dovalo Carril
11:18 Re: [GENERAL] Performance issues with compaq server Holger Marzen
11:18 Re: Connection to multiple databases Bolek Bakowski
13:23 escaping arrays in perl dbi Vincent Stoessel
13:43 Re: escaping arrays in perl dbi Tod McQuillin
17:50 Help with indexes James Orr
18:04 Re: Help with indexes James Orr
18:09 Re: having trouble w/ having clause... Mike Diehl
18:39 Re: Can this query be faster? Gabriel Dovalo Carril
20:01 Re: escaping arrays in perl dbi Vincent Stoessel
22:08 Re: escaping arrays in perl dbi Ian Barwick

10 May 2002

01:31 Re: Help with indexes Christopher Kings-Lynne
08:44 Getting full query string from pg_stat_get_backend_activity Rajesh Kumar Mallah.
09:27 pg_stat_get_backend_pid seems to be listing non existant pids !! Rajesh Kumar Mallah.
09:49 Re: Getting full query string from pg_stat_get_backend_activity Jan Wieck
09:49 Re: pg_stat_get_backend_pid seems to be listing non existant Jan Wieck
10:09 Re: Getting full query string from pg_stat_get_backend_activity Rajesh Kumar Mallah.
10:32 Re: Help with indexes Rajesh Kumar Mallah.
10:44 postmaster dead now !! Rajesh Kumar Mallah.
10:50 Re: postmaster dead now !! Rajesh Kumar Mallah.
10:55 pg_ctl stop does not work. Rajesh Kumar Mallah.
11:03 core file found... Rajesh Kumar Mallah.
11:40 Bad time external representation '' Heiko
11:40 Re: [GENERAL] Performance issues with compaq server Denis Gasparin
11:40 Re: escaping arrays in perl dbi Andrew Perrin
11:41 Re: escaping arrays in perl dbi Dave Carrigan
14:56 Re: core file found... Tom Lane
15:14 Re: Bad time external representation '' Stephan Szabo
16:44 Re: Performance on update from join Tom Lane
18:42 Why very high CPU usage Samuel J. Sutjiono
19:52 Re: Why very high CPU usage Josh Berkus

11 May 2002

03:38 Very high load average but no cpu utilization ? Rajesh Kumar Mallah.
03:50 Re: core file found... Rajesh Kumar Mallah.
04:06 Further info : Very high load average but no cpu utilization ? Rajesh Kumar Mallah.
14:02 Re: core file found... Tom Lane
14:33 Re: pg_stat_get_backend_pid seems to be listing non existant Tom Lane
15:00 Re: Further info : Very high load average but no cpu utilization ? Tom Lane

12 May 2002

04:41 Re: core file found... Rajesh Kumar Mallah.
04:47 Re: Further info : Very high load average but no cpu utilization ? Rajesh Kumar Mallah.
09:33 Re: core file found... Gaetano Mendola
10:06 Re: Further info : Very high load average but no cpu utilization ? D'Arcy J.M. Cain
14:43 Re: Further info : Very high load average but no cpu utilization ? Tom Lane

13 May 2002

03:51 Re: Further info : Very high load average but no cpu utilization ? Rajesh Kumar Mallah.
05:36 Re: having trouble w/ having clause... Wolfgang.Fuertbauer@ebewe.com
06:13 Re: Migrating from 7.1 to 7.2 Wolfgang.Fuertbauer@ebewe.com
06:26 Re: Migrating from 7.1 to 7.2 Christopher Kings-Lynne
09:21 Re: Further info : Very high load average but no cpu utilization ? D'Arcy J.M. Cain
11:04 Re: Further info : Very high load average but no cpu utilization ? Rajesh Kumar Mallah.
11:50 Re: [GENERAL] Why very high CPU usage Shaun Thomas
11:50 Re: [GENERAL] Why very high CPU usage grant
13:11 timestamp and datestyles Edipo Elder Fernandes de Melo
21:57 pg_dumpall Oleg Lebedev
23:00 Various PostgreSQL questions Marc SCHAEFER

14 May 2002

01:17 Re: Various PostgreSQL questions Christopher Kings-Lynne
01:28 Re: Various PostgreSQL questions Tom Lane
10:47 order by Mathieu Arnold
10:58 Re: order by Christoph Haller
11:02 Re: order by Marin Dimitrov
11:02 Re: order by Mathieu Arnold
11:06 Re: order by Joel Burton
11:11 Re: order by D'Arcy J.M. Cain
11:15 date_part, how to use juerg.rietmann@pup.ch
11:30 sort text field numerically Frank Morton
11:30 Re: order by Mathieu Arnold
11:30 Re: date_part, how to use Joel Burton
11:50 Re: sort text field numerically Joel Burton
16:26 aggregate... Mathieu Arnold
19:26 can't cast varchar as integer? Scott Royston
20:01 Re: aggregate... Tom Lane
20:54 Re: can't cast varchar as integer? Joel Burton
21:02 Re: can't cast varchar as integer? David Stanaway
21:02 Re: pg_dumpall Oleg Lebedev
22:03 Re: can't cast varchar as integer? Scott Royston
22:34 Re: can't cast varchar as integer? Tom Lane

15 May 2002

01:06 Re: order by Christopher Kings-Lynne
01:09 Re: date_part, how to use Christopher Kings-Lynne
02:24 Re: date_part, how to use Joel Burton
02:31 Re: date_part, how to use Christopher Kings-Lynne
03:23 CHECK CONSTRAINT blunder(s) Thomas Good
04:23 Re: CHECK CONSTRAINT blunder(s) Christopher Kings-Lynne
08:10 some questions Ang Tun Chek
08:22 Re: some questions Christopher Kings-Lynne
08:24 Re: some questions Adam Witney
11:08 Help on indexes Stephane DEWITTE
11:13 Re: Various PostgreSQL questions Marc SCHAEFER
13:49 Re: some questions Roberto Mello
14:27 Re: Help on indexes Josh Berkus

16 May 2002

03:59 Rules and Triggers Ludwig Lim
14:12 Re: Rules and Triggers Josh Berkus
15:37 how to build this list ? juerg.rietmann@pup.ch
16:42 trigger question Larry Rosenman
16:48 Re: trigger question Josh Berkus
16:58 Re: trigger question Larry Rosenman
17:11 Re: trigger question Josh Berkus
17:47 Constraint problem Josh Berkus
18:11 SQL over my head... Gregory Brauer
18:11 Re: Constraint problem Josh Berkus
18:18 Re: Constraint problem Stephan Szabo
18:30 Re: trigger question Scott Shattuck
18:30 Re: Constraint problem Josh Berkus
19:14 Re: SQL over my head... Joel Burton
19:21 Re: SQL over my head... Joel Burton
19:42 Re: Constraint problem Stephan Szabo
19:42 Re: SQL over my head... Gregory Brauer
19:49 Re: SQL over my head... Joel Burton
19:49 Re: Constraint problem Josh Berkus
20:28 How can I tell the performance difference? Josh Berkus
20:54 Re: SQL over my head... Gregory Brauer
21:22 Re: How can I tell the performance difference? Joe Conway

17 May 2002

00:12 Re: Constraint problem Stephan Szabo
01:22 Re: Constraint problem Christopher Kings-Lynne
15:58 Re: how to build this list ? Masaru Sugawara
16:37 Re: Constraint problem Josh Berkus
17:51 Re: Rules and Triggers Jan Wieck
18:19 Re: Constraint problem Stephan Szabo
22:43 Rules and variables? Christian Rishoej
22:53 Re: Rules and variables? Josh Berkus
23:18 PL/pgSQL TODO Josh Berkus

18 May 2002

01:05 Re: PL/pgSQL TODO Tom Lane

19 May 2002

11:55 Casting timestamp Edipo E. F. Melo
12:43 Re: Casting timestamp Joel Burton
13:13 count(boolean) Dan MacNeil
14:00 Re: count(boolean) Joel Burton
19:34 A proposal for Interval Math Josh Berkus
20:03 Re: A proposal for Interval Math Oliver Elphick
20:19 Re: A proposal for Interval Math Josh Berkus

20 May 2002

01:37 Re: Casting timestamp Edipo E. F. Melo
06:54 Re: A proposal for Interval Math Oliver Elphick
13:12 Using LASTOID in one query Eckhard Hoeffner
13:24 Re: Using LASTOID in one query Joel Burton
14:05 Re: count(boolean) Jean-Luc Lachance
14:44 Re: Using LASTOID in one query Masaru Sugawara
15:29 Re: count(boolean) Jean-Luc Lachance
15:30 Re: A proposal for Interval Math Josh Berkus
15:32 Re: Using LASTOID in one query Eckhard Hoeffner
18:04 [INIMSS] problem with user privileges Dino
18:04 Re: A proposal for Interval Math Oliver Elphick
21:57 Bug with Daylight Savings Time & Interval Josh Berkus
22:58 Guarantee uniqueness of PGP key andre

21 May 2002

00:05 Re: Guarantee uniqueness of PGP key Joel Burton
01:47 Re: Bug with Daylight Savings Time & Interval Tom Lane
05:01 Re: Bug with Daylight Savings Time & Interval Josh Berkus
06:12 drop constraint problem Wolfgang.Fuertbauer@ebewe.com
08:54 constraints for ensuring relationships Markus Wagner
10:50 Re: [NOVICE] Guarantee uniqueness of PGP key Bruno Wolff III
11:25 Re: [NOVICE] Guarantee uniqueness of PGP key D. Duccini
12:10 Re: drop constraint problem Joel Burton
13:44 Re: constraints for ensuring relationships Stephan Szabo
16:30 Re: Bug with Daylight Savings Time & Interval Josh Berkus
17:14 Re: A proposal for Interval Math Josh Berkus

22 May 2002

01:59 Re: drop constraint problem Christopher Kings-Lynne
06:39 Turning column into row Tille, Andreas
08:57 Re: Turning column into row Oliver Elphick
09:32 Re: Turning column into row Tille, Andreas
11:19 Re: Turning column into row Gabriel Dovalo Carril
11:30 Re: Turning column into row Wm. G. Urquhart
11:32 Compatibility Issue of CREATE RULE in 7.2 Bhuvan A
11:45 Re: [NOVICE] Guarantee uniqueness of PGP key andre
11:45 Re: Bug with Daylight Savings Time & Interval Thomas Lockhart
11:45 Re: Bug with Daylight Savings Time & Interval Thomas Lockhart
12:10 Turning column into row
12:10 Re: Turning column into row Tille, Andreas
12:11 Compatibility Issue of CREATE RULE in 7.2 Bhuvan A
12:33 Bug with ORDER BY expression [ ASC | DESC ] ? Christoph Haller
12:34 Re: Turning column into row Tille, Andreas
12:49 Re: Turning column into row Wm. G. Urquhart
13:06 Re: Turning column into row (More...) Wm. G. Urquhart
13:06 Re: Compatibility Issue of CREATE RULE in 7.2 Tom Lane
13:06 Re: Bug with ORDER BY expression [ ASC | DESC ] ? Tom Lane
13:07 Re: Bug with ORDER BY expression [ ASC | DESC ] ? Christoph Haller
14:06 Re: Turning column into row Tille, Andreas
14:27 Re: Turning column into row Joel Burton
14:27 Re: Turning column into row Joel Burton
14:27 Speeding up SELECT MAX(),... GROUP BY ... ? Christoph Haller
15:10 Re: Turning column into row Wm. G. Urquhart
22:46 Re: Speeding up SELECT MAX(),... GROUP BY ... ? Josh Berkus

23 May 2002

05:04 Compatibility Issue of CREATE RULE in 7.2 Bhuvan A
07:21 Re: Further info : Very high load average but no cpu utilization ? Denis
08:29 Re: Turning column into row Tille, Andreas
10:39 ... rhema@bhasin.co.in
10:39 Functions with dynamic queries Gabriel Dovalo Carril
12:35 Re: Turning column into row Joel Burton
12:38 Re: Further info : Very high load average but no cpu utilization ? Rajesh Kumar Mallah.
13:11 Re: Rajesh Kumar Mallah.
13:11 Re: Functions with dynamic queries Rajesh Kumar Mallah.
15:26 Re: Bruno Wolff III
20:49 Re: Functions with dynamic queries Gabriel Dovalo Carril
21:40 Re: Functions with dynamic queries Jeff Eckermann
21:47 Re: Functions with dynamic queries Jeff Eckermann
23:38 Re: Functions with dynamic queries Gabriel Dovalo Carril

24 May 2002

08:25 Re: Functions with dynamic queries Gabriel Dovalo Carril
10:53 Re: Functions with dynamic queries Rajesh Kumar Mallah.
12:51 Re: Functions with dynamic queries Jeff Eckermann
17:09 Trees in SQL Gregory Brauer
17:34 Re: Trees in SQL Gregory Brauer
17:48 Re: Trees in SQL Douglas Trainor
18:46 Re: Trees in SQL Ron Peterson
19:48 Re: Trees in SQL Oleg Bartunov
23:07 Re: Trees in SQL Christopher Kings-Lynne

25 May 2002

01:12 Re: Functions with dynamic queries Gabriel Dovalo Carril

26 May 2002

09:05 XSD to Postgresql SQL Julian Scarfe
09:26 Re: Functions with dynamic queries Rajesh Kumar Mallah.
09:53 uinique identifier ||//::..-cwhisperer-..:://||
14:52 Re: uinique identifier Stephan Szabo

27 May 2002

01:16 Re: uinique identifier Christopher Kings-Lynne
10:55 Re: Trees in SQL Achilleus Mantzios
12:00 Re: Trees in SQL Rajesh Kumar Mallah.
13:20 Some additional PostgreSQL questions Marc SCHAEFER
17:24 Re: Trees in SQL Christopher Kings-Lynne
19:11 Re: Some additional PostgreSQL questions Tom Lane
20:22 XSD to Postgresql SQL Julian Scarfe
20:26 Problem with the result set of postgres Sandeep Chibber
20:31 dynamic table names, determined by calling parameter Michael Beckstette
22:29 Triggers and System Tables. stef@chronozon.artofdns.com (Stef Telford)
22:54 Re: Problem with the result set of postgres Joe Conway

28 May 2002

04:30 Re: Triggers and System Tables. Stephan Szabo
04:51 Re: Triggers and System Tables. stef@chronozon.artofdns.com (Stef Telford)
05:54 Re: Triggers and System Tables. Stephan Szabo
06:50 Re: Some additional PostgreSQL questions schaefer@alphanet.ch
13:36 Re: Triggers and System Tables. Jan Wieck
13:40 Re: Some additional PostgreSQL questions Tom Lane
13:43 dynamic table names, determined by calling parameter Michael Beckstette
14:53 Creation of a table with dynamic name from inside a pgpsql function Michael Beckstette
16:06 Re: Functions with dynamic queries Jeff Eckermann
16:34 Re: Creation of a table with dynamic name from inside a pgpsql function Tom Lane
17:14 Re: Trees in SQL Josh Berkus
17:47 query system tables to find columns unique constraint is constraining? Beth Gatewood
18:14 Re: query system tables to find columns unique constraint is constraining? Tom Lane
18:25 Re: Functions with dynamic queries Gabriel Dovalo Carril
20:18 Re: query system tables to find columns unique constraint is constraining? Christopher Kings-Lynne

29 May 2002

15:08 Can you help with this JOIN? Wei Weng
15:22 Re: Can you help with this JOIN? Wei Weng
15:37 Re: Can you help with this JOIN? Tom Lane
16:12 contrib/tree issues achill@matrix.gatewaynet.com
16:13 Re: Trees in SQL achill@matrix.gatewaynet.com
16:21 Re: Can you help with this JOIN? Stephan Szabo
16:27 Re: contrib/tree issues Oleg Bartunov
16:34 Re: contrib/tree issues Achilleus Mantzios
16:40 Re: contrib/tree issues Achilleus Mantzios
19:06 Re: contrib/tree issues Oleg Bartunov

30 May 2002

16:16 question on JOIN and WHERE clause Wei Weng
16:16 Re: Can you help with this JOIN? Wei Weng
16:26 Re: Can you help with this JOIN? Wei Weng
16:38 Re: Can you help with this JOIN? Stephan Szabo
16:59 Re: Can you help with this JOIN? Tom Lane
22:31 Math Huh? Josh Berkus
22:45 Re: Math Huh? Larry Rosenman
22:45 Re: Math Huh? Tom Lane
22:54 Re: Math Huh? David Stanaway
23:04 Re: Math Huh? Josh Berkus
23:37 Re: Math Huh? Larry Rosenman

31 May 2002

05:37 Re: Math Huh? Achilleus Mantzios
07:18 contrib/intarray Achilleus Mantzios
07:56 Re: question on JOIN and WHERE clause Henshall, Stuart - WCP
10:12 Re: contrib/intarray Oleg Bartunov
11:37 http://www.postgresql.org/idocs/ PROBLEM! Achilleus Mantzios
13:57 Re: http://www.postgresql.org/idocs/ PROBLEM! Marc G. Fournier
23:32 problem with sql Ricardo Javier Aranibar León