Re: create view

I wrote:
> Ryan VanderBijl <rvbijl-pgsql(at)vanderbijlfamily(dot)com> writes:
>> I've found a way to crash PostgreSQL, using a self-refering view:

> AFAICS the only real defense is to add a run-time check for recursion
> in ApplyRetrieveRule. Annoying; anyone see a better answer?

This turned out to be less painful/expensive than I thought, so there's
now a runtime recursion check in CVS tip:

regression=# SELECT * FROM phy_node_name WHERE node_id = 6;
ERROR: Infinite recursion detected in rules for relation phy_node_name

I don't feel a need to back-patch this into 7.3.*, though; the problem
seems to me to not be worth taking a risk of breaking things.

regards, tom lane