pgsql-sql - November 1999

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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Nov. 1, 1999

Thread Author Time
Rule plan string too big is overcome, but... Baris Ulu 07:04
Re: [SQL] auto datetime update on UPDATE? Darrin Crook 14:46
query with subquery abnormally slow? Oskar Liljeblad 18:47
Re: [SQL] query with subquery abnormally slow? Oskar Liljeblad 19:05
Re: [SQL] query with subquery abnormally slow? Moray McConnachie 19:59
Re: [SQL] query with subquery abnormally slow? Oskar Liljeblad 20:10
Re: [SQL] query with subquery abnormally slow? Bill Brandt 20:35
Re: [SQL] query with subquery abnormally slow? Oskar Liljeblad 20:36
Re: [SQL] query with subquery abnormally slow? Tom Lane 22:10

Nov. 2, 1999

Thread Author Time
Re: Antw: [SQL] query with subquery abnormally slow? omid omoomi 00:42
SQL Info Chris Griffin 00:51
Antw: [SQL] query with subquery abnormally slow? Gerhard Dieringer 06:45
ERROR: btree: lost page Roomi 07:21
Re: [SQL] query with subquery abnormally slow? Zalman Stern 08:42
Redhat 6.0 Link Error: Undefined Reference to crypt Klein, Robert 15:34
Re: [SQL] Redhat 6.0 Link Error: Undefined Reference to crypt Tom Lane 19:09
why don't this create table work? User & 22:59

Nov. 3, 1999

Thread Author Time
timestamps David Rugge 02:51
Re: [SQL] why don't this create table work? Mathijs Brands 04:00
Re: [SQL] why don't this create table work? User & 05:04
Re: [SQL] why don't this create table work? Tom Lane 05:35
Re: [SQL] timestamps Tom Lane 05:48
Re: [SQL] why don't this create table work? User & 07:31
unsubscribe Joel Fischer 13:24
Optimizing a query through its syntax and indices Stoyan Genov 15:45
Re: [SQL] Optimizing a query through its syntax and indices Jan Wieck 17:16

Nov. 4, 1999

Thread Author Time
Re: [SQL] Copying databases omid omoomi 01:28
Copying databases Hamid Khoshnevis 05:54
Accessing other database... Frederic boucher 07:36
Re: [SQL] Optimizing a query through its syntax and indices Stoyan Genov 12:59
Tracking depth question Zot O'Connor 17:39
Remove Drinks, Ivan - ITD 22:19

Nov. 5, 1999

Thread Author Time
arrays of numeric? Vince Gonzalez 01:55
Re: [SQL] Redhat 6.0 Link Error: Undefined Reference to crypt De Moudt Walter 03:59
Re: [SQL] Accessing other database... Frederic boucher 05:16
Re: [SQL] Tracking depth question Zalman Stern 06:48
Re: [SQL] Accessing other database... Frederic boucher 07:09
create table with default value... Frederic boucher 08:38
Re: [SQL] Accessing other database... Stoyan Genov 08:46
type conversions Baris Ulu 10:10
Re: [SQL] create table with default value... Frederic boucher 10:25
Re: [SQL] create table with default value... Frederic boucher 10:33
insert with "Fred's car!" Frederic boucher 11:51
Oracle database import Miroslaw Budzanowski 13:52
Re: [SQL] Accessing other database... Jim Seach 14:13
Re: [SQL] create table with default value... Stuart Rison 18:07
Re: [SQL] insert with "Fred's car!" Bruce Momjian 20:41
calulating with money type impossible ? De Moudt Walter 21:58
showing the DEFAULT of a field Klaus Woelfel 22:15

Nov. 6, 1999

Thread Author Time
subscribe pgsql-sql José A. Navarro =?iso-8859-1?Q?Ram=F3n?= 02:03
Re: [SQL] Accessing other database... Frederic boucher 09:45
pg_dump and "archive = none" ?? Heiko Wilms 10:28
How to get last 10 rows in a table on a large database? Alex 10:37
Re: [SQL] How to get last 10 rows in a table on a large database? Stoyan Genov 11:36
Re: [SQL] pg_dump and "archive = none" ?? Stoyan Genov 11:44
Re: [SQL] showing the DEFAULT of a field Stoyan Genov 12:01
Re: [SQL] Accessing other database... Stoyan Genov 12:13
Re: [SQL] arrays of numeric? Peter Eisentraut 14:26
Re: [SQL] calulating with money type impossible ? Peter Eisentraut 14:48
Re: [SQL] pg_dump and "archive = none" ??8 Bruce Momjian 16:45
Re: [SQL] How to get last 10 rows in a table on a large database? Tom Lane 18:12
Re: [SQL] How to get last 10 rows in a table on a large database? Tom Lane 18:16
Re: [SQL] How to get last 10 rows in a table on a large database? 📎 Oleg Bartunov 19:09

Nov. 7, 1999

Thread Author Time
Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Stoyan Genov 10:25
Re: [SQL] Accessing other database... Stoyan Genov 10:50
unsubscribe Adrian Alb 12:23
Re: [SQL] arrays of numeric? Vince Gonzalez 19:59

Nov. 8, 1999

Thread Author Time
RE: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Hiroshi Inoue 00:32
Specifying currency using a numeric data type Rich Shepard 01:29
Re: [SQL] type conversions De Moudt Walter 04:16
Creating a index with a timestamp? Oliver Fischer 06:58
Re: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Stoyan Genov 09:27
parser :parse error Frederic boucher 11:37
Creating a index with a timestamp? Oliver Fischer 13:27
Declare Cursor... Baris Ulu 14:32
about the subselect query Oskar Liljeblad 17:19
Re: [SQL] Declare Cursor... Jan Wieck 17:57
newbie outer-join Matlack, Brad 20:06
Re: [SQL] parser :parse error Bruce Momjian 20:39
Re: [SQL] newbie outer-join Peter Eisentraut 21:26
Re: [SQL] parser :parse error Peter Eisentraut 21:32
Re: [SQL] parser :parse error Jacob Christen 21:37
DISTINCT raptor 21:52
Problem with a PL/pgSQL function Eric Prevost-Dansereau 22:38
Re: [SQL] parser :parse error Moray McConnachie 22:42

Nov. 9, 1999

Thread Author Time
Re: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) 📎 Hiroshi Inoue 00:26
RE: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Hiroshi Inoue 04:36
Re: [SQL] parser :parse error Frederic boucher 05:28
Is this a bug? Imtiaz. S. M 05:43
Re: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Stoyan Genov 11:15
HAVING in EXISTS-clause ... marten 11:26

Nov. 10, 1999

Thread Author Time
Re: [SQL] HAVING in EXISTS-clause ... Stuart Rison 11:03
PostgreSQL Compliance Sladewski, Joseph 16:17

Nov. 11, 1999

Thread Author Time
Re: [SQL] HAVING in EXISTS-clause ... Tom Lane 04:00
[No subject] Roomi 04:16
Does postgres have something like MySQL's DESCRIBE? Mark Stosberg 19:54
Nested Views take forever Zot O'Connor 23:10

Nov. 12, 1999

Thread Author Time
Re: [SQL] Nested Views take forever Tom Lane 00:34
Re: [SQL] Nested Views take forever marten 07:42
Re: [SQL] HAVING in EXISTS-clause ... marten 07:55
Rules and referential integrity <Miguel Sofer 15:13
Rules and referential integrity <Miguel Sofer 15:13
Re: [SQL] Rules and referential integrity Jan Wieck 16:13
Trying to move a 6.1 database to 6.5 Klein, Robert 16:37

Nov. 13, 1999

Thread Author Time
Re: [SQL] HAVING in EXISTS-clause ... Jan Wieck 03:17
Re: [SQL] parser :parse error Tom Lane 07:50
Porting MySQL's DESCRIBE and ENUM features Mark Stosberg 16:33
Re: [SQL] Porting MySQL's DESCRIBE and ENUM features Peter Eisentraut 17:04
Re: [SQL] Porting MySQL's DESCRIBE and ENUM features Tom Lane 19:41
national characters in plpgsql Artur Kokoszka 22:30

Nov. 14, 1999

Thread Author Time
Verificate values in other table? juman 10:25
Re: [SQL] Verificate values in other table? Peter Eisentraut 18:44
Arrays of composites, bug or usage? Chaotic Inceptions 21:03

Nov. 15, 1999

Thread Author Time
how can tell if a column is a primary key? Mark Stosberg 04:57
Re: [SQL] Verificate values in other table? Tom Lane 05:18
Re: [SQL] how can tell if a column is a primary key? Gary MacMinn 05:28
[SQL] Handling NULL Dates Gary MacMinn 05:43
Re: [SQL] nulls and datetime Tom Lane 06:10
Re: [SQL] Trying to move a 6.1 database to 6.5 Stoyan Genov 08:52
large objects over network connection oskar stuffer 11:49
Re: [SQL] how can tell if a column is a primary key? D'Arcy J.M. Cain 12:34
Re: [SQL] how can tell if a column is a primary key? Tom Lane 15:24
Re: [SQL] nulls and datetime Thomas Lockhart 15:29
Re: [SQL] nulls and datetime Tom Lane 15:41
Re: [SQL] nulls and datetime Thomas Lockhart 16:11
NULL Goran Thyni 19:07
Re: [SQL] NULL Bruce Momjian 19:23
Re: [SQL] NULL Bruce Stephens 19:57
Re: [SQL] how can tell if a column is a primary key? Howie 22:37
Re: [SQL] Verificate values in other table? Jan Wieck 23:36
Re: [SQL] NULL Jan Wieck 23:48

Nov. 16, 1999

Thread Author Time
Re: [SQL] NULL Tom Lane 00:50
Re: [SQL] how can tell if a column is a primary key? D'Arcy J.M. Cain 03:19
permanent deleting Roomi 07:26
Re: [SQL] NULL jose soares 13:37
Re: [SQL] NULL Jan Wieck 14:16
ODBC/Openlink/Delphi maxsbox 18:17
Updating datetime fields with NULL values Gary MacMinn 22:28
Re: [SQL] Updating datetime fields with NULL values John Ziniti 22:58
Re: [SQL] zombie postmasters tjk@tksoft.com 23:00
zombie postmasters Hamid Khoshnevis 23:06
Re: [SQL] zombie postmasters Chad Miller 23:21
Re: [SQL] zombie postmasters Stephen J Lombardo 23:39

Nov. 17, 1999

Thread Author Time
Threaded PGSQL access (was Re: [SQL] zombie postmasters) Mathijs Brands 00:10
Re: [SQL] zombie postmasters Tom Lane 05:05
Re: [SQL] nulls and datetime Gary MacMinn 05:16
Re: [SQL] zombie postmasters Jan Wieck 08:26
Re: [SQL] zombie postmasters Zalman Stern 08:44
Re: [SQL] ODBC/Openlink/Delphi jose soares 13:34
Building "ON DELETE" rules to keep the referential integrity of a database Stoyan Genov 13:42
Re: [SQL] NULL jose soares 13:56
Re: [SQL] NULL Jan Wieck 18:31

Nov. 18, 1999

Thread Author Time
Antw: [SQL] Building "ON DELETE" rules to keep the referential integrity of a database Gerhard Dieringer 08:01
please help me on pl/pgsql triggers (fwd) Mario Olimpio de Menezes 09:49
Can't create an index on NUMERIC(x,y) secret 16:08
Re: [SQL] Can't create an index on NUMERIC(x,y) Jan Wieck 22:18
sql question: min remapped value Douglas Nichols 23:26

Nov. 19, 1999

Thread Author Time
Re: [SQL] sql question: min remapped value Tom Lane 00:43
Backend message type 0x45 arrived while idle Haris Susanto 07:24
Deleting rows with time 55 minutes less than max time Imtiaz. S. M 11:07
selecting from indexes Tim Joyce 14:22
Re: [SQL] selecting from indexes Tom Lane 15:21
Re: [SQL] selecting from indexes Tim Joyce 16:25
Re: [SQL] selecting from indexes Tom Lane 17:23
Re: [SQL] selecting from indexes Tim Joyce 20:06
Re: [SQL] selecting from indexes Tom Lane 22:18
Re: [SQL] selecting from indexes Tim Joyce 22:55

Nov. 20, 1999

Thread Author Time
Deleting indexes before vacuum? Matthew Hagerty 01:03
Re: [SQL] Deleting indexes before vacuum? Tom Lane 06:14
Re: [SQL] Deleting indexes before vacuum? Oleg Bartunov 07:57
RE: [SQL] Deleting indexes before vacuum? Pham, Thinh 15:29
Re: [SQL] Deleting indexes before vacuum? Tom Lane 17:01
Re: [SQL] Deleting indexes before vacuum? Oleg Bartunov 18:57
Re: [SQL] Deleting indexes before vacuum? Oleg Bartunov 19:44

Nov. 21, 1999

Thread Author Time
How to optimize this simple query :-( marten 11:12

Nov. 22, 1999

Thread Author Time
RE: [SQL] Deleting indexes before vacuum? Hiroshi Inoue 01:53
Re: [SQL] Deleting indexes before vacuum? Tom Lane 03:18
Parameterised ADOCommand object Vs Exec SQL CHAITANYANC 04:24
RE: [SQL] Deleting indexes before vacuum? Hiroshi Inoue 05:52
unsubscribe Drinks, Ivan - ITD 17:07

Nov. 23, 1999

Thread Author Time
soporte Liliana Pineda 11:06
[No subject] Stefano Lixi 18:49
Re: [SQL] Store multi-media with Postgres? Mathijs Brands 21:05
Store multi-media with Postgres? Duncan Kinder 21:43
[No subject] Christopher Sawtell 21:56

Nov. 24, 1999

Thread Author Time
Info on SQL Parsing required CHAITANYANC 03:39
Re: [SQL] Info on SQL Parsing required neko 10:22
Re: [SQL] NULL Bruce Stephens 15:08
Re: pgsql-sql-digest V1 #422 maxsbox 18:14

Nov. 25, 1999

Thread Author Time
recursive 📎 Julien Cadiou 01:09
recursion 📎 Julien Cadiou 01:15
very slow connection Szucs Laszlo 12:21
pqReadData() error Dipankar Chakrabarti 12:23
Re: [SQL] pqReadData() error Jan Wieck 12:37
Re: [SQL] Re: pgsql-sql-digest V1 #422 Fabrice Scemama 22:03
Re: [SQL] Info on SQL Parsing required Peter Eisentraut 23:43

Nov. 26, 1999

Thread Author Time
Re: pgsql-sql-digest V1 #424 Dipankar Chakrabarti 05:42
Backend dies (6.5.3-1) on SELECT from 6 row table Emils Klotins 14:35
national character once again Artur Kokoszka 15:52
Re: [SQL] Backend dies (6.5.3-1) on SELECT from 6 row table Tom Lane 16:20

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30