All "KEY" mysql's constraint are translated into "PRIMARY KEY" postgresql's constraint.

but
... KEY is normally a synonym for INDEX. The key attribute PRIMARY KEY can also be specified as just KEY when given in a column definition.
This was implemented for compatibility with other database systems.....
[mySQL reference manual]

This, sometime, cause a "duplicate key violates unique constrain" error.

I suggest to translate "KEY" into "CREATE INDEX" statement inside acl.install file.

Comments

salvis’s picture

salvis
he/his
commented
Status: Active » Postponed (maintainer needs more info)

How can it "sometimes" cause an error?

Does it work or does it not? I'd prefer to only fix it if it's broken...

Please provide a patch, so we know what we're talking about.

salvis’s picture

salvis
he/his
commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Please reopen if you can add something...