Home > mailing lists

Re: infinite recursion detected in rules for relation - Mailing list pgsql-general

From	David G Johnston
Subject	Re: infinite recursion detected in rules for relation
Date	February 13, 2015 18:45:24
Msg-id	CAKFQuwa8KWqwmVAVQJV+y=dAucNeL70FH7DAMjvg31fc7D+P=A@mail.gmail.com Whole thread Raw
In response to	Re: infinite recursion detected in rules for relation (pinker <pinker@onet.eu>)
List	pgsql-general

On Fri, Feb 13, 2015 at 8:24 AM, pinker [via PostgreSQL] <[hidden email]> wrote:

Ok, but in this particular case I don't see any caveats

You mean other than the infinite recursion, right?

and think that could be classic case for rule to be used.
If it is "almost never the correct solution" why rules still exists at all?

Backward compatibility, the "almost", and the fact that views use rules as an implementation mechanism.

David J.

From: pinker
Date: 13 February 2015, 18:24:09
Subject: Re: infinite recursion detected in rules for relation

From: Vick Khera
Date: 13 February 2015, 19:12:18
Subject: Re: What's a reasonable maximum number for table partitions?