pgsql-sql since 2002-11-03 00:00

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. 3, 2002

Thread Author Time
Re: Different size in the DATA directory 📎 Bruce Momjian 01:20
uniqueidentifier datatype for 7.3.X Dmitry G. Mastrukov Дмитрий Геннадьевич Мастрюков 09:53
Re: Different size in the DATA directory Alexander M. Pravking 12:19
Re: uniqueidentifier datatype for 7.3.X Tom Lane 16:08

Nov. 4, 2002

Thread Author Time
Re: 7.2.3: tuple is too big (max 8136) pilsl 00:11
Re: 7.2.3: tuple is too big (max 8136) Doug McNaught 00:19
Re: 7.2.3: tuple is too big (max 8136) Stephan Szabo 00:38
Re: 7.2.3: tuple is too big (max 8136) Tom Lane 02:19
Re: Does this matter? Neil Conway 04:08
Re: [PERFORM] Does this matter? Wei Weng 04:33
Re: uniqueidentifier datatype for 7.3.X Dmitry G. Mastrukov Дмитрий Геннадьевич Мастрюков 06:33
Comparing Numeric and Double Precision (float8).. Terry Yapt 08:11
Re: Comparing Numeric and Double Precision (float8).. Bruno Wolff III 13:45
Re: Comparing Numeric and Double Precision (float8).. Terry Yapt 14:35
Problem with Auto Increment Ben Kassel 18:29
Re: Problem with Auto Increment Stephan Szabo 20:45
Re: [SQL] Database Design tool Patrick Bakker 21:00
Re: [SQL] Database Design tool Larry Rosenman 21:01
counting text matches - any recipes? Ross J. Reedstrom 22:53
Re: counting text matches - any recipes? Josh Berkus 23:26
Referential integrity Freeze Rudi Starcevic 23:37

Nov. 5, 2002

Thread Author Time
Re: Referential integrity Freeze Stephan Szabo 00:05
Re: Referential integrity Freeze Rudi Starcevic 00:16
query optimization question terry 00:19
owner of type 'mmm' apperars to be invalid cristi 05:57
Re: owner of type 'mmm' apperars to be invalid Richard Huxton 10:57
Re: [GENERAL] Database Design tool Michael Ansley (UK) 11:46
Re: owner of type 'mmm' apperars to be invalid cristi 13:03
Re: owner of type 'mmm' apperars to be invalid Richard Huxton 13:21
Copying a rowtype variable. Rison, Stuart 13:33
Re: [GENERAL] Database Design tool Thomas Good 14:00
Re: [GENERAL] Database Design tool tony 14:24
Re: owner of type 'mmm' apperars to be invalid cristi 14:32
Re: owner of type 'mmm' apperars to be invalid Richard Huxton 14:51
Re: [GENERAL] Database Design tool Josh Berkus 16:33
Re: [GENERAL] Database Design tool Robert Treat 16:50
Re: [SQL] Copying a rowtype variable. Josh Berkus 16:55
Re: [GENERAL] Database Design tool Josh Berkus 18:19
Re: [GENERAL] Database Design tool Kaare Rasmussen 20:16
Re: [GENERAL] Database Design tool Robert Treat 21:17

Nov. 6, 2002

Thread Author Time
Problem: Referential Integrity Constraints lost Achilleus Mantzios 12:41
Re: [SQL] Problem: Referential Integrity Constraints lost Achilleus Mantzios 12:53
Re: query optimization question terry 13:56
FW: query optimization question terry 14:01
Re: [SQL] Problem: Referential Integrity Constraints lost: Correction Achilleus Mantzios 14:10
primary keys Huub 14:18
Re: FW: query optimization question Richard Huxton 15:11
Re: query optimization question Christoph Haller 15:58
Re: FW: query optimization question Stephan Szabo 16:22
Re: [SQL] Problem: Referential Integrity Constraints lost Stephan Szabo 16:25
Re: FW: query optimization question terry 16:36
Re: FW: query optimization question Stephan Szabo 16:44
Re: query optimization question Masaru Sugawara 16:44
Re: query optimization question terry 17:10
Re: query optimization question Masaru Sugawara 17:11
Re: Copying a rowtype variable. Rison, Stuart 21:30
Cannot assign ROWTYPE, RECORD variables in PL/pgSQL Josh Berkus 22:27

Nov. 7, 2002

Thread Author Time
Re: [SQL] Problem: Referential Integrity Constraints lost Achilleus Mantzios 07:33
Re: [SQL] Problem: Referential Integrity Constraints lost Achilleus Mantzios 07:57
Re: query optimization question Christoph Haller 08:57
how to get the source table & field name of a view field Prime Ho 09:12
Re: [pgsql-sql] Daily Digest V1 #983 vist 09:27
Weird NULL behavior Ludwig Lim 11:41
Generating a cross tab (pivot table) Christoph Haller 11:47
Re: Generating a cross tab (pivot table) Richard Huxton 12:15
cast lo to oid Nekta Katz 12:22
Re: primary keys terry 13:54
Re: primary keys Rachel.Vaudron 14:01
Re: how to get the source table & field name of a view field Christoph Haller 14:06
Re: how to get the source table & field name of a view field Achilleus Mantzios 14:25
Re: primary keys Achilleus Mantzios 14:28
Re: primary keys Huub 14:29
PLpgSQL FOR IN EXECUTE question Christoph Haller 14:35
Re: primary keys Bruno Wolff III 14:35
Re: primary keys Tomasz Myrta 14:49
Re: [SQL] Problem: Referential Integrity Constraints lost Tom Lane 14:55
Re: how to get the source table & field name of a view field Ken Kennedy 15:08
Re: primary keys Sangeetha Rao 15:12
Re: cast lo to oid Tom Lane 15:16
Re: PLpgSQL FOR IN EXECUTE question Richard Huxton 16:13
Re: Copying a rowtype variable. Jean-Luc Lachance 16:28
Re: [SQL] Problem: Referential Integrity Constraints lost Achilleus Mantzios 16:38
Re: Weird NULL behavior Stephan Szabo 16:41
Re: Copying a rowtype variable. Rison, Stuart 16:51
Re: Generating a cross tab (pivot table) Joe Conway 17:25
Re: PLpgSQL FOR IN EXECUTE question Tom Lane 18:01
Quartile (etc) ranking in a SQL statement? Jeff Boes 18:16
Re: Weird NULL behavior Tom Lane 19:09
pg_dump, no inserts but \copy? Joost Witteveen 19:20
Re: Weird NULL behavior Stephan Szabo 19:35
Re: Weird NULL behavior Tom Lane 20:00
Re: Quartile (etc) ranking in a SQL statement? Jean-Luc Lachance 20:50
Re: PLpgSQL FOR IN EXECUTE question Josh Berkus 21:30
Re: Cannot assign ROWTYPE, RECORD variables in PL/pgSQL Neil Conway 21:56
Re: Cannot assign ROWTYPE, RECORD variables in PL/pgSQL Josh Berkus 22:57
Re: query optimization question terry 23:18

Nov. 8, 2002

Thread Author Time
Re: cast lo to oid Nekta Katz 00:11
Re: cast lo to oid Nekta Katz 00:24
Re: Cannot assign ROWTYPE, RECORD variables in PL/pgSQL elein 03:11
get source table.field name from view's field Prime Ho 05:17
Delete cascade for multi tables? Zhidian Du 05:36
No promany key in parent table, how to use delete cascade? Zhidian Du 06:19
Re: No promany key in parent table, how to use delete cascade? Stephan Szabo 06:49
Alter table Rachel.Vaudron 07:22
changing numeric into int Huub 07:41
Re: how to get the source table & field name of a view field Christoph Haller 08:22
Re: Alter table Tomasz Myrta 08:44
Re: Alter table Rachel.Vaudron 08:50
Re: PLpgSQL FOR IN EXECUTE question Christoph Haller 09:06
Re: Generating a cross tab (pivot table) Ludwig Lim 09:39
Re: query optimization question Christoph Haller 10:01
Re: Alter table Daniel Schuchardt 13:24
Re: query optimization question Masaru Sugawara 14:22
Re: pg_dump, no inserts but \copy? Bruce Momjian 15:56
Permission on insert rules Luis Sousa 17:29
Time difference without intervals Roberto Mello 18:20
Re: Time difference without intervals Bruno Wolff III 18:59
Re: changing numeric into int Robert Treat 19:12
Re: Time difference without intervals Tom Lane 21:11

Nov. 9, 2002

Thread Author Time
Re: Permission on insert rules Josh Berkus 01:35
Re: Permission on insert rules Bruce Momjian 02:40
Passing OLD/NEW as composite type PL/PGSQL Ludwig Lim 02:50
More than 1 trigger of the same kind Ludwig Lim 03:35
Re: More than 1 trigger of the same kind Stephan Szabo 03:49
Some more weird NULL behavior Ludwig Lim 04:30
Re: More than 1 trigger of the same kind Tom Lane 04:33
Re: Some more weird NULL behavior Stephan Szabo 05:13
Output of function into a file karthick v 05:30
CREATE VIEW (dynamically) Emmanuel Engelhart 14:52
Re: Time difference without intervals Bruno Wolff III 15:52
execute a query in an other db LR 16:51

Nov. 10, 2002

Thread Author Time
table protein does not have an attribute oid? why? Zhidian Du 06:01
Parent table has not oid? Zhidian Du 06:04
Re: [SQL] Parent table has not oid? Tom Lane 13:50

Nov. 11, 2002

Thread Author Time
Re: Time difference without intervals Roberto Mello 05:17
Re: Time difference without intervals Tom Lane 05:22
small problem Carlos Sousa 14:30
small proble Carlos Sousa 14:30
Re: small problem dima 14:42
bigger problem Carlos Sousa 14:57
Re: Generating a cross tab (pivot table) Christoph Haller 15:42
Generating a cross tab II (pivot table) 📎 Christoph Haller 15:55
Re: Permission on insert rules Robert Treat 16:45
Re: Permission on insert rules Josh Berkus 17:59
Re: bigger problem Josh Berkus 18:13
Re: Generating a cross tab (pivot table) Josh Berkus 18:27
parse bug floyds 19:25
Re: bigger problem Peter Eisentraut 20:12
Re: Permission on insert rules Josh Berkus 20:12

Nov. 12, 2002

Thread Author Time
pg_dump / dates: Martin Crundall 05:15
[No subject] dnaren 07:22
Efficient ON DELETE trigger when referential integrity is involved ? Cédric Dufour 09:42
Efficient ON DELETE trigger when referential integrity is involved ? Cédric Dufour (Cogito Ergo Soft) 09:50
Re: Richard Huxton 10:19
Re: CREATE VIEW (dynamically) Christoph Haller 13:57
Re: parse bug Achilleus Mantzios 14:10
Re: execute a query in an other db Bruno Wolff III 14:18
Re: Output of function into a file Christoph Haller 14:37
averaging interval values praveen vejandla 15:40
Re: averaging interval values Christoph Haller 16:07
Re: Efficient ON DELETE trigger when referential integrity is Stephan Szabo 16:30
Re: Permission on insert rules Luis Sousa 17:10
Re: [SQL] Parent table has not oid? scott.marlowe 17:12
Re: Permission on insert rules Luis Sousa 17:12
Re: Permission on insert rules Luis Sousa 17:16
Re: Permission on insert rules Josh Berkus 17:29
Inconsistent or incomplete behavior obverse in where clause Paul Ogden 17:39
Re: Inconsistent or incomplete behavior obverse in where Josh Berkus 18:23
Re: Inconsistent or incomplete behavior obverse in where clause Tom Lane 18:34
Re: [HACKERS] Inconsistent or incomplete behavior obverse in where Tom Lane 18:44
Re: [SQL] Output of function into a file Rajesh Kumar Mallah. 18:48
Re: Inconsistent or incomplete behavior obverse in where Paul Ogden 18:52
Re: Inconsistent or incomplete behavior obverse in where Josh Berkus 19:13
Re: Postgres Date pg_dump/Import: Martin Crundall 20:12
Re: Postgres Date pg_dump/Import: Tom Lane 20:41
Re: Postgres Date pg_dump/Import: Martin Crundall 21:19
Re: Permission on insert rules Robert Treat 21:40

Nov. 13, 2002

Thread Author Time
Re: Permission on insert rules Luis Sousa 10:44
Re: Passing OLD/NEW as composite type PL/PGSQL Christoph Haller 12:09
SET DEFAULT Archibald Zimonyi 12:19
Re: SET DEFAULT Achilleus Mantzios 12:38
Re: Permission on insert rules Tom Lane 14:27
Re: Permission on insert rules Luis Sousa 15:09
Re: Permission on insert rules Josh Berkus 17:29
Re: Permission on insert rules Bruno Wolff III 19:52
Re: System´s database table Josh Berkus 20:06
Re: System´s database table Jean-Luc Lachance 20:37
Re: System´s database table Josh Berkus 20:43
RE: [SQL] System´s database table Paul Ogden 20:44
System´s database table Pedro Igor Craveiro e Silva 20:53
Re: RE: [SQL] System´s database table Jean-Luc Lachance 21:28

Nov. 14, 2002

Thread Author Time
Old "Feature" - Copy table ignores column defaults Tim Perdue 01:42
Re: Press Release -- Numbers greg 02:31
Re: Old "Feature" - Copy table ignores column defaults Tom Lane 04:37
Re: Old "Feature" - Copy table ignores column defaults Tom Lane 04:44
Re: RE: [SQL] System´s database table Robert Treat 23:04

Nov. 15, 2002

Thread Author Time
numeric problems jack 02:21
Re: numeric problems Paul Ogden 02:36
Error message: standard SQL or PostgreQSL? Huub 06:31
Does Postgres replace \\ with \ in an update query Vaughn Cleminson 07:23

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