Re: Foreign Unique Constraint - Mailing list pgsql-sql

> > 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