Postgres Pro
Downloads
Home   >   mailing lists

Re: Uniqueness of rule, constraint, and trigger names - Mailing list pgsql-sql

From Tom Lane
Subject Re: Uniqueness of rule, constraint, and trigger names
Date
Msg-id 7683.1015274872@sss.pgh.pa.us
Whole thread Raw
In response to Re: Uniqueness of rule, constraint, and trigger names  ("Dan Langille" <dan@langille.org>)
Responses Re: Uniqueness of rule, constraint, and trigger names  ("Dan Langille" <dan@langille.org>)
List pgsql-sql
Tree view 
"Dan Langille" <dan@langille.org> writes:
> It would be easily detected at load time.  Then you direct the user to the 
> tool mentioned above.

But if the user has already dumped and flushed his old installation,
he's still in need of a time machine.

Hmm, maybe what we need is a tool that can be applied during load.
Essentially, alter incoming constraint names as needed to make them
unique.  We could have this enabled by a SET switch...
        regards, tom lane

pgsql-sql by date:

Previous
From: "Dan Langille"
Date:
Subject: Re: Uniqueness of rule, constraint, and trigger names
Next
From: "Dan Langille"
Date:
Subject: Re: Uniqueness of rule, constraint, and trigger names