pgsql-sql since 2002-10-06 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 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Oct. 6, 2002

Thread Author Time
Re: problem with subqueries Tom Lane 01:01
Re: problem with subqueries Stephan Szabo 01:02
Get A Tree from a table Scott Yaung 05:37
Re: problem with subqueries pete 11:13
timestamp Brian Ward 14:41
Re: timestamp Brian Ward 15:38
Need some SQL help Brian Ward 15:41
Suggestion: md5/crypt functions in sql Aasmund Midttun Godal 15:57
Re: problem with subqueries Stephan Szabo 16:18
Re: Suggestion: md5/crypt functions in sql Joe Conway 16:26
Re: Suggestion: md5/crypt functions in sql Dan Langille 22:51

Oct. 7, 2002

Thread Author Time
Re: foreign key problem Josh Berkus 00:11
Re: foreign key problem Josh Berkus 00:11
Re: Large databases, performance Curt Sampson 02:27
Re: Large databases, performance Curt Sampson 02:30
cross-posts (was Re: Large databases, performance) Tom Lane 03:20
Re: Large databases, performance Shridhar Daithankar 09:37
Re: [pgsql-performance] Large databases, performance Hans-Jürgen Schönig 10:01
Re: [HACKERS] cross-posts (was Re: Large databases, Larry Rosenman 11:50
Re: [HACKERS] cross-posts (was Re: Large databases, Michael Paesold 12:01
Re: [HACKERS] cross-posts (was Re: Large databases, Larry Rosenman 12:04
Re: How slow is distinct - 2nd Michael Contzen 12:21
Re: timestamp Larry Rosenman 12:25
Re: Need some SQL help Dan Langille 12:27
Re: timestamp Dan Langille 12:35
Re: timestamp Dan Langille 12:44
Re: Large databases, performance Manfred Koizar 14:10
Re: Large databases, performance Shridhar Daithankar 14:18
Re: [pgsql-performance] Large databases, performance Tom Lane 14:30
Re: [pgsql-performance] Large databases, performance Shridhar Daithankar 14:39
Re: [pgsql-performance] Large databases, performance Tom Lane 15:21
Re: Large databases, performance Manfred Koizar 15:22
Re: enforcing with unique indexes.. Jean-Luc Lachance 15:55
Re: Get A Tree from a table Josh Berkus 16:40
Re: Get A Tree from a table Joe Conway 16:54
Problems Formulating a SELECT Charles Hauser 19:24
Debug information Rafal Kedziorski 23:01
SQL Error Rafal Kedziorski 23:53

Oct. 8, 2002

Thread Author Time
foreign key problem Laurette Cisneros 00:03
Re: foreign key problem Stephan Szabo 00:21
Probs "compiling" a function gordoncl 02:14
Re: [pgsql-performance] Large databases, performance Shridhar Daithankar 05:44
Re: [pgsql-performance] Large databases, performance Martijn van Oosterhout 07:20
Temporary tables and indexes Ludwig Lim 07:28
Re: Probs "compiling" a function Richard Huxton 08:32
Re: Problems Formulating a SELECT Richard Huxton 08:38
Re: Pinning a table into memory Jan Wieck 13:32
foreign key, on delete cascade... Mathieu Arnold 13:47
Re: [GENERAL] Large databases, performance Ron Johnson 13:50
Re: [GENERAL] Large databases, performance Tom Lane 14:38
Re: [GENERAL] Large databases, performance Shridhar Daithankar 14:41
Re: foreign key, on delete cascade... Stephan Szabo 15:00
Re: Problems Formulating a SELECT Charles Hauser 15:04
Re: [GENERAL] Large databases, performance Ron Johnson 15:16
Re: CHAR, VARCHAR, TEXT (Was Large Databases) Josh Berkus 15:33
Re: Temporary tables and indexes Josh Berkus 15:36
Re: [NOVICE] update question Josh Berkus 15:39
Re: [GENERAL] Large databases, performance Tom Lane 15:51
Re: Temporary tables and indexes Ian Harding 16:13
Re: Problems Formulating a SELECT Richard Huxton 16:44
Re: CHAR, VARCHAR, TEXT (Was Large Databases) Ron Johnson 17:42
Re: Problems Formulating a SELECT Charles Hauser 18:19
Re: CHAR, VARCHAR, TEXT (Was Large Databases) Josh Berkus 22:44
Re: CHAR, VARCHAR, TEXT (Was Large Databases) Josh Berkus 23:36

Oct. 9, 2002

Thread Author Time
Table Rule Rudi Starcevic 00:20
Re: IN, EXISTS or ANY? Keith Gray 00:51
Re: IN, EXISTS or ANY? Josh Berkus 03:53
Re: Temporary tables and indexes Tom Lane 04:45
Re: Temporary tables and indexes Josh Berkus 04:49
Re: Large databases, performance 📎 Manfred Koizar 08:00
Re: Large databases, performance Shridhar Daithankar 08:07
Re: Large databases, performance Shridhar Daithankar 08:25
Re: Problems Formulating a SELECT Richard Huxton 08:47
PLPGSQL errors Rudi Starcevic 10:06
Re: PLPGSQL errors Richard Huxton 10:20
Complex SQL query and performance strategy Adam Witney 10:32
Re: [pgsql-performance] Large databases, performance Tom Lane 13:32
Re: [pgsql-performance] Large databases, performance Shridhar Daithankar 13:41
Re: Complex SQL query and performance strategy Tom Lane 13:47
problem with the Index Jose Antonio Leo 16:56
SELECT statement never completes. John Pauley 17:10
Re: SELECT statement never completes. Stephan Szabo 17:26
Re: [SQL] problem with the Index Stephan Szabo 17:31
Re: [pgsql-performance] Large databases, performance Manfred Koizar 18:09
Re: foreign key problem Laurette Cisneros 23:16

Oct. 10, 2002

Thread Author Time
Viewing stored procedure code Ludwig Lim 07:27
Re: Viewing stored procedure code Achilleus Mantzios 09:01
Re: SQL Error Christoph Haller 09:11
Re: SQL Error Achilleus Mantzios 11:23
SELECT with INNER data bases 2000 Informática 12:37
Re: SELECT with INNER data bases Bruno Wolff III 12:41
contrib/fixchar (Was: Large databases, performance) Manfred Koizar 13:30
Re: contrib/fixchar (Was: Large databases, performance) Shridhar Daithankar 13:49
NOTICE: generated by sequence nextval() John Duffy 15:17
Re: SELECT with INNER data bases Roberto Mello 15:19
[No subject] Luis Mix 19:14
Missing Review Josh Berkus 23:03

Oct. 11, 2002

Thread Author Time
foreign key, create table, and transactions Jeffrey Green 07:06
Re: NOTICE: generated by sequence nextval() 📎 Michael Ansley (UK) 09:12
Re: NOTICE: generated by sequence nextval() Thrasher 11:19
triggers Stian Riis 13:45
triggers Stian Riis 13:48
Re: triggers Richard Huxton 14:19
Re: triggers Achilleus Mantzios 15:19

Oct. 12, 2002

Thread Author Time
DELETE command is getting blocked Bhuvan A 11:02
error...what to do? George 13:17
Re: DELETE command is getting blocked Stephan Szabo 14:57

Oct. 14, 2002

Thread Author Time
Stored procedure returning row or resultset Heiko Stoermer 14:22
Re: Stored procedure returning row or resultset Richard Huxton 15:05
Re: Stored procedure returning row or resultset Brian Blaha 15:15
Re: Stored procedure returning row or resultset Tom Lane 17:17

Oct. 15, 2002

Thread Author Time
functions that return a dataset or set of rows Brian Ward 01:21
Slow performance on MAX(primary_key) Keith Gray 05:01
SQL function triggers Brian Blaha 06:06
Re: Slow performance on MAX(primary_key) Ludwig Lim 07:16
Re: Slow performance on MAX(primary_key) Keith Gray 07:47
Re: Stored procedure returning row or resultset Richard Huxton 08:17
Re: Slow performance on MAX(primary_key) Richard Huxton 08:23
how do i insert an empty string ? Peter Galbavy 10:01
Re: how do i insert an empty string ? Peter Galbavy 10:03
Re: IGNORE ME how do i insert an empty string ? Peter Galbavy 10:09
Messy Casts, Is there a better way? Larry Rosenman 10:16
Re: foreign keys again wishy wishy 11:46
set difference Domoszlai László 12:52
Re: Stored procedure returning row or resultset Tom Lane 13:57
Re: SQL function triggers Tom Lane 14:07
Re: how do i insert an empty string ? Jeff 14:14
Re: set difference Tom Lane 14:25
Re: Messy Casts, Is there a better way? Josh Berkus 16:28
Re: Use of reference table ('look-up-table') and FK constraint Josh Berkus 17:27
Re: SQL function triggers Jan Wieck 18:46
Re: Messy Casts, Is there a better way? Peter Eisentraut 18:54
int id's helpful for indexing, or just use text names? george young 19:16
ADO with postgreSQL 2000 Informática 19:40
Re: int id's helpful for indexing, or just use text names? Tom Lane 21:06

Oct. 16, 2002

Thread Author Time
hi lz John 03:11
How to create secondary key!! Nelson Yong 06:57
help! John Geng 09:15
[No subject] John Geng 09:31
replace null with 0 in subselect ? Albrecht Berger 10:07
Locking that will delayed a SELECT Ludwig Lim 11:40
pg_atoi() error alexandre :: aldeia digital 11:57
Re: replace null with 0 in subselect ? Ian Barwick 12:16
Re: set difference Domoszlai László 13:44
Re: set difference Tom Lane 13:57
Re: replace null with 0 in subselect ? Stephan Szabo 15:03
Use of reference table ('look-up-table') and FK constraint Charles Hauser 17:14
Re: Use of reference table ('look-up-table') and FK constraint Stephan Szabo 17:26
Quick contraint question Vincent Stoessel 17:43
Help with SQL Eric L. Blevins 18:26
Re: Help with SQL Oliver Elphick 20:38
Re: Help with SQL Eric L. Blevins 21:01

Oct. 17, 2002

Thread Author Time
Re: Slow performance on MAX(primary_key) Keith Gray 00:46
Re: Slow performance on MAX(primary_key) Charles H. Woloszynski 01:09
Re: getting the current date Bruce Momjian 02:01
Re: replace null with 0 in subselect ? Tom Lane 03:10
Re: getting the current date Ludwig Lim 07:26
getting the current date Joseph Syjuco 09:11
Re: Slow performance on MAX(primary_key) Richard Huxton 09:26
Re: functions that return a dataset or set of rows Gaetano Mendola 12:58
Re: Use of reference table ('look-up-table') and FK constraint Charles Hauser 14:06
object oriented vs relational DB Charles Hauser 14:27
Can I create working trigger on view Акулов Александр 14:40
Re: Use of reference table ('look-up-table') and FK constraint Stephan Szabo 15:34
Re: object oriented vs relational DB Josh Berkus 16:03
Re: [SQL] isAutoIncrement and Postgres Josh Berkus 18:13
Re: [pgadmin-support] hi Hepworth, Mike 18:20
Re: object oriented vs relational DB Richard Huxton 18:42
Re: Messy Casts, Is there a better way? Larry Rosenman 20:22
Re: object oriented vs relational DB Marten Feldtmann 20:46
Re: functions that return a dataset or set of rows Brian 21:41
Re: Messy Casts, Is there a better way? Josh Berkus 22:50

Oct. 18, 2002

Thread Author Time
Re: Messy Casts, Is there a better way? Larry Rosenman 00:13
Can I create working trigger on view Акулов Александр 05:06
Re: Can I create working trigger on view Josh Berkus 05:27
Apparent referential integrity bug in PL/pgSQL Brian Blaha 07:15
UPDATE: Apparent referential integrity bug in PL/pgSQL Brian Blaha 07:19
Re: Locking that will delayed a SELECT Christoph Haller 07:33
Re: Locking that will delayed a SELECT Achilleus Mantzios 08:19
Re: Locking that will delayed a SELECT Achilleus Mantzios 08:32
Re: date wishy wishy 10:24
Re: Can I create working trigger on view Tom Lane 13:46
TRIGGERed INSERTS Martin Crundall 13:57
Re: Locking that will delayed a SELECT Tom Lane 13:57
Can I search for an array in csf? Vernon Wu 13:58
TRIGGERed INSERTS Martin Crundall 13:59
Re: TRIGGERed INSERTS Tom Lane 14:22
Re: Locking that will delayed a SELECT Ludwig Lim 15:02
Re: Apparent referential integrity bug in PL/pgSQL Stephan Szabo 15:05
isAutoIncrement and Postgres jm 16:18
Is there anyway to do this? Wei Weng 16:45
Re: TRIGGERed INSERTS Martin Crundall 16:59
Re: Is there anyway to do this? Ian Harding 17:10
Re: Is there anyway to do this? Bruno Wolff III 17:13
Re: error...what to do? Andrew Perrin 17:53
Re: error...what to do? Stephan Szabo 17:59
Re: functions that return a dataset or set of rows Bruce Momjian 18:01
Re: triggers Bruce Momjian 18:02
Re: Locking that will delayed a SELECT Tom Lane 18:03
Re: [SQL] foreign key, create table, and transactions Stephan Szabo 18:18

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31