Forum OpenACS Development: Re: acs_data_links error when upgrading acs-kernel

Collapse
Posted by Ryan Gallimore on
Thanks, Emmanuelle. This is now fixed on HEAD.
Collapse
Posted by Don Baccus on
Ryan - you should continue to use a UNIQUE table constraint for the three columns rather than manually generate the index. That's the standard SQL way to do it and works equivalently in Oracle and PG.

(as it happens both implement UNIQUE constraints by building the multi-column index but please, stick to standard SQL when possible).

Collapse
Posted by Ryan Gallimore on
Hi Don,

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?

Collapse
Posted by Ryan Gallimore on
Hi Don - I updated the SQL scripts on HEAD to use UNIQUE constraints.
Collapse
Posted by Emmanuelle Raffenne on
Thank you Ryan.