infinite recursion detected in rules for relation "..."

From: Sebastian Böck <sebastianboeck(at)freenet(dot)de>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: infinite recursion detected in rules for relation "..."
Date: 2004-11-20 12:58:58
Message-ID: 419F3F92.1050005@freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

i have a problem migrating my application from version
7.4 to 8.0. Everything is fine in 7.4 but with 8.0 i get
the following error:

infinite recursion detected in rules for relation "..."

I've been able to narrow the problem down to the
attached SQL.

I don't know wether its a bug or a "feature".

Can someone explain me this behaviour.

Thanks in advance

Sebastian

Attachment Content-Type Size
bug.sql text/plain 891 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-20 16:44:56 Re: infinite recursion detected in rules for relation "..."
Previous Message Baldeep Hira 2004-11-20 05:38:33 Error dropping non-existent tables