pgsql-sql - August 2003

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 31

Aug. 1, 2003

Thread Author Time
Re: join optimization problem Rod Taylor 00:33
Re: join optimization problem Tom Lane 00:36
Re: Does a the block of code within a stored procedure constitute Rod Taylor 00:37
Re: select query that would join two databases Rod Taylor 00:39
Using contrib/fulltext on multiple tables Eric Johnson 00:54
Re: Does a the block of code within a stored procedure constitute a transaction? btober 01:28
Re: length of recordset read through a cursor Christoph Haller 11:25
Re: converting interval to timestamp Mike Rylander 12:41
duplicate dates Jodi Kanter 15:56
Re: duplicate dates Christopher Browne 15:57
Re: Fwd: Bad Join moment - how is this happening? Jamie Lawrence 17:02
What day is it - when it isn't NOW()? tomg 18:27
Re: What day is it - when it isn't NOW()? Rod Taylor 18:28
Re: What day is it - when it isn't NOW()? Josh Berkus 18:28
Re: What day is it - when it isn't NOW()? tomg 18:53
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Robert Treat 19:16
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Josh Berkus 20:06
Re: NEW and a subselect in a rule Denis Zaitsev 20:12
backend cpu usage? [7.2] george young 20:23
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Richard Poole 20:26
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Josh Berkus 21:02
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Bruce Momjian 21:31
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Josh Berkus 21:39
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Bruce Momjian 21:44
Re: backend cpu usage? [7.2] Tom Lane 22:21

Aug. 2, 2003

Thread Author Time
Efficient deletions? Bertrand Petit 00:21
Re: Efficient deletions? A.Bhuvaneswaran 07:21

Aug. 3, 2003

Thread Author Time
Re: join optimization problem Toby Tremayne 10:20
Re: join optimization problem Toby Tremayne 10:21
Re: join optimization problem Rod Taylor 13:04
Re: join optimization problem Tom Lane 16:19

Aug. 4, 2003

Thread Author Time
How to check: is some key referenced from sometable evl 08:17
Re: Problem with looping on a table function result Christoph Haller 09:26
Re: EXTERNAL storage and substring on long strings Scott Cain 15:25
Re: [SQL] EXTERNAL storage and substring on long strings Tom Lane 15:53
Re: [SQL] EXTERNAL storage and substring on long strings Richard Huxton 15:55
Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain 16:14
Re: [SQL] EXTERNAL storage and substring on long strings Shridhar Daithankar 16:19
Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain 16:25
Re: [SQL] EXTERNAL storage and substring on long strings Matt Clark 16:56
Re: [SQL] EXTERNAL storage and substring on long strings Joe Conway 20:29

Aug. 5, 2003

Thread Author Time
Timestamp in PG - 7.1 & 7.2 Anagha Joshi 10:21
Re: length of recordset read through a cursor Knut P. Lehre 11:13
Re: length of recordset read through a cursor Christoph Haller 12:22
Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain 15:01
Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain 15:05
Re: Timestamp in PG - 7.1 & 7.2 Tom Lane 15:14
Re: [SQL] EXTERNAL storage and substring on long strings Joe Conway 15:19
JDBC encoding problem Kurt Overberg 17:11
JDBC encoding problem Kurt Overberg 17:31
Re: JDBC encoding problem Anders Hermansen 18:00

Aug. 6, 2003

Thread Author Time
Re: [SQL] JDBC encoding problem LEON 01:10
Re: length of recordset read through a cursor Rod Taylor 03:25
Using rowtype as function argument Martin Brommer 09:23
Postgresql slow on XEON 2.4ghz/1gb ram Wilson A. Galafassi Jr. 13:50
Re: looking for empty fields Viorel Dragomir 14:02
looking for empty fields Jodi Kanter 14:07
Re: [SQL] JDBC encoding problem Kurt Overberg 14:18
Re: looking for empty fields Jodi Kanter 14:33
Re: Using rowtype as function argument Tom Lane 14:40
User-defined SQL function has slower query on 7.3.3 than 7.1.3 Andrew Droffner 15:12
Analyze makes queries slow... Stef 15:18
PostgreSql under Linux Wilson A. Galafassi Jr. 18:03
Re: User-defined SQL function has slower query on 7.3.3 than 7.1.3 Tom Lane 18:06
Re: User-defined SQL function has slower query on 7.3.3 than Andrew Droffner 18:34
Re: EXTERNAL storage and substring on long strings Tom Lane 20:36
Re: EXTERNAL storage and substring on long strings Joe Conway 20:51
Re: EXTERNAL storage and substring on long strings Tom Lane 21:08
PostgreSQL and Journaled File Systems Roberto Mello 21:16
Re: PostgreSql under Linux Neil Conway 21:33
Re: PostgreSql under Linux Sam Barnett-Cormack 21:39
Re: PostgreSQL and Journaled File Systems Tom Lane 21:50
Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram Maksim Likharev 22:04

Aug. 7, 2003

Thread Author Time
Books in french BenLaKnet 06:33
Re: PostgreSql under Linux Ben-Nes Michael 08:51
Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram Martijn van Oosterhout 09:30
(no subject) A. Van Hook 10:14
Re: (no subject) Tom Lane 15:10
Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram Robert Treat 15:43
Abort Transaction DP PK (again) alexandre :: aldeia digital 17:04
Testing gateway Marc G. Fournier 17:49
Re: EXTERNAL storage and substring on long strings Scott Cain 21:15

Aug. 8, 2003

Thread Author Time
[pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 BenLaKnet 08:13
Error message with a SQL function krystoffff 14:13
Re: duplicate dates Jonathan Gardner 15:29
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Stephan Szabo 15:52
Re: converting interval to timestamp Jonathan Gardner 16:22
Re: Analyze makes queries slow... Jonathan Gardner 16:24
Re: RI_ConstraintTrigger_11264756 Jonathan Gardner 16:30
Re: Abort Transaction DP PK (again) Josh Berkus 16:37
unexpected chunk value Eric Anderson Vianet SAO 17:40
Re: Analyze makes queries slow... Stef 17:45
Re: Abort Transaction DP PK (again) alexandre :: aldeia digital 20:22
Re: Retrieving tuple data on insert Prasanth 21:01
Re: Abort Transaction DP PK (again) Josh Berkus 21:45

Aug. 9, 2003

Thread Author Time
Comparing arrays Bertrand Petit 10:12
Re: Comparing arrays Tom Lane 14:34
Re: How to check: is some key referenced from sometable Bruno Wolff III 15:08
Re: Error message with a SQL function Tom Lane 15:16
Re: Comparing arrays Joe Conway 16:01
Re: How to check: is some key referenced from sometable eVl One 21:44

Aug. 10, 2003

Thread Author Time
Re: Retrieving tuple data on insert sebmil 03:13
Re: How to check: is some key referenced from sometable Stephan Szabo 05:30
OFF-TOPIC: Richard Huxton, Please Contact Us! Josh Berkus 18:57

Aug. 11, 2003

Thread Author Time
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Benoît Bournon 07:07
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 BenLaKnet 07:23
Re: Comparing arrays Bertrand Petit 09:37
INSERT INTO ... SELECT Silke Trissl 10:21
sub-sel/group problem Gary Stainburn 10:24
Re: sub-sel/group problem Christoph Haller 10:38
Re: sub-sel/group problem Gary Stainburn 10:38
update system table? Eric Anderson Vianet SAO 11:36
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Stephan Szabo 13:14
Re: sub-sel/group problem Stephan Szabo 13:29
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Benoît Bournon 13:40
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 BenLaKnet 13:44
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Stephan Szabo 13:48
Re: sub-sel/group problem Tomasz Myrta 13:49
Query suddenly taking longer.... Kurt Overberg 16:51
Re: Query suddenly taking longer.... Tom Lane 17:45
possible? Fejes Jozsef 19:41
Re: Query suddenly taking longer.... Kurt Overberg 19:44
Re: possible? Franco Bruno Borghesi 21:37
optimisation of a code krystoffff 22:19
string function -- replace needs a clear doc Jie Liang 22:51
Re: string function -- replace needs a clear doc Stephan Szabo 23:00
Re: string function -- replace needs a clear doc Tom Lane 23:12

Aug. 12, 2003

Thread Author Time
Re: INSERT INTO ... SELECT Christopher Browne 01:57
Re: INSERT INTO ... SELECT Jonathan Gardner 16:40
Re: optimisation of a code Jonathan Gardner 16:42
Re: How to check: is some key referenced from sometable Jonathan Gardner 16:46
How to optimize this query ? krystoffff 18:21
Re: INSERT INTO ... SELECT Vernon Smith 23:06

Aug. 13, 2003

Thread Author Time
Re: How to optimize this query ? Stephan Szabo 00:52
Re: How to optimize this query ? Franco Bruno Borghesi 01:04
Re: How to optimize this query ? Stephan Szabo 01:29
How to speeed up the query performance Abdul Wahab Dahalan 03:20
Order of triggers - totally lost SZŰCS Gábor 10:11
Re: INSERT INTO ... SELECT Christoph Haller 11:40
Insert a description while creating a table luiz 11:56
Re: Insert a description while creating a table Rod Taylor 12:06
Re: Insert a description while creating a table Benoît Bournon 12:24
Re: Insert a description while creating a table BenLaKnet 12:31
Re: Insert a description while creating a table Christoph Haller 12:54
Re: Insert a description while creating a table luiz 13:05
Re: Insert a description while creating a table Reinoud van Leeuwen 13:11
Re: How to optimize this query ? krystoffff 13:20
Re: Insert a description while creating a table Christoph Haller 13:23
Re: Error message with a SQL function krystoffff 13:25
Porting from PL/SQL to PLPGSQL Jomon Skariah 13:44
Re: Order of triggers - totally lost Christoph Haller 14:22
Re: How to speeed up the query performance Christoph Haller 14:50
Re: How to speeed up the query performance Jonathan Gardner 14:50
Re: Order of triggers - totally lost Jonathan Gardner 14:54
Re: Order of triggers - totally lost SZŰCS Gábor 15:40
Re: Order of triggers - totally lost Josh Berkus 15:55
Re: Order of triggers - totally lost SZŰCS Gábor 16:10
Re: How to optimize this query ? Franco Bruno Borghesi 16:17
Re: Order of triggers - totally lost Jonathan Gardner 16:20
Changing data type must recreate all views? Yudie 16:51
Re: How to optimize this query ? Stephan Szabo 17:10
Re: INSERT INTO ... SELECT Vernon Smith 17:14
Re: Order of triggers - totally lost Josh Berkus 17:16
Re: Order of triggers - totally lost SZŰCS Gábor 17:20
Re: How to optimize this query ? ProgHome 17:58
Why table has drop, but the foreign key still there? Raymond Chui 18:14
Re: How to optimize this query ? ProgHome 18:29
Re: How to optimize this query ? Stephan Szabo 18:29
Re: How to optimize this query ? Stephan Szabo 18:39
Re: How to optimize this query ? krystoffff 18:54
Re: Porting from PL/SQL to PLPGSQL Josh Berkus 19:35
Re: Why table has drop, but the foreign key still there? Stephan Szabo 19:38
Re: Porting from PL/SQL to PLPGSQL Rod Taylor 19:50
Re: Why table has drop, but the foreign key still there? Tom Lane 19:53
Re: Why table has drop, but the foreign key still there? Rod Taylor 19:54

Aug. 14, 2003

Thread Author Time
Re: How to speeed up the query performance Abdul Wahab Dahalan 02:51
Re: How to speeed up the query performance Stephan Szabo 03:12
Timezone troubles Jesse Scott 03:20
Re: How to speeed up the query performance Abdul Wahab Dahalan 03:22
Re: How to speeed up the query performance Abdul Wahab Dahalan 03:35
Re: Timezone troubles Josh Berkus 04:12
Re: Timezone troubles Jesse Scott 04:38
Re: Timezone troubles Jesse Scott 04:59
independent sequence for each month Tomasz Myrta 06:18
Re: Porting from PL/SQL to PLPGSQL Jomon Skariah 08:19
Re: Timezone troubles Tom Lane 11:20
Re: Timezone troubles Tom Lane 11:26
Porting from PL/SQL to PLPGSQL Jomon Skariah 13:46
Re: independent sequence for each month Bruno Wolff III 14:12
Optional join Slawek Jarosz 14:40
Re: [SQL] EXTERNAL storage and substring on long strings Jan Wieck 15:02
Re: Changing data type must recreate all views? Christoph Haller 15:18
Re: [SQL] EXTERNAL storage and substring on long strings Tom Lane 18:00
Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain 18:11
Re: How to optimize this query ? krystoffff 18:14
Re: [SQL] EXTERNAL storage and substring on long strings Jan Wieck 18:55
lower/upper functions and strings in searches Gregory S. Williamson 23:46

Aug. 15, 2003

Thread Author Time
Re: lower/upper functions and strings in searches Stephan Szabo 00:00
Re: lower/upper functions and strings in searches Josh Berkus 00:17
Re: Optional join Stephan Szabo 04:40

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 31