"Dan Langille" <dan@langille.org> writes:
> On 4 Mar 2002 at 14:24, Tom Lane wrote:
>> ... but I'm a little worried about the possibility of errors
>> in loading schemas from existing databases, where there might be
>> non-unique constraint names.
> Create a tool to generate unique constraint names during a dump.
And then all we need is a time machine, so we can make existing
instances of pg_dump contain the tool? It's not that easy ...
I am not sure that there's really a problem here, because I don't
think duplicate constraint names will be generated during plain
CREATE operations. However, an ALTER TABLE might leave you with
a problem. Hard to tell if this is critical enough to worry about.
regards, tom lane