Re: Request for Comments: ALTER [OBJECT] SET SCHEMA - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: Request for Comments: ALTER [OBJECT] SET SCHEMA
Date
Msg-id F1440B31694F0121686AFDCD@sparkey.oopsware.intra
Whole thread Raw
In response to Request for Comments: ALTER [OBJECT] SET SCHEMA  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-hackers
--On Freitag, Juni 10, 2005 21:20:33 +0200 ziga@mail.ljudmila.org wrote:

> Wouldn't
>
> ALTER [OBJECT] RENAME TO [schema.][name]
>
> be a better?
>
> After all, this is essentially a rename operation,
> so maybe it is better to extend existing syntax...

I don't think it's a good idea to merge two different semantics: Renaming a 
table and "moving" a table to a different schema should be distinguished. 
Furthermore, i think it's too error prone, because people could accidently 
issue a "schema move" and renaming a table by a typo....

-- 
 Bernd


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: The Contrib Roundup (long)
Next
From: Neil Conway
Date:
Subject: Re: Proposed toast info extraction function for disaster