Serial Unique question
От
Madison Kelly
Тема
Serial Unique question
Дата
Msg-id
4300AFB3.5060100@alteeve.com
Список
Дерево обсуждения
Serial Unique question Madison Kelly <linux@alteeve.com>
Re: Serial Unique question Michael Fuhr <mike@fuhr.org>
Re: Serial Unique question Madison Kelly <linux@alteeve.com>
Re: Serial Unique question Douglas McNaught <doug@mcnaught.org>
Re: Serial Unique question Madison Kelly <linux@alteeve.com>
Re: Serial Unique question Sven Willenberger <sven@dmv.com>
Re: Serial Unique question Douglas McNaught <doug@mcnaught.org>
Hi all, This might seem like an odd question but I couldn't find the answer in the docs (did I miss the obvious?). I want to use a 'serial uniue' column in a table but there is likely to be many, many inserts and deletes from this column. I was wondering, what happens when the serial value reaches '2,147,483,647'? Does it roll back over to '1' and keep going or will the database start erroring out? This isn't likely to be a problem any time soon, but over the course of a year or more it might be. I suppose one answer is to periodically drop and recreat the table (no long-term important data will be in there. Data will last usually less that 1sec before being deleted). Thanks all! Madison
В списке pgsql-general по дате отправления