Pete Leonard <pete(at)hero(dot)com> 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