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
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: 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
), 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 '; '[EMAIL PROTECTED]'
Sent: 11-27-00 3:32 AM
Subject: Re
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
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
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