WordPress.org
Get WordPress

Plugin Directory

Changeset 429262


Ignore:
Timestamp:
08/26/2011 09:59:01 PM (15 years ago)
Author:
hawk__
Message:

Improved INDEX creation support

File:
1 edited

Legend:

Unmodified
Added
Removed

  • postgresql-for-wordpress/trunk/pg4wp/driver_pgsql_install.php

    r428351 r429262  
    164164           
    165165            // Support for INDEX creation
    166             $pattern = '/,\s+(UNIQUE |)KEY\s+([^\s]+)\s+\(([^\)]+)\)/';
     166            $pattern = '/,\s+(UNIQUE |)KEY\s+([^\s]+)\s+\(((?:[\w]+(?:\([\d]+\))?[,]?)*)\)/';
    167167            if( preg_match_all( $pattern, $sql, $matches, PREG_SET_ORDER))
    168168                foreach( $matches as $match)
    … …  
    171171                    $index = $match[2];
    172172                    $columns = $match[3];
     173                    $columns = preg_replace( '/\(\d+\)/', '', $columns);
    173174                    // Workaround for index name duplicate
    174175                    $index = $table.'_'.$index;
Note: See TracChangeset for help on using the changeset viewer.