pgsql-sql since 2003-04-19 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

April 19, 2003

Thread Author Time
Re: Truly bizarre behavior with VACUUM FULL? Tom Lane 00:13
Re: Truly bizarre behavior with VACUUM FULL? Josh Berkus 01:49
Re: Truly bizarre behavior with VACUUM FULL? Tom Lane 01:54
apparent problem with a PL Rajesh Kumar Mallah 05:59
replicable problem with PL/Perl Rajesh Kumar Mallah 06:46
Re: apparent problem with a PL Stephan Szabo 06:50
Re: How to retrieve object definition? A.Bhuvaneswaran 06:55
Re: apparent problem with a PL Rajesh Kumar Mallah 07:08
Where is the sequence value? Edipo E. F. Melo 11:50
Where is the sequence value? Edipo E. F. Melo 11:50
Re: [SQL] Yet Another (Simple) Case of Index not used Kevin Brown 13:01
Re: Where is the sequence value? Tom Lane 15:51
Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane 15:58
[REPOST] replicable problem with PL/Perl Rajesh Kumar Mallah 16:06
Re: apparent problem with a PL Stephan Szabo 16:30
Re: replicable problem with PL/Perl Tom Lane 16:34
Re: apparent problem with a PL Rajesh Kumar Mallah 16:42
Re: replicable problem with PL/Perl Rajesh Kumar Mallah 16:42
Re: [SQL] Yet Another (Simple) Case of Index not used Josh Berkus 19:03
Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane 20:26

April 20, 2003

Thread Author Time
Re: [SQL] Yet Another (Simple) Case of Index not used Kevin Brown 01:13
Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane 03:34
Re: [SQL] Yet Another (Simple) Case of Index not used Kevin Brown 06:28
Re: [SQL] Yet Another (Simple) Case of Index not used Andreas Pflug 10:07
Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane 15:21
Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane 15:25
Re: [SQL] Yet Another (Simple) Case of Index not used Andreas Pflug 15:37
Re: [SQL] Yet Another (Simple) Case of Index not used Andrew Sullivan 16:46
Re: replicable problem with PL/Perl Tom Lane 22:29

April 21, 2003

Thread Author Time
Re: [SQL] Yet Another (Simple) Case of Index not used Kevin Brown 00:46
Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane 01:53
Ok,, what about cache for SEQUENCE - where? how? foo2 04:25
Re: New to SQL; hopefully simple question foo2 04:28
Optomizing left outer joins Lorraine Dewey 15:14
Re: [SQL] Yet Another (Simple) Case of Index not used Josh Berkus 16:14
functions problems Mario Alberto Soto Cordones 20:48
Re: functions problems Randall Lucas 21:24
PROBLEM WITH FUNCTIONS Mario Alberto Soto Cordones 21:38
Re: PROBLEM WITH FUNCTIONS Randall Lucas 21:46
converting from bigint to bit to use bitwise operators Aditya 21:50
Re: converting from bigint to bit to use bitwise operators Randall Lucas 21:55
Re: PROBLEM WITH FUNCTIONS Mario Alberto Soto Cordones 21:58

April 22, 2003

Thread Author Time
trouble creating trigger Sigi Jekabsons 02:28
Re: trouble creating trigger Stephan Szabo 03:58
Re: [SQL] Yet Another (Simple) Case of Index not used Jim C. Nasby 08:23
Re: [SQL] Yet Another (Simple) Case of Index not used Christopher Kings-Lynne 08:33
RelationForgetRelation error in postgres 7.2.2 Bharath Seshadri 10:00
Re: trouble creating trigger A.Bhuvaneswaran 12:20
SQL Reserved words DUDLEY,DONALD (HP-Boise,ex1) 15:57
FUNCTION ERROR Mario Alberto Soto Cordones 21:17
Re: FUNCTION ERROR Stephan Szabo 21:24

April 23, 2003

Thread Author Time
how to put an special code in a string jack 02:33
Re: how to put an special code in a string Tomasz Myrta 06:50
is there a special function like the format on raise notice jack 08:52
Re: is there a special function like the format on raise notice Tomasz Myrta 09:16
Oracle 9i under RedHat Linux 8.0 - Simple Installation: Getting started Rajesh Kumar Mallah 10:38
Re: how to put an special code in a string Jeff Eckermann 13:56
Invoice Numbers Bruce Williams 15:44
Why is seq search preferred here by planner? mallah 16:21
Re: [SQL] Yet Another (Simple) Case of Index not used Greg Stark 16:32
Re: Why is seq search preferred here by planner? Josh Berkus 17:00
Re: Why is seq search preferred here by planner? mallah 17:12
Re: Why is seq search preferred here by planner? Josh Berkus 17:21
Re: New to SQL; hopefully simple question Rod Taylor 17:40
Re: Optomizing left outer joins Rod Taylor 17:48
Re: Why is seq search preferred here by planner? mallah 17:54
Re: OUTER JOIN Richard Huxton 17:55
Re: SQL Reserved words Stephan Szabo 18:11
Re: Why is seq search preferred here by planner? Josh Berkus 18:20
Why doesn't EXPLAIN ANALYZE show UPDATE step? Josh Berkus 18:23
Re: Deadlock problem Rod Taylor 18:28
Re: Invoice Numbers Richard Huxton 18:30
Re: Optomizing left outer joins Josh Berkus 18:49
Re: Why is seq search preferred here by planner? mallah 18:51
Re: Why is seq search preferred here by planner? Josh Berkus 19:53
Re: Why is seq search preferred here by planner? mallah 20:13
Re: Why is seq search preferred here by planner? Josh Berkus 20:21
Re: Ok,, what about cache for SEQUENCE - where? how? Bruno Wolff III 20:29
Re: Optomizing left outer joins Josh Berkus 20:51

April 24, 2003

Thread Author Time
Re: Optomizing left outer joins Tom Lane 02:37
Re: Why doesn't EXPLAIN ANALYZE show UPDATE step? Tom Lane 02:46
Unicode, RedHat Linux, & PostgreSQL Vernon 04:18
Statement triggers 7.4 NEW/OLD Andreas Pflug 11:41
rewriting values with before trigger Robert Treat 16:25
Re: [SQL] rewriting values with before trigger Josh Berkus 16:39
Re: rewriting values with before trigger Nigel J. Andrews 16:46
Re: [SQL] rewriting values with before trigger Robert Treat 18:38
Fwd: Unicode, RedHat Linux, & PostgreSQL Vernon 18:40
Rule definition problem Jamie Lawrence 19:05
Re: [SQL] rewriting values with before trigger Dennis Gearon 19:10
Rule definition problem Jamie Lawrence 19:11
Re: [SQL] rewriting values with before trigger Robert Treat 19:22
Re: [SQL] rewriting values with before trigger Dennis Gearon 19:35
Re: [SQL] rewriting values with before trigger Robert Treat 19:49
Re: [SQL] rewriting values with before trigger Dennis Gearon 20:35
Re: [SQL] rewriting values with before trigger nolan 21:18
Re: [SQL] rewriting values with before trigger Matthew Nuzum 21:31
Re: [SQL] rewriting values with before trigger Nigel J. Andrews 21:53
Re: [SQL] rewriting values with before trigger Tom Lane 22:02

April 25, 2003

Thread Author Time
Re: [SQL] rewriting values with before trigger elein 00:28
Re: [SQL] rewriting values with before trigger Robert Treat 04:03
sorting chinese characters prabahar 08:22
renaming foreign key pginfo 10:41
Re: Fwd: Unicode, RedHat Linux, & PostgreSQL pginfo 10:46
Can I using function with insert or update? maggie 11:14
PL/PgSQL Question Brian Knox 15:52
/* */ comments showing up in pg_stat_activity Rajesh Kumar Mallah 16:10
Re: /* */ comments showing up in pg_stat_activity Bruce Momjian 16:17
Re: [SQL] rewriting values with before trigger Josh Berkus 17:20
Re: [SQL] rewriting values with before trigger Dennis Gearon 17:47
Re: sorting chinese characters Ian Barwick 18:10
Re: Fwd: Unicode, RedHat Linux, & PostgreSQL Vernon 18:44
Re: [SQL] rewriting values with before trigger elein 18:57

April 26, 2003

Thread Author Time
create/alter/drop within transactions? Forest Wilkinson 00:48
create/alter/drop within transactions? Forest Wilkinson 00:58
Re: sorting chinese characters prabahar 01:55
Re: create/alter/drop within transactions? Tom Lane 02:18
Re: Statement triggers 7.4 NEW/OLD Jan Wieck 02:32
Re: /* */ comments showing up in pg_stat_activity Jan Wieck 02:47
Re: /* */ comments showing up in pg_stat_activity Tom Lane 03:05
Re: Statement triggers 7.4 NEW/OLD Josh Berkus 04:20
Re: /* */ comments showing up in pg_stat_activity Rajesh Kumar Mallah 04:48
Re: sorting chinese characters Ian Barwick 06:52
Re: Statement triggers 7.4 NEW/OLD Andreas Pflug 08:50
Re: PL/PgSQL Question A.Bhuvaneswaran 08:53
Re: Fwd: Unicode, RedHat Linux, & PostgreSQL Troy 13:07
Re: /* */ comments showing up in pg_stat_activity Bruce Momjian 14:05
Re: /* */ comments showing up in pg_stat_activity Rajesh Kumar Mallah 16:37
Re: create/alter/drop within transactions? Rajesh Kumar Mallah 17:16

April 27, 2003

Thread Author Time
Re: sorting chinese characters Tatsuo Ishii 00:53
EASY QUESTION!! dvsangel 08:03
Re: EASY QUESTION!! David W Noon 10:30
Second maximum value Marco Bubke 10:37
Re: Second maximum value Tom Lane 16:12

April 28, 2003

Thread Author Time
Re: Pl Pgsql problem Tomasz Myrta 08:54
Pl Pgsql problem lihao 09:15
Re: Pl Pgsql problem Tomasz Myrta 09:20
Re: Pl Pgsql problem lihao 09:29
Re: Rule definition problem Christoph Haller 09:29
Re: Pl Pgsql problem lihao 10:14
plpgsql Question.. Rajesh Kumar Mallah 12:12
Re: plpgsql Question.. Rod Taylor 13:00
Re: plpgsql Question.. Rajesh Kumar Mallah 13:23
Re: plpgsql Question.. Rajesh Kumar Mallah 13:31
Re: plpgsql Question.. Rod Taylor 13:46
replace function rute solipa 15:02
Re: plpgsql Question.. Rajesh Kumar Mallah 15:05
Re: replace function Rajesh Kumar Mallah 15:08
Re: replace function rute solipa 15:12
Re: replace function Victor Yegorov 15:13
Re: jsp postgres installation/configuration howto url Michael Teter 15:28
Re: replace function Rajesh Kumar Mallah 15:45
help query rute solipa 15:53
Re: help query Rajesh Kumar Mallah 15:56
jsp postgres installation/configuration howto url Joseph Syjuco 17:33
Re: /* */ comments showing up in pg_stat_activity Bruce Momjian 22:19

April 29, 2003

Thread Author Time
Re: plpgsql Question.. mallah 00:14
PERFORM / FOUND, what's up? Martin Brommer 08:21
ALERT column Rado Petrik 09:14
Re: help query rute solipa 09:48
differences between oracle,pgsql,sybase vikas baid 10:12
Re: help query Victor Yegorov 10:44
Re: ALERT column Richard Huxton 11:31
Query Plan far worse in 7.3.2 than 7.2.1 SZŰCS Gábor 13:01
Re: Query Plan far worse in 7.3.2 than 7.2.1 Tom Lane 14:53
How I write pretty query. Radovan Petrikí 15:49
Re: Query Plan far worse in 7.3.2 than 7.2.1 📎 SZŰCS Gábor 16:03
How I write pretty query Rado Petrik 17:46
Re: How I write pretty query Stephan Szabo 17:55
Making "SECURITY DEFINER" procedures.. Sergey Holod 20:53
Making "SECURITY DEFINER" procedures.. Sergey Holod 20:58
Re: Making "SECURITY DEFINER" procedures.. Stephan Szabo 21:03
Re: Making "SECURITY DEFINER" procedures.. Sergey Holod 21:16
Re: Making "SECURITY DEFINER" procedures.. Stephan Szabo 22:10
Re: Query Plan far worse in 7.3.2 than 7.2.1 Tom Lane 23:05
Re: Making "SECURITY DEFINER" procedures.. Sergey Holod 23:18
Re: Making "SECURITY DEFINER" procedures.. - SOLVED Sergey Holod 23:56

April 30, 2003

Thread Author Time
unsubscribe David Durst 01:00
rules question ed despard 04:00
Re: Making "SECURITY DEFINER" procedures.. - SOLVED Tom Lane 04:10
Re: Making "SECURITY DEFINER" procedures.. - SOLVED Stephan Szabo 04:55
Re: rules question Richard Huxton 09:26
Re: Query Plan far worse in 7.3.2 than 7.2.1 SZŰCS Gábor 11:00
Query Plan far worse in 7.3.2 than 7.2.1 📎 Peter Darley 14:39
Re: Query Plan far worse in 7.3.2 than 7.2.1 Tom Lane 14:54
Re: Query Plan far worse in 7.3.2 than 7.2.1 Peter Darley 15:09
Re: [SQL] 7.3 analyze & vacuum analyze problem Josh Berkus 16:03
Like search performance. Diehl, Jeffrey 16:34
Stored Procedure Question Martin Chantler 16:52
Re: Like search performance. SZUCS Gábor 16:59
Re: Like search performance. Nikolaus Dilger 17:08
Re: Like search performance. Josh Berkus 17:33
Re: Stored Procedure Question Stephan Szabo 18:03
Re: Stored Procedure Question Rajesh Kumar Mallah 18:03
Re: differences between oracle,pgsql,sybase Rajesh Kumar Mallah 18:10
Re: [SQL] 7.3 analyze & vacuum analyze problem Josh Berkus 18:48
Re: EASY QUESTION!! Josh Berkus 20:41
7.3 analyze & vacuum analyze problem 📎 Achilleus Mantzios 20:57
Re: [SQL] 7.3 analyze & vacuum analyze problem Achilleus Mantzios 21:13
Re: [SQL] 7.3 analyze & vacuum analyze problem Ron Mayer 22:16

Browse Archives

Prev | Next