Re: [PATCHES] Non-colliding auto generated names - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: [PATCHES] Non-colliding auto generated names
Date
Msg-id 021d01c2e383$67b3e920$6500a8c0@fhp.internal
Whole thread Raw
In response to Re: [PATCHES] Non-colliding auto generated names  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> Ewe.  There would no longer be a guaranteed name for the serial column
> sequence.  Of course, pg_depend has the information, but how do you get
> at that when you create the dump file, and be _sure_ you are going to
> hit the right name, especially if you restore only part of the dump.
>
> Seems this kills the idea of this patch.  With 64-byte names, let's see
> if we still get complaints about name conflicts.

It does, but if Rod's domain / ALTER SEQUENCE idea goes ahead, this patch
becomes useful again.

We will still get complains because the problem occurs when you _rename_ a
table and then re-create it.

Chris



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Win32 Powerfail testing
Next
From: "Bob Calco"
Date:
Subject: Re: XML ouput for psql