infinite recursion detected in rules for relation

Поиск
Список
Период
Сортировка
От pinker
Тема infinite recursion detected in rules for relation
Дата
Msg-id 1423759716580-5837697.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: infinite recursion detected in rules for relation
Re: infinite recursion detected in rules for relation
Список 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.

В списке pgsql-general по дате отправления: