Re: [SQL]

2010-05-20 Thread Richard Broersma
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 in recent ver

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

2010-05-20 Thread Adrian Klaver
On Thursday 20 May 2010 5:53:51 pm tla...@gwdg.de wrote: > 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 t

[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