pgsql-sql since 2000-09-28 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

Sept. 28, 2000

Thread	Author	Time
Re: memory usage	Josh Berkus	04:12
memory usage	Carolyn Wong	04:39
Re: memory usage	John Hasler	15:00
transactions surrounding extension functions	Forest Wilkinson	18:30
Re: transactions surrounding extension functions	Peter Eisentraut	19:04

Sept. 29, 2000

Thread	Author	Time
Re: memory usage	Carolyn Wong	00:19
Date problem	Edipo E. F. Melo	02:05
Re: Date problem	Josh Berkus	05:41
Re: Date problem	Tom Lane	06:24
invoke an external shell script from a function	Chau, Artemis	15:15
Re: invoke an external shell script from a function	Peter Eisentraut	16:31
timestamp difference in hours? (fwd)	Alessandro Rossi	19:46
Re: invoke an external shell script from a function	Joel Mc Graw	23:20

Sept. 30, 2000

Thread	Author	Time
Re: More efficient DELETE ... ?	Bruce Momjian	02:24
Transaction isolation level for plpgsql	Keith Wong	02:32
Re: Transaction isolation level for plpgsql	Peter Eisentraut	10:56
Re: Transaction isolation level for plpgsql	Poul L. Christiansen	11:08

Oct. 1, 2000

Thread	Author	Time
how can I mirror a postgres database	Dronamraju Rajesh	01:39
Re: how can I mirror a postgres database	Philip Warner	04:05

Oct. 2, 2000

Thread	Author	Time
Re: question on diagnostics	Bruce Momjian	04:17
currval	Craig May	04:56
Q: spinlock on Alpha? (PG7.0.2)	Emils Klotins	05:38
Re: Q: spinlock on Alpha? (PG7.0.2)	Tom Lane	06:36
Re: Q: spinlock on Alpha? (PG7.0.2)	Fabrice Scemama	10:19
Concerns about the OID	Josh Berkus	15:39
foreign key introduces unnecessary locking ?	Rini Dutta	15:39

Oct. 3, 2000

Thread	Author	Time
trigger question	Carolyn Lu Wong	00:50
Re: Something I'd like to try...	Bruce Momjian	03:22
Re: Something I'd like to try...	Cristóvão Dalla Costa	03:52
Re: Something I'd like to try...	Tom Lane	04:29
Re: trigger examples	drfrog	04:41
trigger examples	Carolyn Lu Wong	05:20
DB backup and connection questions	Carolyn Lu Wong	05:27
Re: trigger examples	Carolyn Lu Wong	07:05
-query sql	Nema, Vivek	08:16
grant select on ALL(?) to dbuser;	Marcin Mazurek	09:36
Re: Q: spinlock on Alpha? (PG7.0.2) - solved	Emils Klotins	10:14
Re: grant select on ALL(?) to dbuser;	Marcin Mazurek	12:01
Re: grant select on ALL(?) to dbuser;	Antti Linno	12:01
Object features of pg	Michael Ansley	13:14
Re: Object features of pg	Peter Mount	13:32
Re: trigger examples 📎	Keith Wong	13:41
RE: Object features of pg	Michael Ansley	13:44
RE: Object features of pg	Michael Ansley	14:21
RE: Object features of pg	Michael Ansley	14:25
RE: Object features of pg	Michael Ansley	14:52
table as field type??	David Diller	14:59
RE: Object features of pg	Tod McQuillin	15:37
Re: Something I'd like to try...	Josh Berkus	15:41
Re: table as field type??	Tod McQuillin	15:51
OID Perfomance - Object-Relational databases	Josh Berkus	16:06
Re: table as field type??	bmccoy	16:16
RE: OID Perfomance - Object-Relational databases	Michael Ansley	16:17
Re: OID Perfomance - another question	Mitch Vincent	16:23
Re: OID Perfomance - another question	Tod McQuillin	16:24
Re: OID Perfomance - Object-Relational databases	Mitch Vincent	16:35
RE: OID Perfomance - Object-Relational databases	Michael Ansley	16:35
RE: OID Perfomance - Object-Relational databases	Michael Ansley	16:54
Re: Something I'd like to try...	Barry Lind	17:38
Re: Something I'd like to try...	Tom Lane	19:03
Re: OID Perfomance - Object-Relational databases	Tom Lane	19:10
Possibly to get off the list?	Mads Jensen	20:20
pesky select query	Ingram, Bryan	20:47
Re: pesky select query	Tom Lane	23:37
RE: Object features of pg	Peter Mount	23:56

Oct. 4, 2000

Thread	Author	Time
Re: OID Perfomance - Object-Relational databases	Josh Berkus	00:33
Re: OID Perfomance - Object-Relational databases	Michael Fork	01:26
Re: OID Perfomance - Object-Relational databases	Tom Lane	03:36
Re: OID Perfomance - Object-Relational databases	Tom Lane	03:43
Re: OID Perfomance - Object-Relational databases	Josh Berkus	04:10
RE: OID Perfomance - Object-Relational databases	Michael Ansley	09:27
Q: performance on some selects (7.0.2)?	Emils Klotins	10:05
Re: Q: performance on some selects (7.0.2)?	Grant Finnemore	10:24
Re: OID Perfomance - Object-Relational databases	Jeff MacDonald	11:43
RE: Re: OID Perfomance - Object-Relational databases	Michael Ansley	12:59
Re: Q: performance on some selects (7.0.2)?	Tom Lane	15:22
Typecast a user-defined type?	Mark Volpe	15:48
Re: Typecast a user-defined type?	Tom Lane	15:59
Re: createuser	Peter Eisentraut	20:07
"Delete before" in ms sql?	Lars Vadsholt	20:19
JDBC: oid after insert	Markus Wagner	21:11

Oct. 5, 2000

Thread	Author	Time
createuser	Craig May	06:07
Object syntax	Michael Ansley	13:19
JDBC and BLOB in Postgres	Didier Boudigue	13:47
Re: [SQL] Object syntax	Tom Lane	14:32
Re: JDBC and BLOB in Postgres	Josh Berkus	15:56
Re: Object syntax	Josh Berkus	15:58
The TEXT data type	Josh Berkus	16:02
Loading JDBC Driver	Jos Hernndez Zavala	18:17
Re: Object syntax	Tom Lane	19:43
Granting of permissions on tables	Saltsgaver, Scott	21:12
Re: Granting of permissions on tables	Peter Eisentraut	21:26
Re: Granting of permissions on tables	Tom Lane	21:37

Oct. 6, 2000

Thread	Author	Time
Re: Counting bool flags in a complex query	Tom Lane	05:01
RE: Granting of permissions on tables	Saltsgaver, Scott	13:25
Re: Granting of permissions on tables	Tom Lane	15:07
Re: Re: [HACKERS] Counting bool flags in a complex query	Josh Berkus	16:31
Re: Re: [HACKERS] Counting bool flags in a complex query	Tom Lane	21:23

Oct. 7, 2000

Thread	Author	Time
Re: Date problem	Edipo E. F. Melo	02:56
Windows 9X	Craig May	03:52

Oct. 9, 2000

Thread	Author	Time
Re: OID Perfomance - Object-Relational databases	Bruce Momjian	01:56
Re: Loading JDBC Driver	Peter Mount	12:42
Table Attribute Help	Brian C. Doyle	15:21
Re: Table Attribute Help	Jeff Hoffmann	15:33
Re: AW: Table Attribute Help	Brian C. Doyle	15:38
Re: Table Attribute Help	omid omoomi	15:47
Re: OID Perfomance - Object-Relational databases	Josh Berkus	17:34
Re: OID Perfomance - Object-Relational databases	Josh Berkus	19:04
Re: OID Perfomance - Object-Relational databases	Bruce Momjian	19:19
Re: OID Perfomance - Object-Relational databases	Tom Lane	20:14
Re: OID Perfomance - Object-Relational databases	Josh Berkus	22:44
RE: foreign key introduces unnecessary locking ?	Mikheev, Vadim	23:11
Re: foreign key introduces unnecessary locking ?	Stephan Szabo	23:27
Re: OID Perfomance - Object-Relational databases	Bruce Momjian	23:30

Oct. 10, 2000

Thread	Author	Time
Re: "Delete before" in ms sql?	Josh Berkus	00:10
Re: -query sql	John McKown	00:17
Re: AW: Table Attribute Help	Michael Fork	17:21

Oct. 11, 2000

Thread	Author	Time
Re: [SQL] Q: spinlock on Alpha? (PG7.0.2)	Ryan Kirkpatrick	04:21
Re: [SQL] Q: spinlock on Alpha? (PG7.0.2) - solved	Ryan Kirkpatrick	04:41
Re: Re: [SQL] Q: spinlock on Alpha? (PG7.0.2)	Thomas Lockhart	05:51
Can I use subselect as a function parameter?	Oliver Elphick	13:42
Re: Can I use subselect as a function parameter?	Tom Lane	14:25
AFTER triggers, short question	Mark Volpe	14:49
Re: Can I use subselect as a function parameter?	Philip Warner	14:55
SQL to retrieve foreign keys	Colleen Williams	15:56
Re: SQL to retrieve foreign keys	Stephan Szabo	16:29
Referential integrity: broken rule?	Franz J Fortuny	19:18
Re: Referential integrity: broken rule?	Stephan Szabo	22:15

Oct. 12, 2000

Thread	Author	Time
set digest	karasiov	08:51
if else query help	Brian C. Doyle	14:14
Re: dynamic object creation	Mark Volpe	14:22
Re: if else query help	Jean-Christophe Boggio	14:56
Re: if else query help	Josh Berkus	15:35
Re: if else query help	Jie Liang	17:36
Standard syntax?	Franz J Fortuny	17:44
Re: Standard syntax?	Josh Berkus	17:54
Re: Standard syntax?	Tomas Berndtsson	17:54
Re: Standard syntax?	Jie Liang	18:19
Re: if else query help	John McKown	18:37
Re: Standard syntax?	Peter Eisentraut	18:45
Re: Standard syntax?	Tom Lane	19:32
dynamic object creation	Indraneel Majumdar	19:56
xml perl & pgsql	Philip Cook	21:50
Problem whith Stored queries	Nelson Brito	22:49

Oct. 13, 2000

Thread	Author	Time
Operator Column	Itai Zukerman	11:20
Re: dynamic object creation	Indraneel Majumdar	21:10
Re: dynamic object creation	Indraneel Majumdar	21:11

Oct. 15, 2000

Thread	Author	Time
Variable-length Types	Itai Zukerman	14:00
Re: Variable-length Types	Josh Berkus	18:31
Re: Regular expression query	Bruce Momjian	18:50
Re: Variable-length Types	Tom Lane	20:26
Re: Variable-length Types	Josh Berkus	20:36
Re: Variable-length Types	Itai Zukerman	20:58
Re: Variable-length Types	KuroiNeko	21:17

Oct. 16, 2000

Thread	Author	Time
Re: Variable-length Types	Josh Berkus	00:39
Re: Variable-length Types	Josh Berkus	02:10
Re: Variable-length Types	Bruce Momjian	02:22
Antw: many-many mapping between unique tables	Gerhard Dieringer	06:57
Re: Antw: many-many mapping between unique tables	Gerhard Dieringer	08:09
Re: JDBC Performance	Josh Berkus	15:13
Re: Antw: many-many mapping between unique tables	KuroiNeko	15:14
Re: Antw: many-many mapping between unique tables	Josh Berkus	15:17
many-many mapping between unique tables	Indraneel Majumdar	18:11
JDBC Performance	Craig May	19:49
Re: Antw: many-many mapping between unique tables	Indraneel Majumdar	20:13
Re: Antw: many-many mapping between unique tables	Indraneel Majumdar	21:39
Re: Antw: many-many mapping between unique tables	Indraneel Majumdar	21:54
Formatting US phone numbers, was Variable-length Types	KuroiNeko	22:01
Re: many-to-many mapping	K Parker	22:49

Oct. 17, 2000

Thread	Author	Time
Re: Antw: many-many mapping between unique tables	Indraneel Majumdar	05:19
Last serial number inserted	Eduardo	10:16
Re: Last serial number inserted	Josh Berkus	15:47
Re: Variable-length Types	DalTech - CTE	16:54
nested transactions 📎	Bernie Huang	18:02
Big Sub-select statement 📎	Bernie Huang	18:53
problem with select where like ']'	hubert depesz lubaczewski	19:02
Re: JDBC Performance	Peter Mount	19:23
Re: problem with select where like ']'	Tom Lane	19:33
Re: problem with select where like ']'	KuroiNeko	20:07
Re: nested transactions	Bruce Momjian	20:49
Re: nested transactions	John Hasler	22:25
Re: problem with select where like ']'	Joseph Shraibman	22:43
Re: problem with select where like ']'	Tom Lane	23:29
RE: nested transactions	Mikheev, Vadim	23:37
Re: problem with select where like ']'	Bruce Momjian	23:43
Re: problem with select where like ']'	Joseph Shraibman	23:53

Oct. 18, 2000

Thread	Author	Time
Re: problem with select where like ']'	Vince Vielhaber	00:00
Re: problem with select where like ']'	Bruce Momjian	00:05
Function that returns a tuple.	Claudio Jose Zanardi Grillo	13:32
Re: problem with select where like ']'	Peter Eisentraut	15:24
Re: Function that returns a tuple.	Josh Berkus	15:36
Re: Function that returns a tuple.	Tom Lane	16:32

Oct. 19, 2000

Thread	Author	Time
substr	Jeff MacDonald	13:19
Re: substr	Tom Lane	14:50
Re: substr	Jeff MacDonald	16:05
Re: COUNT	Frank Bax	18:05
Re: COUNT	Brian C. Doyle	18:07
Re: COUNT	Jie Liang	18:13
Re: COUNT	Daniel Wickstrom	18:30
Re: COUNT	bmccoy	18:35

Browse Archives

Prev | Next