Re: - Mailing list pgsql-sql

From Richard Broersma
Subject Re:
Date
Msg-id AANLkTin2YCjEqBfu9n_wYwrGccZ0uFTzc8ZyxfmXXGz5@mail.gmail.com
Whole thread Raw
In response to  (tlange@gwdg.de)
Responses Re: sorry, now with subject... trigger & nextval(seq)  (tlange@gwdg.de)
Re:  (Craig Ringer <craig@postnewspapers.com.au>)
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).

-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug


pgsql-sql by date:

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