Reserve a value in a serial type field - Mailing list pgsql-general

From Albert
Subject Reserve a value in a serial type field
Date
Msg-id 1168887437.639796.183720@v45g2000cwv.googlegroups.com
Whole thread Raw
Responses Re: Reserve a value in a serial type field
Re: Reserve a value in a serial type field
List 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!


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Glacially slow nested SELECT
Next
From: "Doug Cole"
Date:
Subject: Re: Avoiding empty queries in tsearch