From: | Ian Lance Taylor <ian(at)airs(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Jan Wieck <JanWieck(at)Yahoo(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Support for %TYPE in CREATE FUNCTION |
Date: | 2001-05-31 01:01:19 |
Message-ID: | si3d9muyao.fsf@daffy.airs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-05-31 03:42:16 | Imperfect solutions |
Previous Message | Ian Lance Taylor | 2001-05-31 00:58:40 | Re: Support for %TYPE in CREATE FUNCTION |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-05-31 01:29:32 | Re: Patch to remove sort files, temp tables, unreferenced files |
Previous Message | Ian Lance Taylor | 2001-05-31 00:58:40 | Re: Support for %TYPE in CREATE FUNCTION |