Re: [SQL] Uniqueness of rule, constraint, and trigger names

"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