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

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: infinite recursion detected in rules for relation
Sent from the PostgreSQL - general mailing list archive at Nabble.com.