Howard Cole <howardnews@xxxxxxxxxxxxx> 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
