Re: Updatable views

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgresql(dot)org, Bernd Helmle <mailings(at)oopsware(dot)de>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Updatable views
Date: 2006-08-24 15:00:45
Message-ID: 5033.1156431645@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Bernd Helmle <mailings(at)oopsware(dot)de> writes:
> While working on Alvaro's suggestions to fix the code i got the opinion
> that we need to reject any attempts to name a user defined rule
> as

> "_INSERT"
> "_NOTHING_INSERT"
> "_DELETE"
> "_NOTHING_DELETE"
> "_UPDATE"
> "_NOTHING_UPDATE"

If the code is dependent on recognizing names to know what it's doing,
then I'd say you have a fundamentally broken approach. Consider adding
a flag column to pg_rewrite to distinguish these rules, instead.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-08-24 15:08:35 Re: Autovacuum on by default?
Previous Message Bernd Helmle 2006-08-24 14:51:42 Re: Updatable views

Browse pgsql-patches by date

  From Date Subject
Next Message Jaime Casanova 2006-08-24 16:02:43 Re: Updatable views
Previous Message Bernd Helmle 2006-08-24 14:51:42 Re: Updatable views