pgsql-sql since 2001-01-20 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

Jan. 20, 2001

Thread Author Time
Re: Trouble with subqueries Robert B. Easter 03:14
Re: pl/pgsql Limits Ian Harding 04:31
unreferenced primary keys: garbage collection Forest Wilkinson 04:54
Re: pl/pgsql Limits Ian Harding 05:04
Re: pl/pgSQL & transaction Kovacs Zoltan Sandor 12:19
Correct Syntax for alter table ..add constraint Najm Hashmi 18:49
Re: Correct Syntax for alter table ..add constraint Najm Hashmi 19:50
Re: unreferenced primary keys: garbage collection Jan Wieck 22:13

Jan. 21, 2001

Thread Author Time
Re: abstract data types? Tom Lane 04:52
abstract data types? John Reid 05:00
Re: abstract data types? Brett W. McCoy 05:13
#DELETED error when using Access 2000 as frontend Markus Wagner 11:03
Re: abstract data types? Josh Berkus 17:13

Jan. 22, 2001

Thread Author Time
Question about 'copy' and datetime Carolyn Lu Wong 04:08
Re: Question about 'copy' and datetime Tom Lane 05:34
Joining several tables Stephan Richter 06:20
select returns no line kisix 16:47
DATE john whale 17:29
RE: Joining several tables Michael Davis 18:00
Re: unreferenced primary keys: garbage collection Jan Wieck 22:19

Jan. 23, 2001

Thread Author Time
Order By Question Tristan Colson 00:25
Order By Question Tristan Colson 01:01
Re: Order By Question Ian Harding 01:20
Re: Re: is there a mysql to postgresql sql converter? Bruce Momjian 02:28
Re: MySQL -> Postgres dump converter Bruce Momjian 02:29
Re: Joining several tables PM 03:35
Image in database Ramesh H R 06:00
postgresql.largeobject package Ramesh H R 11:36
grouping by date increments 📎 Graham Vickrage 11:41
select returns no line Attila Kevei 11:42
select returns no line Attila Kevei 12:32
Re: select returns no line Attila Kevei 13:41
Re: select returns no line Volker Paul 14:24
monster query, how to make it smaller 📎 juerg.rietmann 14:42
Re: select returns no line patrick.jacquot 15:21
[notion]: a possible language addition: XQL clayton cottingham 15:50
Re: select returns no line Richard Huxton 16:01
Re: monster query, how to make it smaller Richard Huxton 16:05
Re: grouping by date increments Tom Lane 16:19
Re: select returns no line Peter Eisentraut 16:27
Re: monster query, how to make it smaller Tom Lane 16:31
Re: select returns no line Tom Lane 16:54
help with query Oleg Bartunov 18:11
blobs and small binary objects David Wall 18:58
Inserting and incrementing with MAX aggregate Keith Perry 20:01
finding foreign keys Ron Peterson 21:50
Re: blobs and small binary objects David Wall 22:16
Rules and transactions Brett Schwarz 22:43

Jan. 24, 2001

Thread Author Time
retrieving user's groups chard 02:38
RE: retrieving user's groups Michael Davis 02:55
Re: Inserting and incrementing with MAX aggregate Ian Harding 04:00
Re: unreferenced primary keys: garbage collection Forest Wilkinson 04:35
SQL Query Results <No Name> 05:02
RE: DATE Michael Davis 05:22
Re: unreferenced primary keys: garbage collection Michael Fork 05:26
plpgsql language chard 05:39
RE: plpgsql language Michael Davis 05:56
Re: Order By Question Prasanth Kumar 07:51
Re: [SQL] postgresql.largeobject package Peter T Mount 09:08
Re: select returns no line Attila Kevei 09:10
How to change the ownership of the table? Ramesh H R 09:12
Use of INNER JOIN and others ??!? Luis Sousa 10:31
Re: DATE Oliver Elphick 10:54
i have a big trouble 📎 Sandis Jerics 11:50
Some queries 📎 Som 11:53
Re: Use of INNER JOIN and others ??!? Bruce Momjian 12:19
Convert an interval in seconds Blaise Carrupt 13:38
Re: How to change the ownership of the table? Tom Lane 15:34
Re: i have a big trouble Tom Lane 15:45
RE: SQL Query Results Michael Davis 15:49
Re: Inserting and incrementing with MAX aggregate Keith Perry 16:11
Re: pl/pgsql Limits Josh Berkus 16:25
Re: plpgsql language Albert REINER 17:23
Making a foreign key chain - good idea or bad idea? Frank Joerdens 17:30
Re: How to change the ownership of the table? Jie Liang 18:12
Is there anything like DESCRIBE? Mike D'Agosta 19:00
Please don't kill me! David Olbersen 19:31
Re: unreferenced primary keys: garbage collection Albert REINER 19:36
Problem with Dates Glen and Rosanne Eustace 19:49
Re: Making a foreign key chain - good idea or bad idea? Stephan Szabo 20:30
Re: Problem with Dates Mike Castle 20:55
Re: unreferenced primary keys: garbage collection Forest Wilkinson 21:09
Cannot CREATE INDEX that contains a function Roberto Bertolusso 21:29
Veering OT opinions please XQL versus XML-QL clayton cottingham 22:01
Rule not invoked in 7.1 📎 Kyle 22:14
Re: Rules and transactions Jan Wieck 23:00

Jan. 25, 2001

Thread Author Time
Re: Problem with Dates Glen and Rosanne Eustace 02:06
Re: Problem with Dates Mike Castle 02:17
Re: Re: Problem with Dates Brett W. McCoy 02:59
Re: #DELETED error when using Access 2000 as frontend Ian Harding 03:55
Insertion and Retrieval of BLOB 📎 Som 04:50
Re: Rule not invoked in 7.1 Tom Lane 04:53
Re: SQL Query Results Christopher Sawtell 05:37
"'" in SQL INSERT statement Markus Wagner 10:12
Re: "'" in SQL INSERT statement Oliver Elphick 10:19
Re: "'" in SQL INSERT statement Alessio Bragadini 10:30
Re: "'" in SQL INSERT statement Brett W. McCoy 10:49
Re: Re: Problem with Dates Brett W. McCoy 12:11
Re: Re: Problem with Dates Brett W. McCoy 12:28
Re: Rule not invoked in 7.1 Jan Wieck 13:21
Wild Cards <No Name> 13:39
how to query this ?? 📎 juerg.rietmann 15:08
Re: Rule not invoked in 7.1 📎 Kyle 17:27
Re: "'" in SQL INSERT statement Albert REINER 17:42
crypt and decrypt Marcos Aurélio S. da Silva 17:54
Re: "'" in SQL INSERT statement Dan Lyke 18:03
Re: "'" in SQL INSERT statement Jie Liang 18:31
Change or get currentdb Sergiy Ovcharuk 18:37
Don't want blank data David Olbersen 19:05
Re: Wild Cards Brett W. McCoy 19:29
Re: Change or get currentdb David Olbersen 20:13
Re: Don't want blank data Stephan Szabo 20:43
Re: Is there anything like DESCRIBE? Mike D'Agosta 20:56
RE: Is there anything like DESCRIBE? Michael Davis 20:57
Re: How to change the ownership of the table? Najm Hashmi 20:59
Re: Is there anything like DESCRIBE? clayton cottingham 21:02
Re: Is there anything like DESCRIBE? Oliver Elphick 22:51
Re: Don't want blank data Oliver Elphick 22:54
Re: Problem with Dates Glen and Rosanne Eustace 23:46
SQL function and composite types Ron Sofrin 23:47

Jan. 26, 2001

Thread Author Time
Re: Is there anything like DESCRIBE? Ron Peterson 02:34
Re: Rule not invoked in 7.1 Tom Lane 03:35
Re: Cannot CREATE INDEX that contains a function Tom Lane 03:47
Invoking sql functions through jdbc Ron Sofrin 03:57
Re: abstract data types? John Reid 06:32
Re: Re: Problem with Dates Christopher Sawtell 08:22
Re: abstract data types? John Reid 08:31
Re: Re: Problem with Dates Tom Lane 15:05
Re: Rule not invoked in 7.1 Jan Wieck 16:52
Re: abstract data types? Josh Berkus 17:02
Re: Rule not invoked in 7.1 📎 Kyle 17:05
Re: Rule not invoked in 7.1 📎 Kyle 17:13
Re: Rule not invoked in 7.1 📎 Kyle 17:20
Request for change in PL/PGSQL function handler Josh Berkus 17:27
Re: Re: Problem with Dates Glen and Rosanne Eustace 17:44
Re: Re: Problem with Dates Tom Lane 18:00
Re: Re: Problem with Dates Glen and Rosanne Eustace 18:18
Re: #DELETED error when using Access 2000 as frontend Emils Klotins 18:42
Re: DATE Emils Klotins 18:45
Re: Request for change in PL/PGSQL function handler Tom Lane 19:04
[No subject] Jan Wieck 19:05
Re: Request for change in PL/PGSQL function handler Josh Berkus 19:06
SQL Help Mark A. Summers 19:11
Re: Rule not invoked in 7.1 Jan Wieck 19:15
Re: Re: Problem with Dates Glen and Rosanne Eustace 19:31
Re: Re: Problem with Dates Christopher Sawtell 22:56
Re: Re: Problem with Dates Tom Lane 23:49

Jan. 27, 2001

Thread Author Time
[No subject] David J. R. Brook 00:03
Re: #DELETED error when using Access 2000 as frontend Colin Faber 01:24
Re: SQL Help Stephan Szabo 01:48
Architectural question Kovacs Baldvin 02:07
Re: Wild Cards Rodger Donaldson 05:39
Re: Tom Lane 07:14
wrong query plan in 7.1beta3 Kovacs Zoltan 14:05
Re: wrong query plan in 7.1beta3 Peter Eisentraut 14:45
Re: abstract data types? John Reid 15:13
Re: wrong query plan in 7.1beta3 Kovacs Zoltan 15:44
Re: wrong query plan in 7.1beta3 Tom Lane 16:20
looping through results of a SELECT Nagy Tamas 19:15
RE: looping through results of a SELECT Michael Davis 21:04
Queries against multi-million record tables. Michael Miyabara-McCaskey 21:45
BTP_CHAIN errors fixed? Mark Volpe 22:42
Re: BTP_CHAIN errors fixed? Tom Lane 23:00
Re: BTP_CHAIN errors fixed? Mark Volpe 23:11

Jan. 28, 2001

Thread Author Time
Re: Re: abstract data types? Josh Berkus 01:56
Re: abstract data types? John Reid 03:58
current host and dbname info Joe Conway 05:40
Multicolumn primary keys and multicolumn foreign keys Ferruccio Zamuner 10:34
Re: Re: Problem with Dates Christopher Sawtell 10:47
BLOB HOWTO?? Olivier PRENANT 19:59

Jan. 29, 2001

Thread Author Time
Re: Multicolumn primary keys and multicolumn foreign keys chard 03:18
FastPath Protocol Error Som 07:48
Re: BLOB HOWTO?? Olivier PRENANT 11:17
Emergency case: Postgres problems Jaruwan Laongmal 11:49
Re: BLOB HOWTO?? Martin A. Marques 12:49
Re: FastPath Protocol Error Tom Lane 14:56
Re: BLOB HOWTO?? robert gravsjo 16:19
Re: SQL Help Mark A. Summers 16:29
Re: BLOB HOWTO?? Bruce Momjian 16:36
Re: BLOB HOWTO?? Bruce Momjian 16:37
Upgrade to 7.0.3 Mark A. Summers 17:00
Re: BLOB HOWTO?? Olivier PRENANT 17:32
Re: Upgrade to 7.0.3 Bruce Momjian 17:40
Re: BLOB HOWTO?? Bruce Momjian 17:42
Problem with Day of Week Keith Perry 17:55
Re: BLOB HOWTO?? Jan Wieck 18:10
Re: [SQL] Re: BLOB HOWTO?? Jan Wieck 18:12
[No subject] Olivier PRENANT 18:18
Re: Jan Wieck 19:08
Re: BLOB HOWTO?? Jan Wieck 19:14
Re: Emergency case: Postgres problems Jan Wieck 19:33
Archival of Live database to Historical database Stef Telford 20:00
7.1beta4 bug creating a certain table Kovacs Zoltan 21:07
Re: 7.1beta4 bug creating a certain table Tom Lane 22:32

Jan. 30, 2001

Thread Author Time
Re: PostgreSQL HOWTO Joseph Shraibman 01:14
How to modify type in table? Jaruwan Laongmal 03:22
Re: How to modify type in table? Manuel Cabido 03:49
script for unidirectional database update Markus Wagner 06:38
Re: Archival of Live database to Historical database Richard Huxton 09:09
Re: script for unidirectional database update Richard Huxton 09:09

Browse Archives

Prev | Next