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

April 25, 2002

Thread Author Time
Pl/pgSQL Question. Bruno Ricardo Sacco 04:34
Pl/pgSQL Question. Bruno Ricardo Sacco 04:44
SELECT in a function != SELECT ? Ian Morgan 05:44
Re: SELECT in a function != SELECT ? Joe Conway 06:13
Database Server in Recovery mode! Rajesh Kumar Mallah 06:52
followups : Database Server in Recovery mode! Rajesh Kumar Mallah 07:06
Re: Database Server in Recovery mode! Rajesh Kumar Mallah 07:10
HAVING - clause Morten Sickel 09:32
Proper quoting of \e ? Helge Kreutzmann 10:22
Re: How to discover foreign keys (without pulling hair out) bob lapique 12:27
Re: HAVING - clause Christoph Haller 12:44
Again: Identity not discovered by planner? Daniel Lundin 13:08
Re: SELECT in a function != SELECT ? Jan Wieck 13:53
Re: Database Server in Recovery mode! Stephan Szabo 14:37
Re: Connection authentication Bruce Momjian 14:43
copy command Duncan Adams (DNS) 14:53
Re: Proper quoting of \e ? Bruce Momjian 15:47
Re: Proper quoting of \e ? Helge Kreutzmann 15:57
Re: Proper quoting of \e ? Joe Conway 16:23
Re: SELECT in a function != SELECT ? David Stanaway 16:46
Re: Again: Identity not discovered by planner? Tom Lane 16:57
Re: How to discover foreign keys (without pulling hair out) Ian Morgan 17:04
Collection of PostgreSQL Performance Tips Brubaker, Shane 17:25
Re: copy command ARP 18:34
Re: HAVING - clause Bill Cunningham 18:51

April 26, 2002

Thread Author Time
Re: copy command svilen 00:39
Re: Database Server in Recovery mode! Rajesh Kumar Mallah 05:43
Use of indexes Andre Schubert 07:09
Re: Use of indexes Christopher Kings-Lynne 07:30
abnormal size of the on-disk file. Rajesh Kumar Mallah 14:52
Wierd error for COPY command Josh Berkus 15:42
How do I create unique IDs for an existing set of records Nick Fankhauser 15:58
union query format Robert Wynter 16:04
Re: view on system tables upgrade? Tom Lane 16:04
Re: Wierd error for COPY command Tom Lane 16:11
Re: How do I create unique IDs for an existing set of records Tom Lane 16:14
Re: How do I create unique IDs for an existing set of records Nick Fankhauser 16:17
Re: Wierd error for COPY command Josh Berkus 16:51
view on system tables upgrade? Christoph Haller 17:05
Re: Wierd error for COPY command Josh Berkus 17:15
Re: Wierd error for COPY command PG Explorer 17:25
Wierd query behaviour Josh Berkus 19:38
Re: Connection authentication Oleg Lebedev 20:01
Re: union query format Josh Berkus 20:42
Trying to purchase an annual subscription to the CD distribution Wayne Seward 20:45
Re: Connection authentication Ron Peterson 20:49
Trying to purchase an annual subscription to the CD distribution Wayne Seward 20:51
Re: union query format Joel Burton 21:32
Function won't complete Josh Berkus 21:57
Re: Wierd query behaviour Tom Lane 22:43
Re: Function won't complete Tom Lane 22:54

April 27, 2002

Thread Author Time
pg_shadow password Eduardo Gargiulo 04:28
Re: pg_shadow password Bruce Momjian 05:33
Re: Function won't complete Josh Berkus 18:15
Re: Function won't complete Tom Lane 21:36

April 28, 2002

Thread Author Time
Re: Upgrading PostgreSQL to 7.1.3 Gordon Clarke 05:24
Re: Function won't complete Josh Berkus 19:39

April 29, 2002

Thread Author Time
Casting dates Joseph Barillari 00:56
IN, EXISTS or ANY? Josh Berkus 04:44
Re: IN, EXISTS or ANY? Tom Lane 04:54
Re: IN, EXISTS or ANY? Josh Berkus 05:24
Temporary table weirdness Joseph Barillari 06:20
view on system tables upgrade II Christoph Haller 10:24
Re: view on system tables upgrade II Tom Lane 14:02
Re: Temporary table weirdness Bruce Momjian 14:04
Re: Temporary table weirdness Tom Lane 14:12
Re: Casting dates Josh Berkus 16:02
Re: Temporary table weirdness Joseph Barillari 16:07
Re: Casting dates Joseph Barillari 16:19
Re: abnormal size of the on-disk file. Stephan Szabo 16:46
convert from sybase to postgresql Frank Morton 23:08

April 30, 2002

Thread Author Time
join-performance problem Wolfgang.Fuertbauer 15:27
Re: join-performance problem Stephan Szabo 15:58
Re: join-performance problem Tom Lane 16:44
Bug #652: NAMEDATALEN limitations pgsql-bugs 18:15
Re: Bug #652: NAMEDATALEN limitations Tom Lane 18:32
Re: Bug #652: NAMEDATALEN limitations Tom Lane 18:45
Re: Bug #652: NAMEDATALEN limitations Tom Lane 20:04
performance on update table from a join Jean-Luc Lachance 20:34
Re: performance on update table from a join Tom Lane 20:49
Re: performance on update table from a join Jean-Luc Lachance 21:34
Re: performance on update table from a join Tom Lane 21:51
Re: performance on update table from a join Jean-Luc Lachance 22:07
Re: Out of free buffers... HELP! Tom Lane 22:50

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

Browse Archives

Prev | Next