Re: RES: bug? Drop column and SQL functions

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Thiago Fernandes Moesch <thiago(at)dinamize(dot)com>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: RES: bug? Drop column and SQL functions
Date: 2003-10-29 13:48:11
Message-ID: 1067435290.99917.31.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 2003-10-29 at 06:54, Thiago Fernandes Moesch wrote:
> I have a comment on something like that to: Why - when creating a view
> using explicit * on select - postgresql reads all the fields in the query
> and especify them one by one on the view definition? Developers always have
> to check every view after changing a table definition to be certain it does
> not need to be recreated.

I would have thought dependency tracking added in 7.3 would tell you
when views cannot be updated to accommodate the table change.

Functions on the other hand do not have any dependency tracking.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-10-29 14:05:48 O_DIRECT in freebsd
Previous Message Bruce Momjian 2003-10-29 13:42:59 Re: Call for port reports