Reserve a value in a serial type field

From: "Albert" <alberto(dot)molteni(at)libero(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Reserve a value in a serial type field
Date: 2007-01-15 18:57:17
Message-ID: 1168887437.639796.183720@v45g2000cwv.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all. I have this issue: I need to load a value for an integer field
(with auto increment) which I implemented with a serial type and to
avoid inserts with that value in this field. The task is for a
distributed program I'm creating and I wonder if there is an efficient
solution for it.

I thought about setting the current value of the sequence when loading
the needed value..is it a solution? Is there something more efficient?

Thanks very much! Any help is appreciated!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug Cole 2007-01-15 19:03:29 Re: Avoiding empty queries in tsearch
Previous Message Tom Lane 2007-01-15 18:44:42 Re: Glacially slow nested SELECT