Re: Problems with transactions and sequences

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with transactions and sequences
Date: 2003-08-29 03:11:57
Message-ID: 20030829031157.GB5204@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 28, 2003 at 21:10:19 +0530,
Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2003-08-29 03:20:10 Re: Replication Ideas
Previous Message Jenny - 2003-08-29 03:08:33 acquiring row and page level locks