Re: [GENERAL] Delete all records NOT referenced by Foreign Keys

2003-12-14 Thread D. Dante Lorenso
Martijn van Oosterhout wrote: On Sat, Dec 13, 2003 at 09:48:16PM -0600, D. Dante Lorenso wrote: This is something very ugly indeed and is what I'll have to resort to unless I can find something cleaner. Ideally, I would be able to run this cleanup on a subset of the table data after an insert

Re: [GENERAL] make error Mac OS X (ar: illegal option -- s)

2003-12-14 Thread Mike Coleman
> I also have 7.4 running on 10.3 and didn't have any trouble installing it. Same here. I built and installed REL7_4_STABLE from CVS without any problem on 10.3. Maybe the problem starts with a later release? -mc -- Mike Coleman <[EMAIL PROTECTED]> Five Bats Incorporated, Portland Oregon -

Re: [GENERAL] Delete all records NOT referenced by Foreign Keys

2003-12-14 Thread Stephan Szabo
On Sun, 14 Dec 2003, D. Dante Lorenso wrote: > PG already can block a delete when it knows that foreign key exists, so > why can't I perform a query that says... > > DELETE FROM tablename > WHERE FOREIGN_KEY_EXISTS(oid) IS FALSE; That's fairly different from the checks that are performed