[Fwd: Re: sorry, now with subject... trigger & nextval(seq)] - Mailing list pgsql-sql

From tlange@gwdg.de
Subject [Fwd: Re: sorry, now with subject... trigger & nextval(seq)]
Date
Msg-id a0d0e2b5bc0c61727f9af7fa92913b3f.squirrel@mailbox.gwdg.de
Whole thread Raw
List pgsql-sql
> On Thursday 20 May 2010 5:53:51 pm tlange@gwdg.de wrote:
>> I'm new to triggers in PostgreSQL. I have to create a trigger on insert
>> to
>> increment a sequence to overcome MS-Access' limitation in acknowledging
>> serial "datatype".
>>
>
> You know serial is just a shortcut for:
>
> pid int NOT NULL DEFAULT nextval('seq')

yes. sorry datatype quoted was bit ambiguous.

> I think you will find Access will place nice if you use the long form to
> define
> your autoincrement.
>
Ok, I'll give it a try!

Thank you, Torsten




pgsql-sql by date:

Previous
From: Richard Broersma
Date:
Subject: Re:
Next
From: tlange@gwdg.de
Date:
Subject: Re: sorry, now with subject... trigger & nextval(seq)