i'm not sure where to file this bug.

one of my colleagues makes a custom table with some indexes :

'indexes' => array(
'bcs_map_elements_id' => array('mid'),
'bcs_map_elements_pid' => array('pid'),
),

no problem on mysql, but on postgres we get following exception:
PDOException: SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "simpletest71582bibdk_custom_search_map_elements_bcs_map_element" already exists: CREATE INDEX "simpletest71582bibdk_custom_search_map_elements_bcs_map_elements_pid_idx" ON {bibdk_custom_search_map_elements} ("pid");

apparently either drupal or PDO prepends and appends the name of the relation - then truncates the name again. The result is two relations with the same name .. and a database exception.

if it is PDO or drupal i don't know, but my guess is drupal.

we are running postgres psql (PostgreSQL) 9.1.6 and drupal 7.x

Comments

omegamonk’s picture

omegamonk commented
Status: Active » Closed (works as designed)

Marking as closed, since this isn't an issue with this module. I did a quick search and found this in the Drupal core issue queue. It looks like it may be the same issue.