pgsql-sql since 2003-04-29 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 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

May 1, 2003

Thread Author Time
Re: [SQL] 7.3 analyze & vacuum analyze problem Tom Lane 00:10
Re: [SQL] 7.3 analyze & vacuum analyze problem Christopher Kings-Lynne 01:51
Re: PERFORM / FOUND, what's up? Tom Lane 01:53
Re: Stored Procedure Question Roberto Mello 02:16
How to write an query to get this result? Daniel Dunajsky 03:07
How to write a sql query to get this result? Daniel 03:31
Date Problem Ramesh PAtel 06:36
Re: How to write a sql query to get this result? Tomasz Myrta 06:40
Re: Date Problem Rajesh Kumar Mallah 08:51
Re: Date Problem Stuart 09:38
date use in for loop Ramesh PAtel 11:30
Re: How to write a sql query to get this result? Bruno Wolff III 12:38
Re: date use in for loop Josh Berkus 17:04

May 2, 2003

Thread Author Time
implied FROM Matt Mello 02:06
Re: differences between oracle,pgsql,sybase A.Bhuvaneswaran 04:45
Re: differences between oracle,pgsql,sybase Oliver Elphick 06:16
Re: implied FROM Tomasz Myrta 07:14
It's About field type array Yudha [ Inas_Husband ] Setiawan 08:22
Re: How to write an query to get this result? Richard Huxton 08:48
Re: Problem with old relation Andreas Schmitz 12:08
Problem with old relation Rado Petrik 12:20
Re: Problem with old relation A.Bhuvaneswaran 12:54
timeofday() and now() issue.. Rajesh Kumar Mallah 13:14
What is bad in this query ? Rado Petrik 13:21
Re: implied FROM Matt Mello 13:44
Re: What is bad in this query ? Rod Taylor 14:32
Re: timeofday() and now() issue.. Tom Lane 14:57
Re: timeofday() and now() issue.. Rajesh Kumar Mallah 15:07
Re: timeofday() and now() issue.. Tom Lane 15:16
Re: timeofday() and now() issue.. Rajesh Kumar Mallah 15:36
Re: implied FROM Bruno Wolff III 16:04
Re: implied FROM Josh Berkus 16:13
Re: [SQL] 7.3 analyze & vacuum analyze problem Achilleus Mantzios 16:29
Re: implied FROM Stephan Szabo 16:33
Re: [SQL] 7.3 analyze & vacuum analyze problem Achilleus Mantzios 19:03
Re: What is bad in this query ? Achilleus Mantzios 19:07
Re: What is bad in this query ? Chris Gamache 20:46
How to increase precision? Katka a Daniel Dunajsky 21:38
Best way to delete time stamped data? Kyle 22:06
Re: How to increase precision? Steve Crawford 22:13
Re: How to increase precision? Josh Berkus 22:32
Time formating Katka a Daniel Dunajsky 22:33
Re: How to increase precision? Stephan Szabo 22:42
Re: Best way to delete time stamped data? Steve Crawford 22:51
Re: Time formating Stephan Szabo 23:11
Re: Best way to delete time stamped data? Josh Berkus 23:19

May 3, 2003

Thread Author Time
Re: timeofday() and now() issue.. A.Bhuvaneswaran 05:13
Re: timeofday() and now() issue.. Rajesh Kumar Mallah 07:32
problem with max and not using index on PK pginfo 09:12
Re: problem with max and not using index on PK Philip Warner 12:04
Re: problem with max and not using index on PK pginfo 12:36

May 4, 2003

Thread Author Time
Re: timeofday() and now() issue.. Rajesh Kumar Mallah 10:47
Re: [SQL] Best way to delete time stamped data? Kyle 13:09
Re: [SQL] Best way to delete time stamped data? Jim C. Nasby 16:30
Re: [SQL] Best way to delete time stamped data? Jean-Luc Lachance 17:12

May 5, 2003

Thread Author Time
Re: Best way to delete time stamped data? Rajesh Kumar Mallah 09:56
Indices are not used by the optimizer Reiner Dassing 12:16
Re: Best way to delete time stamped data? Bruno Wolff III 13:32
Re: Indices are not used by the optimizer Rod Taylor 13:33
UNICODE and SQL Marco Roda 13:34
Re: UNICODE and SQL Ian Barwick 14:37
Re: Replication for a large database Ryan 16:16
Re: UNICODE and SQL Ian Barwick 16:48
Replication for a large database Michael A Nachbaur 16:52
Re: [SQL] Indices are not used by the optimizer Achilleus Mantzios 18:38
mnogosearch examples Alex Rice 18:59
2 simple SQL questions: optimizing aggegate query Alex Rice 18:59
Re: Replication for a large database Michael Teter 19:19
Re: UNICODE and SQL Achilleus Mantzios 19:22
Re: Replication for a large database Michael A Nachbaur 19:26
Re: Replication for a large database Michael A Nachbaur 19:28
Re: 2 simple SQL questions: optimizing aggegate query Bruno Wolff III 19:45
pgsql Replication Proxy (was Re: Replication for a large database) Michael A Nachbaur 19:57
Re: 2 simple SQL questions: optimizing aggegate query Alex Rice 20:03
Re: UNICODE and SQL Achilleus Mantzios 20:24
Re: Replication for a large database Jeff Eckermann 22:39

May 6, 2003

Thread Author Time
Re: 2 simple SQL questions: optimizing aggegate query Bruno Wolff III 01:28
Re: mnogosearch examples Rajesh Kumar Mallah 06:37
Cast type int2vector/array_field to character Mr.F 08:04
Re: UNICODE and SQL Marco Roda 09:05
Problem with Attribute. Rado Petrik 09:17
Re: Problem with Attribute. Popeanga Marian 09:50
Re: Problem with Attribute. Victor Yegorov 09:55
pg_ ? Popeanga Marian 12:02
VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 SZŰCS Gábor 12:22
Re: pg_ ? Rajesh Kumar Mallah 12:59
Re: pg_ ? A.Bhuvaneswaran 13:22
Re: pg_ ? A.Bhuvaneswaran 13:36
Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 SZUCS Gabor 13:52
Re: Cast type int2vector/array_field to character Achilleus Mantzios 13:56
Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 Stephan Szabo 14:32
Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 Tom Lane 14:35
Re: Problem with Attribute. Achilleus Mantzios 15:01
pg_stat_activity IP address alexandre :: aldeia digital 15:55
UNIQUE boolean: only one row may be "true" Randall Lucas 16:01
Re: pgsql Replication Proxy (was Re: Replication for a Diehl, Jeffrey 16:28
Re: UNIQUE boolean: only one row may be "true" Michael Teter 17:13
Re: UNIQUE boolean: only one row may be "true" Bruno Wolff III 17:23
Re: UNIQUE boolean: only one row may be "true" chester c young 17:26
Re: pgsql Replication Proxy (was Re: Replication for a Michael A Nachbaur 17:40
Re: pgsql Replication Proxy (was Re: Replication for a Diehl, Jeffrey 17:45
Re: pg_ ? Achilleus Mantzios 17:48
Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 Achilleus Mantzios 17:53
Re: pgsql Replication Proxy (was Re: Replication for a Mendola Gaetano 17:54
Re: pgsql Replication Proxy (was Re: Replication for a Michael A Nachbaur 18:16
Utils/case for create relation db under Linux Rado Petrik 18:24
Re: UNIQUE boolean: only one row may be "true" Randall Lucas 18:46
Re: pg_ ? Achilleus Mantzios 18:46
Re: pgsql Replication Proxy (was Re: Replication for a Wei Weng 19:10
Re: 2 simple SQL questions: optimizing aggegate query Alex Rice 19:28
Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 Achilleus Mantzios 19:32
Re: pgsql Replication Proxy (was Re: Replication for a Michael A Nachbaur 20:01
Date Anomaly?? Thomas Good 20:05
Re: pgsql Replication Proxy (was Re: Replication for a Steve Crawford 20:42
Re: Date Anomaly?? Ian Barwick 21:19
"deadlock detected" documentation Matt Mello 21:48

May 7, 2003

Thread Author Time
Re: UNIQUE boolean: only one row may be "true" Tom Lane 03:00
Re: "deadlock detected" documentation Tom Lane 04:46
Re: "deadlock detected" documentation A.Bhuvaneswaran 04:58
Re: UNIQUE boolean: only one row may be "true" Ries van Twisk 07:34
SQl query Abdul Wahab Dahalan 08:20
Re: SQl query Matthew Horoschun 08:34
Re: SQl query Victor Yegorov 08:57
Re: SQl query DIB Walid 09:00
Re: SQl query A.Bhuvaneswaran 09:21
Re: pgsql Replication Proxy (was Re: Replication for a Mendola Gaetano 09:26
Re: pg_ ? Popeanga Marian 11:35
Re: Date Anomaly?? Thomas Good 13:14
Re: An unresolved performance problem. Hannu Krosing 13:40
Re: Date Anomaly?? Tom Lane 14:31
index fragmentation Wei Weng 14:47
ERROR: pg_atoi: error in "NULL": can't parse "NULL" Rado Petrik 14:57
Re: Date Anomaly?? Thomas Good 15:04
array in a reference Ries van Twisk 15:07
Re: An unresolved performance problem. Josh Berkus 15:26
Re: [SQL] An unresolved performance problem. Mendola Gaetano 15:36
Re: Date Anomaly?? Josh Berkus 15:36
Re: ERROR:Â pg_atoi: error in "NULL": can't parse "NULL" Josh Berkus 15:37
Re: Date Anomaly?? Bruno Wolff III 15:39
Re: An unresolved performance problem. scott.marlowe 15:42
Re: ERROR:   pg_atoi: error in "NULL": can't Jean-Luc Lachance 15:47
Re: Date Anomaly?? Stephan Szabo 15:52
Re: array in a reference Stephan Szabo 15:53
help database corruption mdc 15:56
Re: Date Anomaly?? Thomas Good 16:02
Re: Date Anomaly?? Tom Lane 16:13
An unresolved performance problem. Achilleus Mantzios 16:33
PostgreSQL Qs Jon Earle 16:35
index defragmentation Wei Weng 16:47
Re: Unanswered Questions WAS: An unresolved performance problem. Josh Berkus 16:57
Re: index defragmentation D'Arcy J.M. Cain 17:17
Re: index defragmentation Josh Berkus 17:21
Re: index defragmentation Richard Huxton 17:21
Re: PostgreSQL Qs Richard Huxton 17:32
"too clever" when creating SQL functions SZŰCS Gábor 17:51
Re: [GENERAL] PostgreSQL Qs mallah 18:01

Browse Archives

Prev | Next