From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc:
"scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>,Richard Huxton <dev(at)archonet(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-06 19:04:32
Message-ID:
2609.1083870272@sss.pgh.pa.us (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
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.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: James RobinsonDate: 2004-05-06 19:06:56
Subject : Re: PostgreSQL pre-fork speedup
Previous :From : Tom LaneDate : 2004-05-06 19:02:06
Subject : Re: alter table alter columns vs. domains
pgsql-committers by date
Next :From: Bruce MomjianDate: 2004-05-06 19:23:26
Subject : pgsql-server/src/backend port/sysv_shmem.c pos ...
Previous :From : Robert TreatDate : 2004-05-06 19:02:02
Subject : Re: ALTER TABLE TODO items