From:
Richard Huxton <dev(at)archonet(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>,"scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>,Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: ALTER TABLE TODO items
Date:
2004-05-07 08:16:22
Message-ID:
409B45D6.8090507@archonet.com (view raw or flat )
Thread:
2004-05-05 04:48:48 from tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
2004-05-05 05:27:09 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2004-05-05 14:36:36 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-05-05 15:30:36 from Stephen Frost <sfrost(at)snowman(dot)net>
2004-05-05 15:38:34 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-05-05 16:52:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-05 16:53:41 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-05-05 16:38:31 from Gaetano Mendola <mendola(at)bigfoot(dot)com>
2004-05-05 17:04:31 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2004-05-05 17:47:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-05 17:51:23 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-05-05 17:59:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-05 19:45:39 from Richard Huxton <dev(at)archonet(dot)com>
2004-05-05 19:50:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-06 03:00:29 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-05-06 07:51:05 from Richard Huxton <dev(at)archonet(dot)com>
2004-05-06 15:47:13 from "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
2004-05-06 19:02:02 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2004-05-06 19:04:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-07 08:16:22 from Richard Huxton <dev(at)archonet(dot)com>
2004-05-06 01:45:03 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Lists:
pgsql-committers pgsql-hackers
Tom Lane wrote:
> Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
>
>>What about rules/views/functions and who knows what else (domains?)
>>might be dependant on the current type definition?
>
>
> Yeah, I was just thinking about that this morning. We probably ought to
> look for dependencies on the table rowtype as well as the individual
> column.
>
> But on the other side of the coin, should we actually reject the ALTER
> if we see a function that uses the rowtype as a parameter or result
> type? Without looking inside the function, we can't really tell if the
> ALTER will break the function or not.
With looking, you can't necessarily. What if I'm building a query with
EXECUTE or for that matter, what if I've written it in C?
--
Richard Huxton
Archonet Ltd
In response to
pgsql-hackers by date
Next :From: Gaetano MendolaDate: 2004-05-07 09:54:38Subject : Re: psql 7.3.4 disagrees with NATURAL CROSS JOINPrevious :From : Oleg BartunovDate : 2004-05-07 07:38:41Subject : Re: Subtle pg_dump problem...
pgsql-committers by date
Next :From: Teodor SigaevDate: 2004-05-07 11:19:06Subject : pgsql-server/contrib/tsearch2 tsearch.sql.inPrevious :From : Kris JurkaDate : 2004-05-07 05:28:23Subject : pgsql-server/src/interfaces/jdbc/org/postgresq ...
