Re: Removing pg_migrator limitations

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Bruce Momjian <bruce@momjian.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2009-12-18T23:55:55Z
Lists: pgsql-hackers
On Fri, Dec 18, 2009 at 6:44 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
> I thought there was a suggestion that we would be able to specify the oids
> in the SQL that creates the types, along the lines of:
>
>   create type foo as enum ( ...) with oids ( ... );
>
> Is that a non-starter? I imagine it would need to require some special
> setting to be enabled to allow it.

This gets at a question that I've been wondering about.  There seems
to be something about OIDs that makes us want to not ever allow users
to specify them, or only when our back is absolutely against the wall.
 I have only the vaguest notions of what might be dangerous about
that, though.

...Robert