Re: Support for %TYPE in CREATE FUNCTION

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Ian Lance Taylor <ian(at)airs(dot)com> writes:
> > It is desirable to have some reasonable mechanism for changing the
> > schema without requiring data to be dumped and reloaded. Otherwise it
> > is very difficult to upgrade a system which needs to be up 24/7, such
> > as many web sites today.
>
> > It is not acceptable for eBay to shut down their system for even just
> > a few hours for maintenance. Shouldn't it be possible for eBay to run
> > on top of Postgres?
>
> What's that got to do with the argument at hand? On-the-fly schema
> changes aren't free either; at the very least you have to lock down the
> tables involved while you change them. When the change cascades across
> multiple tables and functions (if it doesn't, this feature is hardly
> of any use!), ISTM you still end up shutting down your operation for as
> long as it takes to do the changes.

That's a lot better than a dump and restore.

I was just responding to Jan's comments about ALTER statements. Jan's
comments didn't appear to have anything to do with %TYPE, and mine
didn't either. Apologies if I misunderstood.

Ian