pgsql-sql since 2002-05-05 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

May 5, 2002

Thread	Author	Time
Re: difficult query	Masaru Sugawara	05:43
Re: More long-string woes	Tom Lane	06:01
Re: difficult query	Joel Burton	06:19
Re: More long-string woes	Tom Lane	17:47

May 6, 2002

Thread	Author	Time
summary VIEW	Gary Stainburn	11:41
Re: summary VIEW	Gary Stainburn	13:08

May 7, 2002

Thread	Author	Time
Optimizing the implementation of an optimized tree 📎	Christian Rishoej	01:02
Re: Optimizing the implementation of an optimized tree	Christopher Kings-Lynne	02:00
Re: [DOCS] Migrating Oracle to PostgreSQL	Jean-Paul ARGUDO	07:46
Re: Optimizing the implementation of an optimized tree	Christian Rishoej	11:03
Re: Optimizing the implementation of an optimized tree	Oleg Bartunov	11:54
Re: [ADMIN] [DOCS] Migrating Oracle to PostgreSQL	Marin Dimitrov	13:49
db recovery (FATAL 2)	Bojan Belovic	14:22
blanking out repeated columns in rows	Sean McCorkle	15:03
postgresql 7.1 file descriptor	jade	22:36
Performance issues with compaq server	Samuel J. Sutjiono	22:40
Re: Performance issues with compaq server	postgres	23:21

May 8, 2002

Thread	Author	Time
Re: Performance issues with compaq server	Martijn van Oosterhout	01:25
Re: db recovery (FATAL 2)	Tom Lane	05:59
data loss due to improper handling of postmaster ....	Rajesh Kumar Mallah.	06:15
Re: Performance issues with compaq server	Holger Marzen	07:05
Re: Performance issues with compaq server	Doug McNaught	15:02
CURSOR/FETCH vs LIMIT/OFFSET	Charles Hauser	15:16
Re: psql: question	Josh Berkus	15:23
Re: postgresql 7.1 file descriptor	mlw	16:00
Performance on update from join	Jean-Luc Lachance	16:15
Re: postgresql 7.1 file descriptor	Tom Lane	16:31
Re: blanking out repeated columns in rows	Masaru Sugawara	16:51
Re: postgresql 7.1 file descriptor	Scott Marlowe	17:21
Re: Performance issues with compaq server	Steve Atkins	17:53
Re: Performance issues with compaq server	Holger Marzen	20:01
Re: CURSOR/FETCH vs LIMIT/OFFSET	Philip Hallstrom	20:31
Bad performance on update from a join	Jean-Luc Lachance	20:40
Migrating from 7.1 to 7.2	Edipo Elder Fernandes de Melo	20:48
having trouble w/ having clause...	Mike Diehl	20:58
Re: Performance on update from join	Tom Lane	21:00
Re: Performance on update from join	Jean-Luc Lachance	21:47
Re: blanking out repeated columns in rows	Masaru Sugawara	22:33
Re: having trouble w/ having clause...	Ian Barwick	23:13

May 9, 2002

Thread	Author	Time
Re: Migrating from 7.1 to 7.2	Christopher Kings-Lynne	01:50
Re: Performance issues with compaq server	Doug McNaught	04:24
Re: psql: question	Rajesh Kumar Mallah.	05:21
Re: [SQL] postgresql 7.1 file descriptor	jade	06:18
Re: Performance issues with compaq server	Curt Sampson	07:11
Can this query be faster?	Gabriel Dovalo Carril	10:12
Can this query be faster?	Gabriel Dovalo Carril	10:38
Re: Performance issues with compaq server	Holger Marzen	11:23
Re: Performance issues with compaq server	Holger Marzen	11:24
Re: Performance issues with compaq server	John Gray	11:43
Re: Connection to multiple databases	Bolek Bakowski	12:08
Re: Performance issues with compaq server	Denis Gasparin	12:29
escaping arrays in perl dbi	Vincent Stoessel	14:12
Re: escaping arrays in perl dbi	Tod McQuillin	14:36
Bad time external representation ''	Heiko	14:37
Re: escaping arrays in perl dbi	Andrew Perrin	14:44
Re: escaping arrays in perl dbi	Dave Carrigan	15:28
Re: Can this query be faster?	Gabriel Dovalo Carril	18:34
Help with indexes	James Orr	18:45
Re: Help with indexes	James Orr	19:03
Re: having trouble w/ having clause...	Mike Diehl	19:21
Re: escaping arrays in perl dbi	Vincent Stoessel	21:00
Re: escaping arrays in perl dbi	Ian Barwick	23:09

May 10, 2002

Thread	Author	Time
Re: Help with indexes	Christopher Kings-Lynne	02:31
Re: Performance issues with compaq server	Curt Sampson	07:49
Getting full query string from pg_stat_get_backend_activity	Rajesh Kumar Mallah.	09:43
pg_stat_get_backend_pid seems to be listing non existant pids !!	Rajesh Kumar Mallah.	10:26
Re: Getting full query string from pg_stat_get_backend_activity	Jan Wieck	10:38
Re: pg_stat_get_backend_pid seems to be listing non existant	Jan Wieck	10:48
Re: Getting full query string from pg_stat_get_backend_activity	Rajesh Kumar Mallah.	11:08
Re: Help with indexes	Rajesh Kumar Mallah.	11:31
postmaster dead now !!	Rajesh Kumar Mallah.	11:43
Re: postmaster dead now !!	Rajesh Kumar Mallah.	11:49
pg_ctl stop does not work.	Rajesh Kumar Mallah.	11:55
core file found...	Rajesh Kumar Mallah.	12:02
Re: core file found...	Tom Lane	15:56
Re: Bad time external representation ''	Stephan Szabo	16:05
Re: Performance on update from join	Tom Lane	17:44
Why very high CPU usage	Samuel J. Sutjiono	19:38
Re: [SQL] Why very high CPU usage	Josh Berkus	20:52
Re: Why very high CPU usage	Shaun Thomas	21:41
Re: Why very high CPU usage	grant	23:19

May 11, 2002

Thread	Author	Time
Very high load average but no cpu utilization ?	Rajesh Kumar Mallah.	04:37
Re: core file found...	Rajesh Kumar Mallah.	04:49
Further info : Very high load average but no cpu utilization ?	Rajesh Kumar Mallah.	05:05
Re: core file found...	Tom Lane	15:01
Re: pg_stat_get_backend_pid seems to be listing non existant	Tom Lane	15:32
Re: Further info : Very high load average but no cpu utilization ?	Tom Lane	15:59

May 12, 2002

Thread	Author	Time
Re: core file found...	Rajesh Kumar Mallah.	05:40
Re: Further info : Very high load average but no cpu utilization ?	Rajesh Kumar Mallah.	05:46
Re: core file found...	Gaetano Mendola	10:24
Re: Further info : Very high load average but no cpu utilization ?	D'Arcy J.M. Cain	11:05
Re: Further info : Very high load average but no cpu utilization ?	Tom Lane	15:37

May 13, 2002

Thread	Author	Time
Re: Further info : Very high load average but no cpu utilization ?	Rajesh Kumar Mallah.	04:50
Re: having trouble w/ having clause...	Wolfgang.Fuertbauer	06:35
Re: Migrating from 7.1 to 7.2	Wolfgang.Fuertbauer	07:12
Re: Migrating from 7.1 to 7.2	Christopher Kings-Lynne	07:25
Re: Further info : Very high load average but no cpu utilization ?	D'Arcy J.M. Cain	10:21
Re: Further info : Very high load average but no cpu utilization ?	Rajesh Kumar Mallah.	12:04
timestamp and datestyles	Edipo Elder Fernandes de Melo	13:27
Various PostgreSQL questions	Marc SCHAEFER	16:33
pg_dumpall	Oleg Lebedev	21:28

May 14, 2002

Thread	Author	Time
Re: Various PostgreSQL questions	Christopher Kings-Lynne	01:47
Re: Various PostgreSQL questions	Tom Lane	02:11
date_part, how to use	juerg.rietmann	09:29
order by <something wierd>	Mathieu Arnold	11:49
Re: order by <something wierd>	Marin Dimitrov	12:01
Re: order by <something wierd>	Mathieu Arnold	12:04
Re: order by <something wierd>	Joel Burton	12:05
Re: order by <something wierd>	D'Arcy J.M. Cain	12:07
sort text field numerically	Frank Morton	12:23
Re: date_part, how to use	Joel Burton	12:27
Re: order by <something wierd>	Mathieu Arnold	12:28
Re: sort text field numerically	Joel Burton	12:43
Re: order by <something wierd>	Christoph Haller	13:58
aggregate...	Mathieu Arnold	16:13
can't cast varchar as integer?	Scott Royston	18:56
Re: aggregate...	Tom Lane	20:13
CHECK CONSTRAINT blunder(s)	Thomas Good	20:50
Re: can't cast varchar as integer?	Joel Burton	21:20
Re: can't cast varchar as integer?	David Stanaway	21:47
Re: pg_dumpall	Oleg Lebedev	22:15
Re: [SQL] can't cast varchar as integer?	Scott Royston	23:02
Re: can't cast varchar as integer?	Tom Lane	23:29

May 15, 2002

Thread	Author	Time
Re: order by <something wierd>	Christopher Kings-Lynne	02:06
Re: date_part, how to use	Christopher Kings-Lynne	02:07
Re: date_part, how to use	Joel Burton	03:23
Re: date_part, how to use	Christopher Kings-Lynne	03:31
some questions	Ang Tun Chek	04:49
Re: CHECK CONSTRAINT blunder(s) 📎	Christopher Kings-Lynne	05:23
Re: some questions	Christopher Kings-Lynne	09:22
Re: some questions	Adam Witney	09:23
Re: Various PostgreSQL questions	Marc SCHAEFER	10:00
Help on indexes	Stephane DEWITTE	12:08
Re: some questions	Roberto Mello	14:49
Re: Help on indexes	Josh Berkus	15:19

May 16, 2002

Thread	Author	Time
Rules and Triggers	Ludwig Lim	04:59
how to build this list ?	juerg.rietmann	12:38
Re: Rules and Triggers	Josh Berkus	15:12
trigger question	Larry Rosenman	17:38
Re: trigger question	Josh Berkus	17:49
Re: trigger question	Larry Rosenman	17:51
Re: trigger question	Josh Berkus	18:05
Re: trigger question	Scott Shattuck	18:33
Constraint problem	Josh Berkus	18:48
SQL over my head...	Gregory Brauer	19:10
Re: Constraint problem	Stephan Szabo	19:11
Re: Constraint problem	Josh Berkus	19:12
Re: Constraint problem	Josh Berkus	19:30
Re: SQL over my head...	Joel Burton	20:14
Re: SQL over my head...	Joel Burton	20:21
Re: SQL over my head...	Gregory Brauer	20:39
Re: Constraint problem	Stephan Szabo	20:39
Re: SQL over my head...	Joel Burton	20:43
Re: Constraint problem	Josh Berkus	20:49
How can I tell the performance difference?	Josh Berkus	21:29
Re: SQL over my head...	Gregory Brauer	21:54
Re: How can I tell the performance difference?	Joe Conway	22:22

May 17, 2002

Thread	Author	Time
Re: Constraint problem	Stephan Szabo	01:12
Re: Constraint problem	Christopher Kings-Lynne	02:22
Re: Constraint problem	Josh Berkus	04:40
Re: how to build this list ?	Masaru Sugawara	16:51
Re: Rules and Triggers	Jan Wieck	18:19
Re: Constraint problem	Stephan Szabo	18:42
Rules and variables?	Christian Rishoej	23:39
Re: Rules and variables?	Josh Berkus	23:53

May 18, 2002

Thread	Author	Time
PL/pgSQL TODO	Josh Berkus	00:19
Re: PL/pgSQL TODO	Tom Lane	02:04
Casting timestamp	Edipo E. F. Melo	23:54

May 19, 2002

Thread	Author	Time
Re: Casting timestamp	Joel Burton	13:43
count(boolean)	Dan MacNeil	14:16
Re: count(boolean)	Joel Burton	14:58
A proposal for Interval Math	Josh Berkus	20:36
Re: Casting timestamp	Edipo E. F. Melo	20:43
Re: A proposal for Interval Math	Oliver Elphick	20:58
Re: A proposal for Interval Math	Josh Berkus	21:21

May 20, 2002

Thread	Author	Time
Re: A proposal for Interval Math	Oliver Elphick	07:54
Using LASTOID in one query	Eckhard Hoeffner	14:08
Re: Using LASTOID in one query	Joel Burton	14:24
Re: count(boolean)	Jean-Luc Lachance	15:08
Re: Using LASTOID in one query	Masaru Sugawara	15:31
Re: A proposal for Interval Math	Josh Berkus	16:03
Re: count(boolean)	Jean-Luc Lachance	16:07
Re: Using LASTOID in one query	Eckhard Hoeffner	16:10
Re: A proposal for Interval Math	Oliver Elphick	18:35
[INIMSS] problem with user privileges	Dino	18:36
Guarantee uniqueness of PGP key	andre	20:17
Bug with Daylight Savings Time & Interval	Josh Berkus	22:34

May 21, 2002

Thread	Author	Time
Re: [SQL] Guarantee uniqueness of PGP key	Joel Burton	00:21
Re: MacOS X Shared Buffers (SHMMAX)?	Steve Lane	01:59
MacOS X Shared Buffers (SHMMAX)?	Command Prompt, Inc.	02:25
Re: Guarantee uniqueness of PGP key	D. Duccini	02:37
Re: [SQL] Bug with Daylight Savings Time & Interval	Tom Lane	02:47
Re: MacOS X Shared Buffers (SHMMAX)?	Tom Lane	03:09
Re: [SQL] Bug with Daylight Savings Time & Interval	Josh Berkus	05:57
drop constraint problem	Wolfgang.Fuertbauer	07:12
constraints for ensuring relationships	Markus Wagner	10:08
Re: Guarantee uniqueness of PGP key	Bruno Wolff III	11:54
Re: Guarantee uniqueness of PGP key	andre	11:56
Re: drop constraint problem	Joel Burton	13:10
Re: constraints for ensuring relationships	Stephan Szabo	14:43

Browse Archives

Prev | Next