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:
021d01c2e383$67b3e920$6500a8c0@fhp.internal (view raw or flat )
Thread:
2003-02-17 05:26:23 from "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
2003-02-18 05:18:00 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-02-18 05:47:36 from "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
2003-02-18 06:00:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-02-18 06:10:01 from "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
2003-02-18 14:43:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-02-18 15:03:17 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2003-02-18 15:57:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-02-20 02:17:52 from "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
2003-02-21 07:23:50 from "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
2003-03-05 15:36:06 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-03-05 16:07:04 from Rod Taylor <rbt(at)rbt(dot)ca>
2003-03-05 19:37:36 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-03-05 19:47:04 from Rod Taylor <rbt(at)rbt(dot)ca>
2003-03-05 20:04:04 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-03-05 21:53:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-03-06 02:04:58 from "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
2003-03-06 02:08:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-03-06 02:30:28 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-03-06 01:55:03 from "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
2003-03-14 20:35:27 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
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
In response to
pgsql-hackers by date
Next :From: Bob CalcoDate: 2003-03-06 01:58:35Subject : Re: XML ouput for psqlPrevious :From : Tatsuo IshiiDate : 2003-03-06 01:35:16Subject : Re: Win32 Powerfail testing
pgsql-patches by date
Next :From: Christopher Kings-LynneDate: 2003-03-06 02:04:58Subject : Re: [PATCHES] Non-colliding auto generated names Previous :From : Joe ConwayDate : 2003-03-06 01:32:04Subject : Re: XML ouput for psql
