Re: ALTER TABLE TODO items - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ALTER TABLE TODO items
Date
Msg-id 2609.1083870272@sss.pgh.pa.us
Whole thread Raw
In response to Re: ALTER TABLE TODO items  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: ALTER TABLE TODO items  (Richard Huxton <dev@archonet.com>)
List pgsql-hackers
Robert Treat <xzilla@users.sourceforge.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: alter table alter columns vs. domains
Next
From: James Robinson
Date:
Subject: Re: PostgreSQL pre-fork speedup