Andrew Dunstan <[EMAIL PROTECTED]> writes:
> I think there are several of them from this thread:

> . make autogenerated column constraint names unique per table (by adding 
> "_$n" ?)

Check.

> . add tableoid or tablename to information_schema.{check_constraints, 
> referential_constraints} (I think those are the only places where it 
> would be needed, from my quick skimming).
> . add tableoid or tablename to autogenerated table constraint names

These are mutually exclusive --- I see no reason to do both.

> Using tableoid instead of tablename avoids renaming problems, but makes 
> the names horribly opaque IMNSHO.

Agreed.  I think using the OIDs would be a horrible choice.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to