Impact of loss of unique SERIAL?

Поиск
Список
Период
Сортировка
Искать
От
Justin Long
Тема
Impact of loss of unique SERIAL?
Дата
Msg-id
HOEMINGMOAAKJBIFKNJMOENNKFAA.justinlong@strategicnetwork.org
Ответ на
Список
Дерево обсуждения
knowing last modification / last access times of tables.. Rajesh Kumar Mallah <mallah@trade-india.com>
Impact of loss of unique SERIAL? "Justin Long" <justinlong@strategicnetwork.org>
Re: Impact of loss of unique SERIAL? Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Impact of loss of unique SERIAL? Andrew Sullivan <andrew@libertyrms.info>
Re: Impact of loss of unique SERIAL? Hacksaw <hacksaw@hacksaw.org>
Re: Impact of loss of unique SERIAL? Andrew Sullivan <andrew@libertyrms.info>
Re: Impact of loss of unique SERIAL? Tom Lane <tgl@sss.pgh.pa.us>
I am new to these lists and this message may be off-topic for this list. If
so, please advise and I will repost to one of the others. Here is the
question:

We have been running Postgres 7.2.x for our website, and are considering the
upgrade to 7.3.x. However, in reading through the changelogs I notice that
SERIAL values are no longer unique. Now, I'm no SQL guru, but I'm wondering
what happens if two INSERTs are done at the "same" time (we have multiple
web hosts that access one large database server). Would they result in two
identical values on the SERIAL? We haven't gotten a stupendous amount of
traffic, so I don't know what the odds of this are, but I'm wondering why it
was removed.

I really wanted the "DROP COLUMN" command which is available in 7.3.x, but
it seems I'm going to have to remember some really arcane code to add the
UNIQUE to the sequences. I'm wondering how much reworking of my code I'm
going to have to do to upgrade, and whether I should postpone this.
Evaluating the impact of the SERIAL change would be helpful to me, if anyone
could post a response.

Thanks,
Justin Long
www.strategicnetwork.org

В списке pgsql-admin по дате отправления
От: Rajesh Kumar Mallah
Дата:
От: Andrew Sullivan
Дата:
FAQ