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

From: tlange(at)gwdg(dot)de
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: sorry, now with subject... trigger & nextval(seq)
Date: 2010-05-21 07:35:20
Message-ID: 4c9adb73ac8c64f2e94c62e8d5d2f4d7.squirrel@mailbox.gwdg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> On Thu, May 20, 2010 at 5:52 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".
>
> 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

In response to

  • Re: at 2010-05-21 01:56:39 from Richard Broersma

Browse pgsql-sql by date

  From Date Subject
Next Message Craig Ringer 2010-05-21 08:15:37 Re:
Previous Message tlange 2010-05-21 07:19:53 [Fwd: Re: sorry, now with subject... trigger & nextval(seq)]