Vincent de Phily <vincent.dephily@xxxxxxxxxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
