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:
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 rows
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:
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łąd
On Thu, Feb 12, 2015 at 10:48 AM, pinker pin...@onet.eu 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:
pinker wrote
I wanted to set a rule:
pre
CREATE RULE _RETURN AS
ON SELECT * from backend.test
DO INSTEAD
SELECT * FROM backend.test WHERE who='Me';
/pre
When I'm trying to do anything on the table I get following error:
pre
ERROR: infinite recursion detected in rules for
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 20
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
=?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 feature.
=?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
11 matches
Mail list logo
