Re: Recursive reference of view in view defination crashes

On Fri, 27 Jun 2003, Rajesh Kumar Mallah wrote:

> My mistake i faced this problem below.
> is it taken care in 7.4dev ?

In 7.4 I get
"ERROR: Infinite recursion detected in rules for relation t_b"

> tradein_clients=# CREATE VIEW t_b AS SELECT * from t_a;
> CREATE VIEW
> tradein_clients=# CREATE or replace view t_b AS select * from t_b;
> CREATE VIEW