> > create table table1 (
> > id SERIAL PRIMARY KEY
> > extension UNIQUE,
>
> I can't find anything about this syntax in the docs...
Oops, i'm missing a comma on that first line, should have been:
create table table1 (
id SERIAL PRIMARY KEY,
extension UNIQUE,
)
> I think, you should write a TRIGGER for this.
Ok, i'll look into how that works. Anyone have any other input?
Thanks,
Jon