pgsql-sql - November 2002

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

Thread Author Time
Re: How do you write this query? Achilleus Mantzios 07:51
7.2.3: tuple is too big (max 8136) pilsl 13:33
Re: 7.2.3: tuple is too big (max 8136) Doug McNaught 13:50
Different size in the DATA directory Maurício Sessue Otta 14:09
Re: Different size in the DATA directory Maurício Sessue Otta 14:25
FIFO Queue Problems Chris Gamache 14:56
Re: Different size in the DATA directory dima 15:22
Re: Different size in the DATA directory Stephan Szabo 15:32
Re: Different size in the DATA directory Tim Perdue 16:02
Re: FIFO Queue Problems Richard Huxton 16:20
Re: Selecting * from the base table but getting the inheriteds Ross J. Reedstrom 16:37
Re: FIFO Queue Problems Tom Lane 16:51
Re: FIFO Queue Problems Bruno Wolff III 16:54
HA PostgreSQL Charles H. Woloszynski 18:26
Re: FIFO Queue Problems Wei Weng 19:18
Re: FIFO Queue Problems Tom Lane 19:47
Re: FIFO Queue Problems Bruno Wolff III 19:56
Does this matter? Wei Weng 20:18
Re: Does this matter? Josh Berkus 20:23
Re: Does this matter? Wei Weng 20:52
Re: Does this matter? Philip Hallstrom 20:53
Re: Does this matter? Andrew Sullivan 21:10
Re: unnecessary updates Ross J. Reedstrom 21:27
select syntax question Wei Weng 21:33
Re: select syntax question Bruno Wolff III 21:59
Re: Does this matter? Josh Berkus 22:00
Re: Does this matter? Curtis Faith 22:00
Re: Does this matter? Josh Berkus 22:01
Re: making queries more effecient Chad Thompson 22:04
Subtracting time fields Kevin Old 22:05
Re: making queries more effecient Josh Berkus 22:09
Re: HA PostgreSQL Robert Treat 22:12
making queries more effecient Peter T. Brown 22:24
Re: Subtracting time fields Bruno Wolff III 22:30
Re: making queries more effecient Josh Berkus 22:36

Nov. 2, 2002

Thread Author Time
Re: How do I get rid of these messages? Bruce Momjian 01:47
Re: Different size in the DATA directory Bruce Momjian 03:48
Re: select syntax question Bruce Momjian 04:07
Timezone issue with date_part Ken Kennedy 06:56
Re: Timezone issue with date_part Tom Lane 14:17
Re: Different size in the DATA directory Alexander M. Pravking 14:33
Re: Timezone issue with date_part Ken Kennedy 20:55
Re: Timezone issue with date_part Josh Berkus 21:21

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

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