pgsql-sql - May 2002

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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

May 1, 2002

Thread Author Time
Re: convert from sybase to postgresql Nick Fankhauser 16:37
Problems returning multiple columns Travis Hoyt 16:51
Re: problem with update from subselect Stephan Szabo 16:55
Re: problem with update from subselect Joe Conway 17:09
problem with update from subselect Gary Stainburn 17:29
CREATE VIEW question... j.konzack 19:53
Re: CREATE VIEW question... Oliver Elphick 20:51

May 2, 2002

Thread Author Time
Re: CREATE VIEW question... Joel Burton 03:17
Re: join-performance problem Wolfgang.Fuertbauer 08:00
Weird select output... Rajesh Kumar Mallah. 09:16
Re: Weird select output... Rajesh Kumar Mallah. 09:36
Re: join-performance problem Tom Lane 13:58
get transaction no. wit 15:06
Subselect performance question Josh Berkus 16:37
Re: Subselect performance question Manfred Koizar 20:47
Re: Subselect performance question Tom Lane 20:56
Re: Subselect performance question Josh Berkus 22:38

May 3, 2002

Thread Author Time
Odd behavior with timestamp/interval arithmetic Joseph Barillari 20:38
Returning composite types from a plpgsql function Joseph Barillari 21:24
Re: Odd behavior with timestamp/interval arithmetic Josh Berkus 21:59
Re: Returning composite types from a plpgsql function Tom Lane 22:24

May 4, 2002

Thread Author Time
difficult query Jakub Ouhrabka 14:00
Re: difficult query Ian Barwick 15:44
Re: difficult query Jakub Ouhrabka 17:34
Syntax error in plpgsql crashes backend Joseph Barillari 18:09
Re: difficult query Ian Barwick 18:19
Re: Syntax error in plpgsql crashes backend Joseph Barillari 18:19
Re: Syntax error in plpgsql crashes backend dman 18:35
Re: Syntax error in plpgsql crashes backend Joseph Barillari 18:44
Re: difficult query (fwd) Jakub Ouhrabka 19:21
More long-string woes Joseph Barillari 20:57
Re: Syntax error in plpgsql crashes backend Roberto Mello 23:26
INserting images in postgres sharmad 23:31

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31