Re: [GENERAL] Which record causes referential integrity violation on delete

2005-07-02 Thread Martin Boese
On Friday 01 July 2005 19:49, you wrote: > In Postgres 8 I tried commad > > DELETE FROM customer WHERE id=123 (snip) > ---(end of broadcast)--- > TIP 8: explain analyze is your friend Automatically answered?! :-) explain analyze DELETE FROM custo

Re: [GENERAL] Schema comparison tool

2005-02-20 Thread Martin Boese
There is a program called pgdiff.. but I could not really make it work and it seems to be quiet old and unmaintained: http://pgdiff.sourceforge.net/ Martin ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://w