On 06/16/2012 02:20 AM, Tom Lane wrote:
Vlad Arkhipov writes:
What is the proper way of getting RULE condition and commands?
pg_get_ruledef()
regards, tom lane
It prints the whole CREATE RULE command. Is there any way to extract
WHERE condition of the rule?
--
Sent
Vlad Arkhipov writes:
> What is the proper way of getting RULE condition and commands?
pg_get_ruledef()
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
What is the proper way of getting RULE condition and commands? The query
below does not work.
select pg_get_expr(ev_qual, ev_class, true) as condition,
pg_get_expr(ev_action, ev_class, true) as commands
from pg_rewrite;
ERROR: bogus varno: 2
** Error **
ERROR: bogus va
