Re: Incomprehensible behaviour of a foreign key.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Incomprehensible behaviour of a foreign key.
Date: 2003-07-20 14:31:08
Message-ID: 22394.1058711468@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)uk> writes:
> **** Attempt the delete ...
> **** ...and watch the empty table from the start cause a ref. int. failure!

Bizarre. If the database is not too huge, I would ask you to please
make a tarball backup of the whole $PGDATA directory (while the
postmaster is stopped of course) before you go any further. That way
we can get back to this state if needed for bug investigation.

With backup in hand, please try "VACUUM FULL VERBOSE site_membership"
and see what it has to say about rows in site_membership. If it shows
that any were deleted, is the problem fixed?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2003-07-20 14:56:23 Re: Incomprehensible behaviour of a foreign key.
Previous Message Nigel J. Andrews 2003-07-20 14:10:09 Re: Incomprehensible behaviour of a foreign key.