Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
pgsql-sql - May 2002
Prev | Next
2002-05-01
- 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)
2002-05-02
- 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)
2002-05-03
- 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)
2002-05-04
- 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)
2002-05-05
- 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)
2002-05-06
- summary VIEW Gary Stainburn (11:41)
- Re: summary VIEW Gary Stainburn (13:08)
2002-05-07
- 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)
2002-05-08
- 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)
2002-05-09
- 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)
2002-05-10
- 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)
2002-05-11
- 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)
2002-05-12
- 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)
2002-05-13
- 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)
2002-05-14
- 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)
2002-05-15
- 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)
2002-05-16
- 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)
2002-05-17
- 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)
2002-05-18
- PL/pgSQL TODO Josh Berkus (00:19)
- Re: PL/pgSQL TODO Tom Lane (02:04)