Get RULE condition and commands

From: Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Get RULE condition and commands
Date: 2012-06-15 06:48:27
Message-ID: 4FDADABB.1070008@dc.baikal.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 varno: 2
SQL state: XX000

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2012-06-15 07:01:48 Re: Submit query using dblink that hung the host
Previous Message gelin yan 2012-06-15 05:22:40 Re: pg_ctl start close the cmd.exe then the server would stop.