On Fri, Feb 13, 2015 at 8:24 AM, pinker [via PostgreSQL] <
ml-node+s1045698n583786...@n5.nabble.com> 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
Ok, but in this particular case I don't see any caveats 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?
--
View this message in context:
http://postgresql.nabble.com/infinite-recursion-detected-in-rules-for-re
User created rules are almost never the correct solution. There are too
many cavets and views can accomplish nearly everything that a user might
want.
David J.
On Friday, February 13, 2015, pinker [via PostgreSQL] <
ml-node+s1045698n583782...@n5.nabble.com> wrote:
> hmm I wanted to show only ro
hmm I wanted to show only rows that was inserted today, so instead of
who='me' wanted to filter for instance where timestamp_column=CURRENT_DATE.
Yes, a view would be a solution but I thouhgt that's the case rules were
made for? Isn't it?
--
View this message in context:
http://postgresql.nabb
pinker wrote
> I wanted to set a rule:
>
> CREATE RULE "_RETURN" AS
> ON SELECT * from backend.test
> DO INSTEAD
> SELECT * FROM backend.test WHERE who='Me';
>
> When I'm trying to do anything on the table I get following error:
>
> ERROR: infinite recursion detected in rules fo
On Thu, Feb 12, 2015 at 10:48 AM, pinker wrote:
> I wanted to set a rule:
>
> CREATE RULE "_RETURN" AS
> ON SELECT * from backend.test
> DO INSTEAD
> SELECT * FROM backend.test WHERE who='Me';
>
> When I'm trying to do anything on the table I get following error:
>
> ERROR: infin
I wanted to set a rule:
CREATE RULE "_RETURN" ASON SELECT * from backend.testDO INSTEAD
SELECT * FROM backend.test WHERE who='Me';
When I'm trying to do anything on the table I get following error:
ERROR: infinite recursion detected in rules for relation
"backend.test"** Błą
Tom Lane wrote:
=?ISO-8859-1?Q?Sebastian_B=F6ck?= <[EMAIL PROTECTED]> writes:
infinite recursion detected in rules for relation "..."
If you need a patch immediately, here it is.
*** src/backend/rewrite/rewriteHandler.c.orig Sat Nov 6 12:46:35 2004
--- src/backend/rewrite/rewriteHandler.c Sat Nov
=?ISO-8859-1?Q?Sebastian_B=F6ck?= <[EMAIL PROTECTED]> writes:
> infinite recursion detected in rules for relation "..."
If you need a patch immediately, here it is.
*** src/backend/rewrite/rewriteHandler.c.orig Sat Nov 6 12:46:35 2004
--- src/backend/rewrite/rewriteHandler.cSat Nov 20
=?ISO-8859-1?Q?Sebastian_B=F6ck?= <[EMAIL PROTECTED]> writes:
> 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 don't know wether its a bug or a "f
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 "
11 matches
Mail list logo
