Viewupdate: Inherit default expressions from columns

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: PostgreSQL-Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Viewupdate: Inherit default expressions from columns
Date: 2005-01-19 00:21:32
Message-ID: 6002E4F76F261EC23C0552EF@sparkey.oopsware.intra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

For automatic view update rules we are planning to implement column default
value inheritance, so that the view's column definition inherits from their
base table columns (and nobody has to use an explicit ALTER TABLE view
ALTER col SET DEFAULT ... ). Note that we will do that only for views,
which are updateable (means that we can create rules for that view). I
wonder if there are any side effects, like security issues or other stuff
that will be broken by that (nothing comes currently to my mind, besides
the fact that ALTERing the base tables default expression later won't be
triggered to the view.....).

What does folks think about that, any comments?

--

Bernd

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-01-19 01:21:01 buildfarm enhancements
Previous Message Alvaro Herrera 2005-01-19 00:10:29 Re: ARC patent