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