"Pavel Stehule" <[EMAIL PROTECTED]> writes: > 2007/8/11, Gregory Stark <[EMAIL PROTECTED]>: >> >> "Pavel Stehule" <[EMAIL PROTECTED]> writes: >> >> > checked_by INT REFERENCES users (id) ON UPDATE CASCADE ON DELETE SET >> > NULL, >> >> > CONTEXT: SQL statement "UPDATE ONLY "public"."tasks" SET "worker" = >> > NULL WHERE $1 OPERATOR(pg_catalog.=) "worker"" >> >> This says you mistyped the constraint above to refer to tasks(worker) instead >> of users(id). Did you? >> >> -- > > Im sorry. I don't understand. It's look like wrong evaluation order: > > 1. delete from users
There's no delete from users in evidence here. Check how your constraints are actually defined, it doesn't look like they're defined they way you claimed they are -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
