Re:

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: tlange(at)gwdg(dot)de
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re:
Date: 2010-05-21 01:56:39
Message-ID: AANLkTin2YCjEqBfu9n_wYwrGccZ0uFTzc8ZyxfmXXGz5@mail.gmail.com
Views: Whole Thread | Raw Message | 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).

--
Regards,
Richard Broersma Jr.

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

In response to

  • at 2010-05-21 00:52:23 from tlange

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message tlange 2010-05-21 07:19:53 [Fwd: Re: sorry, now with subject... trigger & nextval(seq)]
Previous Message Adrian Klaver 2010-05-21 01:46:52 Re: sorry, now with subject... trigger & nextval(seq)