Re: Query Help

Howard Cole <howardnews(at)selestial(dot)com> writes:
> If I try the following query:
> delete from operator where operator_id=283;
> I get the following error message:

> ERROR: could not open relation with OID 438427
> SQL state: XX000
> Context: SQL statement "UPDATE ONLY "public"."timesheet_booking" SET
> "operator_id" = NULL WHERE "operator_id" = $1"

It looks like you have a stale plan for that ON DELETE SET NULL
constraint. Was there perhaps an index on operator_id that you removed?
Postgres is not very good about flushing cached plans when you change
table schemas (something I hope will be fixed in 8.3).

If that is the problem, starting a fresh session would be enough to take
care of it.

regards, tom lane