Forum OpenACS Development: Re: acs_data_links error when upgrading acs-kernel
(as it happens both implement UNIQUE constraints by building the multi-column index but please, stick to standard SQL when possible).
I realize that a unique constraint is the standard, however this Oracle post seems to prove that a unique index is not always created when a unique constraint is created. It recommends creating a unique index explicitly.
If that was the correct method for Oracle, I wanted to be consistent in PG and use a unique index as well.
With the Oracle quirk in mind, how should I change my script?