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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers