Title: RE: AW: [HACKERS] timeout on lock feature
Sorry for my forgetfulness (and a search through geocrawler didn't turn up anything useful), but what was the problem with something like NOWAIT?
e.g.: SELECT * FROM a FOR UPDATE NOWAIT;
where, if the required lock could not be obtained imme
Title: RE: [HACKERS] Foreign key checks/referential integrity.
No, they shouldn't. If you want to delete only those tuples that aren't referenced in b then you must explicitly say so:
delete from a where not exists (select * from b where b.b = a.a);
The query that you tried will explicitly
Title: RE: [HACKERS] Final Call: RC1 about to go out the door ...
Redhat Linux 7.0 (glibc 2.2-12, gcc 2.96-69)
MikeA
-Original Message-
From: Peter Eisentraut
To: The Hermit Hacker
Cc: [EMAIL PROTECTED]
Sent: 20/03/01 19:11
Subject: Re: [HACKERS] Final Call: RC1 about to go out the
Title: RE: [HACKERS] beta5 ...
Would there be any value in setting up a project on sourceforge to make use of their compile farm? I know that it doesn't cover all platforms, but it would perhaps be a start to mechanical compile and regression testing.
Just a thought...
MikeA
-Ori
VERY useful to see it fixed.
Cheers...
MikeA
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: 06 February 2001 16:16
To: Michael Ansley
Cc: Jan Wieck; sqllist; [EMAIL PROTECTED]
Subject: Re: [SQL] PL/PGSQL function with parameters
Michael Ansley <[EMAIL PROTEC
gain significant performance improvement.
Michael Ansley
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received
read about in depth), we really need to be able to properly index complex data, and using GiST, we can. Besides, it's just plain useful ;-)
MikeA
-Original Message-
From: Tom Lane
To: Michael Ansley
Cc: 'Franck Martin '; 'pgsql-general '; 'pgsql-hackers &#x
Title: RE: [HACKERS] Indexing for geographic objects?
Hi,
Remember also that the GiST library has been integrated into PG, (my brother is doing some thesis workon that at the moment), and you can create new index types relatively quickly (assuming that you understand the indexing theory ;-)
Title: RE: [HACKERS] 7.0.2 -> 7.0.3 problem
You have to dump/initdb/reload if you change the block size. Simply recompiling is not going to work.
Cheers...
MikeA
-Original Message-
From: Mitch Vincent
To: [EMAIL PROTECTED]
Sent: 11-13-00 12:57 AM
Subject: [HACKERS] 7.0.2 -> 7.0
