Vincent de Phily <vincent.dephily@mobile-devices.fr> writes:
> The technique kinda works (with some changes) using unique indexes however. Is
> there a functional difference between a unique index and a primary key index
> (knowing that my column is not null) ? Or is it just for documentation and ORM
> purposes ?
The only functional difference is that a foreign key declaration
referring to the table ("REFERENCES tabname") will default to the pkey
column list. If you haven't got a declared pkey then you have to spell
out the column list.
regards, tom lane