BUG #1750: recurrentive views terminates connection

From: "Bartomiej Rychtarski" <bartek(at)wsb(dot)poznan(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1750: recurrentive views terminates connection
Date: 2005-07-04 09:17:08
Message-ID: 20050704091708.D7354F0B06@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1750
Logged by: Bartomiej Rychtarski
Email address: bartek(at)wsb(dot)poznan(dot)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;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jozsef Aron 2005-07-04 10:11:52 Field add error
Previous Message Jean-Max Reymond 2005-07-04 06:14:39 Re: BUG #1739: memory leak in pl/perl with spi_exec_query