Re: Non-colliding auto generated names

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Non-colliding auto generated names
Date: 2003-03-14 20:35:27
Message-ID: 200303142035.h2EKZR022795@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


Just for confirmation, this patch will not be applied because it would
cause too many problems in accessing the sequence names after the
renaming. If we get auto-sequence naming, we can revisit this idea.

---------------------------------------------------------------------------

Christopher Kings-Lynne wrote:
> This patch makes all forms of autogenerated unique, primary key and sequence
> names avoid collisions. (Well, as much as you can do without "locking" your
> chosen name).
>
> This addresses a long standing annoyance I experience whenever I rename a
> table to table_old and then try to create a table with the same name. It
> also addresses a concern raised at linux.conf.au.
>
> I suggest that someone inspect the patch to determine if my "overloading" of
> CreateIndexName is appropriate (for sequences, etc.)
>
> All regression tests pass. The attached SQL script will run fine under the
> patch, whereas before it would have failed miserably.
>
> Chris
>

[ Attachment, skipping... ]

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2003-03-14 20:50:21 Re: SQL99 ARRAY support proposal
Previous Message Taral 2003-03-14 20:19:46 No index maximum? (was Re: No merge sort?)

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-03-14 20:39:32 Re: fix tiny psql memory leak
Previous Message Jason Earl 2003-03-14 20:12:49 Re: SQL99 ARRAY support proposal