| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCHES] Non-colliding auto generated names |
| Date: | 2003-03-06 01:55:03 |
| Message-ID: | 021d01c2e383b3e92000a8c0@fhp.internal |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Calco | 2003-03-06 01:58:35 | Re: XML ouput for psql |
| Previous Message | Tatsuo Ishii | 2003-03-06 01:35:16 | Re: Win32 Powerfail testing |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-03-06 02:04:58 | Re: [PATCHES] Non-colliding auto generated names |
| Previous Message | Joe Conway | 2003-03-06 01:32:04 | Re: XML ouput for psql |