> On Thursday 20 May 2010 5:53:51 pm tla...@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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
