Postgres Pro
Downloads
Home   >   mailing lists

Get RULE condition and commands - Mailing list pgsql-general

From Vlad Arkhipov
Subject Get RULE condition and commands
Date
Msg-id 4FDADABB.1070008@dc.baikal.ru
Whole thread Raw
Responses Re: Get RULE condition and commands  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: gelin yan
Date:
Subject: Re: pg_ctl start close the cmd.exe then the server would stop.
Next
From: Alban Hertroys
Date:
Subject: Re: Submit query using dblink that hung the host