pgsql-sql - April 2001

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

April 1, 2001

Thread	Author	Time
Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP	Tom Lane	00:14
Re: Vacuum Error	Tom Lane	00:18
Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP	Tom Lane	00:53
Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP	Bruce Momjian	00:58
Trigger Function and Html Output	Stef Telford	07:50
ON DELETE rule	J.Fernando Moyano	08:09
Re: Trigger Function and Html Output	Richard Huxton	16:35
Re: Trigger Function and Html Output	Stef Telford	17:21
Re: ON DELETE rule	Tom Lane	19:34

April 2, 2001

Thread	Author	Time
RE: [HACKERS] Error in the date field (with NULL value...).Thanks!	Christopher Kings-Lynne	01:31
very very slow .....	J.Fernando Moyano	02:44
Re: Trigger Function and Html Output	Christopher Masto	03:17
passing parameters between forms	Sharmad Naik	07:22
Re: Trigger Function and Html Output	Richard Huxton	08:43
Calling functions inside a function: behavior	Edipo Elder Fernandes de Melo	11:50
Re: passing parameters between forms	Richard Huxton	12:14
Re: Calling Java from psql (was Re: requesting help)	Peter T Mount	13:17
Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP	Bruce Momjian	15:07
Re: Calling functions inside a function: behavior	Roberto Mello	15:07
Sql error	comp	15:09
Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP	Peter Eisentraut	15:15
Re: Error:TypeCreate: type links already defined	Richard Huxton	16:38
Re: Indexes vs indices	Tom Lane	16:47
Re: Indexes vs indices	Bruce Momjian	16:58
Fwd: Calling functions inside a function: behavior	Josh Berkus	17:20
Re: Re: Indexes vs indices	Lamar Owen	17:20
Can anyone explain how this works?	RbrtBrn3	18:01
Re: Fwd: Calling functions inside a function: behavior	edipoelder	20:47
using for rec inside a function: behavior very slow	Jie Liang	22:10

April 3, 2001

Thread	Author	Time
select statement inside a function: behavior bad	Jie Liang	00:04
Re: using for rec inside a function: behavior very slow	Tom Lane	01:16
Re: very very slow .....	Tom Lane	01:19
Appropriate indices to create for these queries	Gerald Gutierrez	01:49
passing null parameter to plpgsq functions	Picard, Cyril	07:00
Re: Appropriate indices to create for these queries	Richard Huxton	08:03
Re: passing null parameter to plpgsq functions	Richard Huxton	08:05
RE: passing null parameter to plpgsq functions	Picard, Cyril	09:39
Re: passing null parameter to plpgsq functions	Richard Huxton	11:51
Re: serial type; race conditions	postgresql	13:33
Error:TypeCreate: type links already defined 📎	Najm Hashmi	14:20
pg_dumpall and password access	Christophe Labouisse	22:47
Re: pg_dumpall and password access	Tom Lane	23:29
Re: Implicit/Explicit casting of the unknown type	Stephen Jackson	23:45

April 4, 2001

Thread	Author	Time
Re: Implicit/Explicit casting of the unknown type	Josh Berkus	03:34
Inserting binary data (BLOBs) in v7.1	David Lizano	09:05
Re: pg_dumpall and password access	J.H.M. Dassen Ray	09:07
Re: pg_dumpall and password access	David Lizano	09:32
performance of functions - or rather lack of it	Peter Galbavy	10:12
Re: performance of functions - or rather lack of it	Peter Galbavy	10:48
restoring indices	Koen Antonissen	11:01
outer joins	Algirdas Šakmanas	11:03
Historical dates in Timestamp	Albert REINER	11:04
max( bool )?	Cedar Cox	12:32
Re: outer joins	[email protected]	14:22
Re: outer joins	Poet/Joshua Drake	14:49
[7.0.3] optimizing a LIKE query ...	The Hermit Hacker	14:59
RE: outer joins	Picard, Cyril	15:01
Re: max( bool )?	Tom Lane	15:16
Query broken under 7.1RC2 📎	Kyle	15:24
Strategy for unlocking query 📎	Graham Vickrage	15:34
Re: Query broken under 7.1RC2	Tom Lane	15:54
Re: Strategy for unlocking query	Tom Lane	16:07
Re: Historical dates in Timestamp	Tom Lane	16:36
Re: performance of functions - or rather lack of it	Tom Lane	17:01
Memory and performance 📎	edipoelder	17:15
Need to do an ALTER TABLE.	jkakar	17:57
Memory exhaustion	Srikanth Rao	18:45
[pgsql-general] Baffling Performance	Poet/Joshua Drake	18:53
Re: Need to do an ALTER TABLE.	Tom Lane	18:55
searching for dates	Birgit Jansen	19:27
Re: searching for dates	Oliver Elphick	20:14
Re: Memory exhaustion	J.H.M. Dassen Ray	20:33
Re: Memory and performance	Richard Huxton	20:34
UNION in a VIEW?	Gordon A. Runkle	20:47
Re: max( bool )? 📎	Cedar Cox	22:02
Re: max( bool )?	Tom Lane	22:02
performance inconsistency	Phuong Ma	22:12
Re: UNION in a VIEW?	Tom Lane	22:13
Re: Memory and performance	Edipo Elder Fernandes de Melo	22:15
Re: [SQL] performance inconsistency	Tom Lane	22:47
Re: [7.0.3] optimizing a LIKE query ...	Tom Lane	23:06
Re: Need to do an ALTER TABLE.	Josh Berkus	23:07
Re: UNION in a VIEW?	Josh Berkus	23:18
Re: UNION in a VIEW?	Gordon A. Runkle	23:41
Re: UNION in a VIEW?	Gordon A. Runkle	23:57

April 5, 2001

Thread	Author	Time
RE: RE: serial type; race conditions	Gerald Gutierrez	00:24
Re: Memory and performance	Tom Lane	01:53
[Tip] Using list-aggregates for faster batching	Joel Burton	01:59
Index on View ?	Keith Gray	04:18
Re: performance of functions - or rather lack of it	Peter Galbavy	07:29
Re: Index on View ?	Richard Huxton	08:45
SELECT ... FOR UPDATE	Loïc Bourgeois	12:29
Re: Memory and performance	Tim Perdue	12:52
Re: UNION in a VIEW?	Gordon A. Runkle	13:30
Re: Re: UNION in a VIEW?	Josh Berkus	14:29
Project Development 📎	Kyle	14:39
Re: Memory and performance	Tom Lane	14:46
Re: Memory and performance	Tim Perdue	14:57
Re: Re: UNION in a VIEW?	Gordon A. Runkle	15:21
RE: RE: serial type; race conditions	Jeff Eckermann	15:35
FW: RE: serial type; race conditions	Jeff Eckermann	15:59
please help	Loïc Bourgeois	16:14
Re: Project Development	Joel Burton	16:24
Double-nesting quotes?	Josh Berkus	18:48
Re: please help	Peter Eisentraut	19:40
Re: Index on View ?	Keith Gray	23:14
Re: Index on View ?	Ian Harding	23:19

April 6, 2001

Thread	Author	Time
Re: very very slow .....	J.Fernando Moyano	00:36
get all online user?	guard	02:52
Re: please help	Loïc Bourgeois	07:19
help	Loïc Bourgeois	07:49
Re: Index on View ?	Richard Huxton	08:54
Casting numeric to text	Hans-Jürgen Schönig	11:08
how to do this join ?	juerg.rietmann	12:10
Aliasing on tables ...	Hans-Jürgen Schönig	12:24
7.1 out soon?	lbottorff	14:05
Re: 7.1 out soon?	The Hermit Hacker	14:33
Re: 7.1 out soon?	The Hermit Hacker	14:34
Re: how to do this join ?	Tom Lane	14:46
Re: how to do this join ?	Peter Eisentraut	14:51
pg_dump and oid	Richard	16:45
Does pg_dump stable on v7.0	Jie Liang	17:37
"row_count" reserved?	Josh Berkus	23:32

April 7, 2001

Thread	Author	Time
Re: "row_count" reserved?	Tom Lane	00:03
Memory And Performance	Mark Kirkwood	03:31
Update 📎	Kyle	18:37
7.1 grant/revoke speed 📎	Kyle	20:22
Need help with EXECUTE function	Josh Berkus	21:09

April 8, 2001

Thread	Author	Time
Re: [GENERAL] Re: Permissons on database	Louis-David Mitterrand	09:10
Re: Maybe a Bug, maybe bad SQL	Louis-David Mitterrand	09:36
Re: Can anyone explain how this works?	Joel Burton	09:50
Re: Casting numeric to text	Peter Eisentraut	10:05
open and closed paths ...	Hans-Jürgen Schönig	13:59
Re: open and closed paths ...	Peter Eisentraut	21:15
Re: please help	Cedar Cox	22:55
Re: Double-nesting quotes?	Cedar Cox	23:03
Re: Casting numeric to text	Cedar Cox	23:20
Re: Need help with EXECUTE function 📎	Cedar Cox	23:57

April 9, 2001

Thread	Author	Time
Re: open and closed paths ...	Hans-Jürgen Schönig	08:02
install pgSQL 7.1	datactrl	08:10
create function	Tomáš Nohejl	08:42
Re: Casting numeric to text	Peter Eisentraut	15:57
Re: please help	Peter Eisentraut	16:01
Re: Casting numeric to text	Ross J. Reedstrom	16:26
pg_dump and BLOB	Richard	16:49
Re: Casting numeric to text	Peter Eisentraut	16:53
Re: Re: open and closed paths ...	Peter Eisentraut	16:55
Re: Casting numeric to text	Ross J. Reedstrom	17:02
Re: select substr???	Tim Johnson	17:05
Re: Re: select substr???	Peter Eisentraut	18:38
Sorting and then...	Wei Weng	23:22

April 10, 2001

Thread	Author	Time
Inheritance Semantics	Mark Butler	01:59
Re: Sorting and then...	Roberto Mello	02:40
Re: Inheritance Semantics	Bruce Momjian	03:00
problem with copy command	Jaruwan Laongmal	08:14
Foreign Key between different databases	Stan van de Mortel	08:53
RE: Sorting and then...	Michael Ansley	09:30
Re: 7.1 out soon?	Peter Peltonen	11:07
Copying null values	Amanda Riera	12:17
The Momjian Tome / DBA Certification	Thomas Good	12:26
Re: Copying null values	Christof Glaser	14:21
Re: problem with copy command	Joel Burton	15:36
Re: Re: select substr???	Albert REINER	16:38
Re: Sorting and then...	Jason Earl	17:32
Semantics of Typed Numeric Constants	Mark Butler	18:02
Re: \i command	Joel Burton	18:37
a select statement that sometimes joins	Mark Stosberg	19:13
Re: Re: \i command	Joel Burton	19:14
Re: a select statement that sometimes joins	Oliver Elphick	20:05
RE: Re: select substr???	Jeff Eckermann	22:41
RE: Re: select substr???	Jeff Eckermann	23:08
Re: [GENERAL] install pgSQL 7.1	datactrl	23:44

April 11, 2001

Thread	Author	Time
Re: Re: 7.1 out soon?	The Hermit Hacker	00:58
Re: Foreign Key between different databases	Cedar Cox	08:56
Re: problem with copy command	George Moga	09:27
Savepoints	Hans-Jürgen Schönig	10:09
Concatenate fields	Amanda Riera	11:31
Re: problem with copy command	Oliver Elphick	11:59
enumerating rows	Kovacs Zoltan	12:02
Re: Concatenate fields	Oliver Elphick	12:14
Re: Re: \i command	cbell	13:05
Re: enumerating rows	Poul L. Christiansen	13:29
Re: enumerating rows	Kovacs Zoltan	14:37
\i command 📎	Najm Hashmi	15:07
RE: enumerating rows	Koen Antonissen	15:56
Dropping users with no name	Hans-Jürgen Schönig	16:29
Re: enumerating rows	Kovacs Zoltan	16:43
Re: enumerating rows 📎	Oliver Elphick	16:46
Making SELECT COUNT(seed) FROM fast	Gerald Gutierrez	17:58
Re: Re: \i command 📎	Najm Hashmi	18:16
Re: enumerating rows	Josh Berkus	18:29
Re: Making SELECT COUNT(seed) FROM fast	Peter Eisentraut	18:30
Problem in writing functions	Kris	18:50
Re: enumerating rows	Oliver Elphick	20:08
Re: enumerating rows	Joel Burton	21:53
DB porting questions...	Diehl, Jeffrey	23:02
RE: DB porting questions...	Michael Ansley	23:29
Re: DB porting questions...	Josh Berkus	23:29
Re: DB porting questions...	Joel Burton	23:34

April 12, 2001

Thread	Author	Time
Timezone conversion	Roberto Mello	02:08

Browse Archives

Prev | Next