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

2010-05-21 Thread tlange
> On Thu, May 20, 2010 at 5:52 PM, 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

[Fwd: Re: [SQL] sorry, now with subject... trigger & nextval(seq)]

2010-05-21 Thread tlange
> On Thursday 20 May 2010 5:53:51 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". >> > > You know serial is just a shortcut for: > > pid int NOT

[SQL]

2010-05-20 Thread tlange
Hello all, 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". Could anyone put me on right track? I was looking the whole day for references on that... Years ago I quickly found a re

[SQL] sorry, now with subject... trigger & nextval(seq)

2010-05-20 Thread tlange
Hello all, 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". Could anyone put me on right track? I was looking the whole day for references on that... Years ago I quickly found a re