[Fwd: Re: sorry, now with subject... trigger & nextval(seq)]

> 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