| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Ian Lance Taylor <ian(at)airs(dot)com> |
| 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 00:37:20 |
| Message-ID: | 9287.991269440@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Lance Taylor | 2001-05-31 00:58:40 | Re: Support for %TYPE in CREATE FUNCTION |
| Previous Message | Don Baccus | 2001-05-30 22:56:35 | Re: Support for %TYPE in CREATE FUNCTION |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Lance Taylor | 2001-05-31 00:58:40 | Re: Support for %TYPE in CREATE FUNCTION |
| Previous Message | Tom Lane | 2001-05-31 00:32:31 | Re: Patch to remove sort files, temp tables, unreferenced files |