Re: stumped on view/rule/delete problem. - Mailing list pgsql-general

From Tom Lane
Subject Re: stumped on view/rule/delete problem.
Date
Msg-id 8028.992330645@sss.pgh.pa.us
Whole thread Raw
In response to stumped on view/rule/delete problem.  (Pete Leonard <pete@hero.com>)
List pgsql-general
Pete Leonard <pete@hero.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

pgsql-general by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: What the heck is happening here?
Next
From: Tom Lane
Date:
Subject: Re: pg_dumpall anomaly