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)
Список
Дерево обсуждения
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
Дата: