Pete Leonard <[EMAIL PROTECTED]> writes: > running the command > delete from foobar where id=1; > causes the DB to hang. only way out is an immediate restart of the DB. Confirmed here ... looks like you've uncovered a bug, probably in the rule rewriter. I got as far as determining that the query's rangetable list seems to have been partly freed, and ran out of steam. Will look at it tomorrow unless someone else finds the problem sooner. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html