Re: pg_rules definition format - Mailing list pgsql-hackers

From Kevin Field
Subject Re: pg_rules definition format
Date
Msg-id 8b4211aa-8bd0-484a-82f3-58d6922747e2@b1g2000vbc.googlegroups.com
Whole thread Raw
In response to pg_views definition format  (Kev <kevinjamesfield@gmail.com>)
List pgsql-hackers
On May 14, 2:22 pm, Kevin Field <kevinjamesfi...@gmail.com> wrote:
>
> Something I ran into though when trying to extend this logic to rules:
> for some reason rule definitions are compiled with "create rule x as "
> in front of them, unlike views, which just have everything after the
> "as".  I can keep the two parts separate and test accordingly, but it
> seems a bit inconsistent.

The fix isn't actually this clean in the end, since the 'fake' rule to
be returned will have a different 'definition' (because its name is
different) than the one we'd actually use to insert.  So either we do
some regexing or we have to back up the old rule's definition, drop
the rule, insert it, get the new definiton, compare, and then if
they're different, drop it again and put the old one back.


pgsql-hackers by date:

Previous
From: Kevin Field
Date:
Subject: Re: pg_rules definition format
Next
From: Heikki Linnakangas
Date:
Subject: Re: New trigger option of pg_standby