Re: BUG #1750: recurrentive views terminates connection

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bart omiej Rychtarski" <bartek(at)wsb(dot)poznan(dot)pl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1750: recurrentive views terminates connection
Date: 2005-07-04 14:32:24
Message-ID: 4684.1120487544@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Bartomiej Rychtarski" <bartek(at)wsb(dot)poznan(dot)pl> writes:
> PostgreSQL version: 7.3.4

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

This is fixed in 7.4 and up.

regression=# select * from test2;
ERROR: infinite recursion detected in rules for relation "test2"

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2005-07-04 19:05:57 Re: libecpg (8.0 and CVS) hits a gcc bug on powerpc
Previous Message Tom Lane 2005-07-04 14:27:10 Re: Select on pkey returned more than one row