BUG #1750: recurrentive views terminates connection - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      1750
Logged by:          Bartłomiej Rychtarski
Email address:      bartek@wsb.poznan.pl
PostgreSQL version: 7.3.4
Operating system:   red hat 9
Description:        recurrentive views terminates connection
Details:

selecting from recurrent views couses termination of all client connections
to the postgres server:

create view test1 as
select 1::integer as id;

create view test2 as
select sum(id) as id from test1;

create or replace view test1 as
select sum(id)::integer as id from test2;

select * from test2;