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 for relation
"backend.test"********** Błąd **********ERROR: infinite recursion detected
in rules for relation "backend.test"Stan SQL: 42P17
Is there any way to avoid that? Maybe there exist some other approaches that
could be useful ?



--
View this message in context: 
http://postgresql.nabble.com/infinite-recursion-detected-in-rules-for-relation-tp5837697.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Reply via email to