From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc:
"Rod Taylor" <rbt(at)rbt(dot)ca>,"Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>,"Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: [PATCHES] Non-colliding auto generated names
Date:
2003-03-06 02:08:59
Message-ID:
3096.1046916539@sss.pgh.pa.us (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
"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:
>> I think we should stick with the existing naming convention.
^^^^^^^^^^^^^^^^^^^^^^^^^^
> Non-colliding?
No; see above.
> Otherwise, it'd be ludicrous to fail a table rename because
> a sequence with the new name already exists...
Why? We already rename the table's rowtype, ergo you can fail a table
rename because there is a conflicting datatype name. I don't see
anything much wrong with failing a table or column rename because there
is a conflicting sequence name. The whole point here is to have a
non-surprising mapping between the names of serial columns and the names
of their associated sequences.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: cbbrowneDate: 2003-03-06 02:10:33Subject : Re: XML ouput for psql Previous :From : Christopher Kings-LynneDate : 2003-03-06 02:04:58Subject : Re: [PATCHES] Non-colliding auto generated names
pgsql-patches by date
Next :From: cbbrowneDate: 2003-03-06 02:10:33Subject : Re: XML ouput for psql Previous :From : Christopher Kings-LynneDate : 2003-03-06 02:04:58Subject : Re: [PATCHES] Non-colliding auto generated names
