Home > mailing lists

Mailing lists [pgsql-sql]

1 November 1999

06:07 Rule plan string too big is overcome, but... Baris Ulu
12:50 Re: [SQL] auto datetime update on UPDATE? Darrin Crook
16:46 query with subquery abnormally slow? Oskar Liljeblad
17:04 Re: [SQL] query with subquery abnormally slow? Oskar Liljeblad
18:01 Re: [SQL] query with subquery abnormally slow? Moray McConnachie
18:09 Re: [SQL] query with subquery abnormally slow? Oskar Liljeblad
18:35 Re: [SQL] query with subquery abnormally slow? Bill Brandt
18:36 Re: [SQL] query with subquery abnormally slow? Oskar Liljeblad
20:11 Re: [SQL] query with subquery abnormally slow? Tom Lane
22:51 SQL Info Chris Griffin

2 November 1999

04:51 Antw: [SQL] query with subquery abnormally slow? Gerhard Dieringer
05:23 ERROR: btree: lost page Roomi
06:43 Re: Antw: [SQL] query with subquery abnormally slow? omid omoomi
06:43 Re: [SQL] query with subquery abnormally slow? Zalman Stern
13:35 Redhat 6.0 Link Error: Undefined Reference to crypt Klein, Robert
17:11 Re: [SQL] Redhat 6.0 Link Error: Undefined Reference to crypt Tom Lane
21:04 why don't this create table work? User &

3 November 1999

01:12 timestamps David Rugge
02:02 Re: [SQL] why don't this create table work? Mathijs Brands
03:09 Re: [SQL] why don't this create table work? User &
03:37 Re: [SQL] why don't this create table work? Tom Lane
03:49 Re: [SQL] timestamps Tom Lane
05:38 Re: [SQL] why don't this create table work? User &
11:30 unsubscribe Joel Fischer
13:46 Optimizing a query through its syntax and indices Stoyan Genov
15:25 Re: [SQL] Optimizing a query through its syntax and indices wieck@debis.com (Jan Wieck)

4 November 1999

03:49 Copying databases Hamid Khoshnevis
07:29 Re: [SQL] Copying databases omid omoomi
10:59 Re: [SQL] Optimizing a query through its syntax and indices Stoyan Genov
13:37 Accessing other database... Frederic boucher
15:40 Tracking depth question Zot O'Connor
20:18 Remove Drinks, Ivan - ITD
23:55 arrays of numeric? Vince Gonzalez

5 November 1999

01:56 Re: [SQL] Redhat 6.0 Link Error: Undefined Reference to crypt De Moudt Walter
04:48 Re: [SQL] Tracking depth question Zalman Stern
06:46 Re: [SQL] Accessing other database... Stoyan Genov
09:13 type conversions Baris Ulu
11:17 Re: [SQL] Accessing other database... Frederic boucher
11:52 Oracle database import Miroslaw Budzanowski
12:13 Re: [SQL] Accessing other database... Jim Seach
13:11 Re: [SQL] Accessing other database... Frederic boucher
14:40 create table with default value... Frederic boucher
16:02 Re: [SQL] create table with default value... Stuart Rison
16:26 Re: [SQL] create table with default value... Frederic boucher
16:34 Re: [SQL] create table with default value... Frederic boucher
17:53 insert with "Fred's car!" Frederic boucher
18:57 Re: [SQL] insert with "Fred's car!" Bruce Momjian
19:55 calulating with money type impossible ? De Moudt Walter
20:15 showing the DEFAULT of a field Klaus Woelfel

6 November 1999

08:38 pg_dump and "archive = none" ?? Heiko Wilms
08:41 How to get last 10 rows in a table on a large database? Alex@Icepick.com (Alex)
09:37 Re: [SQL] How to get last 10 rows in a table on a large database? Stoyan Genov
09:45 Re: [SQL] pg_dump and "archive = none" ?? Stoyan Genov
10:02 Re: [SQL] showing the DEFAULT of a field Stoyan Genov
10:14 Re: [SQL] Accessing other database... Stoyan Genov
13:35 Re: [SQL] calulating with money type impossible ? Peter Eisentraut
13:42 Re: [SQL] arrays of numeric? Peter Eisentraut
14:46 Re: [SQL] pg_dump and "archive = none" ??8 Bruce Momjian
15:46 Re: [SQL] Accessing other database... Frederic boucher
16:14 Re: [SQL] How to get last 10 rows in a table on a large database? Tom Lane
16:19 Re: [SQL] How to get last 10 rows in a table on a large database? Tom Lane
17:18 Re: [SQL] How to get last 10 rows in a table on a large database? Oleg Bartunov

7 November 1999

08:25 Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Stoyan Genov
08:45 subscribe pgsql-sql José A. Navarro Ramón
08:51 Re: [SQL] Accessing other database... Stoyan Genov
10:25 unsubscribe Adrian Alb
18:00 Re: [SQL] arrays of numeric? Vince Gonzalez
22:28 RE: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Hiroshi Inoue
23:30 Specifying currency using a numeric data type Rich Shepard

8 November 1999

02:12 Re: [SQL] type conversions De Moudt Walter
05:02 Creating a index with a timestamp? Oliver Fischer
07:27 Re: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Stoyan Genov
11:32 Creating a index with a timestamp? Oliver Fischer
12:49 DISTINCT raptor
13:35 Declare Cursor... Baris Ulu
15:17 about the subselect query Oskar Liljeblad
16:04 Re: [SQL] Declare Cursor... wieck@debis.com (Jan Wieck)
17:38 parser :parse error Frederic boucher
18:06 newbie outer-join Matlack, Brad
19:02 Re: [SQL] parser :parse error Bruce Momjian
19:23 Re: [SQL] newbie outer-join Peter Eisentraut
19:28 Re: [SQL] parser :parse error Peter Eisentraut
19:48 Re: [SQL] parser :parse error Jacob Christen
20:43 Re: [SQL] parser :parse error Moray McConnachie
20:45 Problem with a PL/pgSQL function Eric Prevost-Dansereau
22:27 Re: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Hiroshi Inoue

9 November 1999

02:33 RE: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Hiroshi Inoue
03:41 Is this a bug? Imtiaz. S. M
09:16 Re: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Stoyan Genov
11:29 Re: [SQL] parser :parse error Frederic boucher

10 November 1999

00:33 HAVING in EXISTS-clause ... marten@feki.toppoint.de
09:00 Re: [SQL] HAVING in EXISTS-clause ... Stuart Rison
14:21 PostgreSQL Compliance Sladewski, Joseph

11 November 1999

02:02 Re: [SQL] HAVING in EXISTS-clause ... Tom Lane
02:20 ... Roomi
17:53 Does postgres have something like MySQL's DESCRIBE? Mark Stosberg
21:11 Nested Views take forever Zot O'Connor
22:34 Re: [SQL] Nested Views take forever Tom Lane

12 November 1999

13:17 Rules and referential integrity
13:32 Rules and referential integrity
14:23 Re: [SQL] Rules and referential integrity wieck@debis.com (Jan Wieck)
14:38 Trying to move a 6.1 database to 6.5 Klein, Robert

13 November 1999

00:33 Re: [SQL] Nested Views take forever marten@feki.toppoint.de
00:34 Re: [SQL] HAVING in EXISTS-clause ... marten@feki.toppoint.de
01:27 Re: [SQL] HAVING in EXISTS-clause ... wieck@debis.com (Jan Wieck)
05:52 Re: [SQL] parser :parse error Tom Lane
14:33 Porting MySQL's DESCRIBE and ENUM features Mark Stosberg
15:05 Re: [SQL] Porting MySQL's DESCRIBE and ENUM features Peter Eisentraut
17:43 Re: [SQL] Porting MySQL's DESCRIBE and ENUM features Tom Lane
20:31 national characters in plpgsql Artur Kokoszka

14 November 1999

08:30 Verificate values in other table? juman
19:03 Arrays of composites, bug or usage? Chaotic Inceptions

15 November 1999

02:56 how can tell if a column is a primary key? Mark Stosberg
03:19 Re: [SQL] Verificate values in other table? Tom Lane
03:30 Re: [SQL] how can tell if a column is a primary key? Gary MacMinn
03:45 [SQL] Handling NULL Dates Gary MacMinn
04:12 Re: [SQL] nulls and datetime Tom Lane
06:53 Re: [SQL] Trying to move a 6.1 database to 6.5 Stoyan Genov
09:50 large objects over network connection oskar stuffer
10:34 Re: [SQL] how can tell if a column is a primary key? D'Arcy" "J.M." Cain
13:22 Re: [SQL] nulls and datetime Thomas Lockhart
13:24 Re: [SQL] how can tell if a column is a primary key? Tom Lane
13:43 Re: [SQL] nulls and datetime Tom Lane
14:04 Re: [SQL] nulls and datetime Thomas Lockhart
17:07 NULL Goran Thyni
17:25 Re: [SQL] NULL Bruce Momjian
17:57 Re: [SQL] NULL Bruce Stephens
20:36 Re: [SQL] how can tell if a column is a primary key? Howie
20:56 Re: [SQL] Verificate values in other table? Peter Eisentraut
21:45 Re: [SQL] Verificate values in other table? wieck@debis.com (Jan Wieck)
21:57 Re: [SQL] NULL wieck@debis.com (Jan Wieck)
22:51 Re: [SQL] NULL Tom Lane

16 November 1999

01:19 Re: [SQL] how can tell if a column is a primary key? D'Arcy" "J.M." Cain
05:31 permanent deleting Roomi
11:42 Re: [SQL] NULL jose soares
12:25 Re: [SQL] NULL wieck@debis.com (Jan Wieck)
20:32 Updating datetime fields with NULL values Gary MacMinn
20:58 Re: [SQL] Updating datetime fields with NULL values John Ziniti
21:01 zombie postmasters Hamid Khoshnevis
21:22 Re: [SQL] zombie postmasters Chad Miller
21:24 Re: [SQL] zombie postmasters tjk@tksoft.com
21:42 Re: [SQL] zombie postmasters Stephen J Lombardo
22:11 Threaded PGSQL access (was Re: [SQL] zombie postmasters) Mathijs Brands

17 November 1999

01:29 ODBC/Openlink/Delphi maxsbox
03:07 Re: [SQL] zombie postmasters Tom Lane
03:20 Re: [SQL] nulls and datetime Gary MacMinn
06:35 Re: [SQL] zombie postmasters wieck@debis.com (Jan Wieck)
06:47 Re: [SQL] zombie postmasters Zalman Stern
11:33 Re: [SQL] ODBC/Openlink/Delphi jose soares
11:43 Building "ON DELETE" rules to keep the referential integrity of a database Stoyan Genov
11:57 Re: [SQL] NULL jose soares
17:08 Re: [SQL] NULL wieck@debis.com (Jan Wieck)

18 November 1999

06:07 Antw: [SQL] Building "ON DELETE" rules to keep the referential integrity of a database Gerhard Dieringer
07:58 please help me on pl/pgsql triggers (fwd) Mario Olimpio de Menezes
14:10 Can't create an index on NUMERIC(x,y) secret
20:26 Re: [SQL] Can't create an index on NUMERIC(x,y) wieck@debis.com (Jan Wieck)
21:35 sql question: min remapped value Douglas Nichols
22:45 Re: [SQL] sql question: min remapped value Tom Lane

19 November 1999

05:31 Backend message type 0x45 arrived while idle Haris Susanto
09:05 Deleting rows with time 55 minutes less than max time Imtiaz. S. M
12:44 selecting from indexes Tim Joyce
13:23 Re: [SQL] selecting from indexes Tom Lane
14:29 Re: [SQL] selecting from indexes Tim Joyce
15:26 Re: [SQL] selecting from indexes Tom Lane
19:17 Re: [SQL] selecting from indexes Tim Joyce
20:20 Re: [SQL] selecting from indexes Tom Lane
20:52 Re: [SQL] selecting from indexes Tim Joyce
23:04 Deleting indexes before vacuum? Matthew Hagerty

20 November 1999

04:16 Re: [SQL] Deleting indexes before vacuum? Tom Lane
06:05 Re: [SQL] Deleting indexes before vacuum? Oleg Bartunov
13:13 RE: [SQL] Deleting indexes before vacuum? Pham, Thinh
15:03 Re: [SQL] Deleting indexes before vacuum? Tom Lane
17:05 Re: [SQL] Deleting indexes before vacuum? Oleg Bartunov
17:45 Re: [SQL] Deleting indexes before vacuum? Oleg Bartunov

21 November 1999

23:49 RE: [SQL] Deleting indexes before vacuum? Hiroshi Inoue

22 November 1999

00:33 How to optimize this simple query :-( marten@feki.toppoint.de
01:19 Re: [SQL] Deleting indexes before vacuum? Tom Lane
02:27 Parameterised ADOCommand object Vs Exec SQL CHAITANYANC
03:48 RE: [SQL] Deleting indexes before vacuum? Hiroshi Inoue
15:05 unsubscribe Drinks, Ivan - ITD

23 November 1999

16:21 Store multi-media with Postgres? Duncan Kinder
16:54 Stefano Lixi
19:08 Re: [SQL] Store multi-media with Postgres? Mathijs Brands
19:54 Christopher Sawtell

24 November 1999

01:43 Info on SQL Parsing required CHAITANYANC
08:24 Re: [SQL] Info on SQL Parsing required neko@kredit.sth.szif.hu
13:08 Re: [SQL] NULL Bruce Stephens
23:10 recursive Julien Cadiou
23:16 recursion Julien Cadiou

25 November 1999

09:22 very slow connection Szucs Laszlo
10:24 pqReadData() error Dipankar Chakrabarti
10:46 Re: [SQL] pqReadData() error wieck@debis.com (Jan Wieck)
17:39 Re: pgsql-sql-digest V1 #422 maxsbox
18:59 Re: [SQL] Re: pgsql-sql-digest V1 #422 Fabrice Scemama
21:39 Re: [SQL] Info on SQL Parsing required Peter Eisentraut

26 November 1999

00:40 subscribe wolfy@gcq.com.tw WolfySu
03:43 Re: pgsql-sql-digest V1 #424 Dipankar Chakrabarti
10:28 Backend dies (6.5.3-1) on SELECT from 6 row table Emils Klotins
13:40 6.5.3 - backend closes if wrong parameters to NULLIF, CASE Emils Klotins
13:52 national character once again Artur Kokoszka
14:21 Re: [SQL] Backend dies (6.5.3-1) on SELECT from 6 row table Tom Lane
14:35 DISTINCT & COUNT Moray McConnachie
15:54 Re: [SQL] DISTINCT & COUNT Stuart Rison
16:07 Re: [SQL] 6.5.3 - backend closes if wrong parameters to NULLIF, CASE Tom Lane
16:21 Re: [SQL] DISTINCT & COUNT Tom Lane
17:59 TEST MESSAGE - PLEASE IGNORE Zodiac Speaker
21:35 Re: [SQL] national character once again wieck@debis.com (Jan Wieck)
23:24 Numeric format for currency Rich Shepard

27 November 1999

13:33 Usage of index in "ORDER BY" operations Matthias Ackermann
15:19 Re: [SQL] Usage of index in "ORDER BY" operations Tom Lane
16:26 Design Question Andy Lewis
16:42 Re: [SQL] Design Question Rich Shepard
16:51 Re: [SQL] Design Question Andy Lewis
20:51 Re: [SQL] Design Question Julien Cadiou
21:01 recusrion Julien Cadiou

28 November 1999

17:19 Re: [SQL] Design Question De Moudt Walter
18:57 Re: [SQL] Design Question Andy Lewis

29 November 1999

06:14 create view on union -- workaround? Brian Haney
07:13 Your query ... S S Mani
07:30 Your Query... S S Mani
07:38 Re: [SQL] recusrion Stoyan Genov
15:01 ... Alexey V. Meledin

30 November 1999

01:15 Re: [SQL] NULL Bruce Momjian
06:08 unixtime -> datetime Thilo Mezger
09:24 found a way to update a table with data from another one Patrick JACQUOT
12:35 Addendum: PG6.5.3: CASE w. diff THEN types -- prob with Linux(?) Emils Klotins
13:23 Re: [SQL] found a way to update a table with data from another one Tom Lane
14:13 Re: [SQL] NULL Ross J. Reedstrom
14:28 Re: [SQL] NULL Peter Eisentraut
15:48 Re: [SQL] NULL Ross J. Reedstrom
16:08 Re: [SQL] NULL Tom Lane
17:09 Re: [SQL] NULL Ross J. Reedstrom
17:24 date function questions... Zsolt Varga
20:05 Re: [SQL] Addendum: PG6.5.3: CASE w. diff THEN types -- prob with Linux(?) Oliver Elphick
20:57 Re: [SQL] Addendum: PG6.5.3: CASE w. diff THEN types -- prob with Linux(?) Tom Lane
21:16 slow sort for simple join Mark Kirkwood
23:31 RestrictionClauseSelectivity Frank Bax