> On Thursday 20 May 2010 5:53:51 pm tlange(at)gwdg(dot)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