Re: Viewupdate: Inherit default expressions from columns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bernd Helmle <mailings(at)oopsware(dot)de>
Cc: PostgreSQL-Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Viewupdate: Inherit default expressions from columns
Date: 2005-01-19 05:07:18
Message-ID: 23408.1106111238@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bernd Helmle <mailings(at)oopsware(dot)de> writes:
> 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).

Just so you un-break pg_dump afterwards.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Browne 2005-01-19 05:09:53 Re: Much Ado About COUNT(*)
Previous Message Tom Lane 2005-01-19 04:26:14 Re: ARC patent