> On Thu, May 20, 2010 at 5:52 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". > > 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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql