Re: ALTER TABLE schema SCHEMA TO new_schema? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: ALTER TABLE schema SCHEMA TO new_schema?
Date
Msg-id 014501c2996e$dda49bc0$6500a8c0@internal
Whole thread Raw
In response to ALTER TABLE schema SCHEMA TO new_schema?  (Joe Conway <mail@joeconway.com>)
Responses Re: ALTER TABLE schema SCHEMA TO new_schema?
List pgsql-hackers
> > I was thinking more along the lines of ALTER TABLE a.b RENAME TO x.y
> >
> > I don't see anything in the SQL spec about this; anyone know what
> > precedent is in Oracle or other DBMSes?
>
> Good question. I can't find anything in the Oracle docs indicating it is
even
> possible. We should probably just go with your suggestion. Anything else
> beyond the relnamespace and pg_depend entries that need to be dealt with?

What about sequences for serial columns?  What about views or types that
depend on the table?

Chris



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ExecMakeTableFunctionResult vs. pre-evaluated functions
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: tsearch thoughts