I've tried to install the module on latest D7 with PostgreSQL 9.3 It was unsuccessful, with error like:

WD php: PDOException: SQLSTATE[23505]: Unique violation: 7 ERROR:  could not create unique index "role_uuid_key"                                                                                                                [error]
DETAIL:  Key (uuid)=(                                    ) is duplicated.: ALTER TABLE {role} ADD CONSTRAINT "role_uuid_key" UNIQUE (uuid); Array
(
)
 in db_add_unique_key() (line 2918 of /home/milhaus/devel/pasporty_production_postgis/includes/database/database.inc).
Cannot modify header information - headers already sent by (output started at /home/milhaus/.composer/vendor/drush/drush/includes/output.inc:38) bootstrap.inc:1224                                                             [warning]
PDOException: SQLSTATE[23505]: Unique violation: 7 ERROR:  could not create unique index "role_uuid_key"
DETAIL:  Key (uuid)=(                                    ) is duplicated.: ALTER TABLE {role} ADD CONSTRAINT "role_uuid_key" UNIQUE (uuid); Array
(
)
 ve funkci db_add_unique_key() (řádek: 2918 v souboru /home/milhaus/devel/pasporty_production_postgis/includes/database/database.inc).

Am I missing anything?

Comments

minoroffense’s picture

minoroffense commented

That's odd because if you look at the install for the module it creates the fields , sets values and then adds the unique key to it.

http://cgit.drupalcode.org/uuidrole/tree/uuidrole.install#n18

Don't have a lot of experience with Postgres. A patch would be welcome