Skip site navigation (1) Skip section navigation (2)

Re: BUG #3243: foreign key constraint not working?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "" <dueyduey(at)freemail(dot)hu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3243: foreign key constraint not working?
Date: 2007-04-20 05:06:48
Message-ID: 16969.1177045608@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"" <dueyduey(at)freemail(dot)hu> writes:
> I am experiencing a very interesting, actually very frightening thing: I
> have a foreign key constraint along with rows violating it.

You have not provided enough information to let anyone reproduce or
debug the problem...

FWIW, we recently found a problem in VACUUM FULL that could result in
symptoms a bit similar to this --- do you routinely do VACUUM FULL while
the database is active?

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Marcin WaldowskiDate: 2007-04-20 07:20:05
Subject: Re: BUG #3242: FATAL: could not unlock semaphore: error code 298
Previous:From: Tom LaneDate: 2007-04-20 04:58:57
Subject: Re: BUG #3240: Unexpected evaluation sequence

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group