Re: Problems with transactions and sequences - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Problems with transactions and sequences
Date
Msg-id 20030829031157.GB5204@wolff.to
Whole thread Raw
In response to Re: Problems with transactions and sequences  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
On Thu, Aug 28, 2003 at 21:10:19 +0530,
  Shridhar Daithankar <shridhar_daithankar@persistent.co.in> wrote:
>
> Actually I have no idea if you can insert specific value in a serial field. I
> wouldn't be surprised if it works as intended but don't have a postgresql
> installation handy here. (Working in windows right now..)

Yes you can. Serial types are implemented using a default that gets a value
from a corresponding sequence. If you specify a value while inserting the
default won't get used.

pgsql-general by date:

Previous
From: expect
Date:
Subject: Re: How does it work
Next
From: "Jenny -"
Date:
Subject: acquiring row and page level locks