Non-colliding auto generated names

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Non-colliding auto generated names
Дата
Msg-id 026901c2d645$1c346b00$6500a8c0@fhp.internal
обсуждение исходный текст
Ответы Re: Non-colliding auto generated names  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Non-colliding auto generated names  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
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


Вложения

В списке pgsql-patches по дате отправления:

Предыдущее
От: Patrick Welche
Дата:
Сообщение: Re: [HACKERS] psql and readline
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: improve docs on min()/max() performance