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

From tlange@gwdg.de
Subject Re: sorry, now with subject... trigger & nextval(seq)
Date
Msg-id 4c9adb73ac8c64f2e94c62e8d5d2f4d7.squirrel@mailbox.gwdg.de
Whole thread Raw
In response to Re:  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-sql
> On Thu, May 20, 2010 at 5:52 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".
>
> Uh?  Access doesn't need to acknowledge the serial datatype.
> At-least in recent versions auto increment is recognized by MS-Access
> just fine (I'm guessing this is due to the Return clause which the
> ODBC driver automatically calls).
>
Thanks Richard. Ok, I hope our Access version is not too old (97 or 2000 I
think) because I could not insert. I'll try the most recent ODBC driver
and follow also Adrians suggestion.

Torsten



pgsql-sql by date:

Previous
From: tlange@gwdg.de
Date:
Subject: [Fwd: Re: sorry, now with subject... trigger & nextval(seq)]
Next
From: Craig Ringer
Date:
Subject: Re: