pgsql-sql since 2003-05-03 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

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
help database corruption mdc 18:12
help database corruption mdc 18:12
Re: PostgreSQL Qs Jonathan Bartlett 18:16
Re: [GENERAL] PostgreSQL Qs Jon Earle 18:33
Re: An unresolved performance problem. Manfred Koizar 18:42
Re: help database corruption Wei Weng 18:57
Re: An unresolved performance problem. Achilleus Mantzios 19:09
Re: "too clever" when creating SQL functions Richard Huxton 19:10
Re: help database corruption Stephan Szabo 19:16
[No subject] mdc 19:34
Re: [SQL] An unresolved performance problem. Bernd von den Brincken 19:57
Re: PostgreSQL Qs Karsten Hilbert 20:02
Re: PostgreSQL Qs Oliver Elphick 20:03
Re: Stephan Szabo 20:14
Re: PostgreSQL Qs Jon Earle 20:19
Re: PostgreSQL Qs Oliver Elphick 21:40
Re: [GENERAL] PostgreSQL Qs Robert Treat 21:44
PROBLEM WITH UPDATE COMMAND Mario Alberto Soto Cordones 23:21
Re: [SQL] Unanswered Questions WAS: An unresolved performance problem. Randall Lucas 23:52

May 8, 2003

Thread Author Time
Type coercion on column in a query Kenny Mok 00:59
Re: Replication for a large database The Hermit Hacker 01:28
insert rowtype Bryan Klimt 02:23
Timestamp index not used david 03:56
Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem. Tom Lane 04:13
Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem. Sean Chittenden 04:57
Re: Timestamp index not used Tom Lane 05:26
seeing type defination.. Rajesh Kumar Mallah 06:15
A minute in timestamp David Loh 06:40
Re: A minute in timestamp Richard Huxton 07:24
Re: A minute in timestamp Victor Yegorov 07:50
Array dimension as integer 📎 Victor Yegorov 09:57
Re: "too clever" when creating SQL functions SZŰCS Gábor 11:15
Re: An unresolved performance problem. Andrew Sullivan 11:20
Re: [SQL] An unresolved performance problem. Achilleus Mantzios 12:09
Re: An unresolved performance problem. Achilleus Mantzios 12:48
Re: PostgreSQL Qs Bruno Wolff III 13:22
insert rowtype Bryan Klimt 13:58
Re: seeing type defination.. Tom Lane 14:14
Re: PostgreSQL Qs Jon Earle 14:18
Re: An unresolved performance problem. Tom Lane 14:42
Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem. johnnnnnn 14:47
Re: "too clever" when creating SQL functions Stephan Szabo 14:53
Re: seeing type defination.. mallah 15:02
Calculating Percentages David Siegal 15:02
Re: seeing type defination.. Tom Lane 15:05
Re: seeing type defination.. mallah 15:17
Re: Array dimension as integer Achilleus Mantzios 15:44
Re: PROBLEM WITH UPDATE COMMAND mallah 15:45
Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance scott.marlowe 16:20
Re: insert rowtype Bryan Klimt 16:41
Re: "too clever" when creating SQL functions SZŰCS Gábor 16:41
Overwhelming DEBUG messages SZŰCS Gábor 16:51
Re: Overwhelming DEBUG messages Richard Huxton 18:06
Re: Overwhelming DEBUG messages Tom Lane 18:38
does this require a stored procedure? Alex Rice 18:50
Re: "too clever" when creating SQL functions Stephan Szabo 19:22
Re: does this require a stored procedure? chester c young 19:26
epoch to date? Alex Rice 19:44
Re: does this require a stored procedure? Alex Rice 19:44
Re: epoch to date? Bruno Wolff III 19:54

May 9, 2003

Thread Author Time
Anyone know of a text-interface postmaster load monitor? foo2 02:01
Re: An unresolved performance problem. Tom Lane 12:31
Re: An unresolved performance problem. Achilleus Mantzios 13:00
Re: An unresolved performance problem. Tom Lane 13:08
Re: An unresolved performance problem. Tom Lane 13:30
Re: Overwhelming DEBUG messages SZŰCS Gábor 15:30
Re: "too clever" when creating SQL functions SZŰCS Gábor 15:31
%ROWTYPE and insert Larry Rosenman 16:10
Re: does this require a stored procedure? Manfred Koizar 16:47
Re: index fragmentation Larry Rosenman 17:59
Re: An unresolved performance problem. Achilleus Mantzios 18:11
Re: An unresolved performance problem. Achilleus Mantzios 18:22
Re: An unresolved performance problem. Achilleus Mantzios 19:13
Re: An unresolved performance problem. Achilleus Mantzios 19:25
epoch to timestamp Lucas Lain 21:05
Can arrays reference primary keys in CREATE TABLE? Filipe Bonjour 21:21
Re: epoch to timestamp Bruno Wolff III 21:36

May 10, 2003

Thread Author Time
Using psql to insert character codes Ian Barwick 14:20
Re: Using psql to insert character codes Randall Lucas 16:15
Re: Using psql to insert character codes Ian Barwick 16:53
Re: Using psql to insert character codes Ian Barwick 17:35
Re: Using psql to insert character codes Randall Lucas 17:36
merge-join for domain with underlying type text Randall Lucas 21:04
Re: merge-join for domain with underlying type text Rod Taylor 22:13
Re: merge-join for domain with underlying type text Randall Lucas 23:40

May 11, 2003

Thread Author Time
Re: merge-join for domain with underlying type text Rod Taylor 00:48
Re: merge-join for domain with underlying type text Randall Lucas 00:53
Re: merge-join for domain with underlying type text Tom Lane 03:19
Knowing when it is safe to call currval() Matthew Horoschun 04:11
Re: Knowing when it is safe to call currval() Bruno Wolff III 04:41

Browse Archives

Prev | Next