> > 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
