PostgreSQL-For-Wordpress/postgresql-for-wordpress

Make int size replacements more robust.

Closed this issue · 0 comments

In Alter and Create Table rewriters there are lines like the following

        ' bigint(40)'   => ' bigint',
        ' bigint(20)'	=> ' bigint',
        ' bigint(10)'	=> ' int',
        ' int(11)'		=> ' int',
        ' int(10)'      => ' int',

Instead these should be aliased 1 by one and the numeric should be arbitrary, so bigint(x) becomes bigint
The full list of numeric types can be found here: https://www.postgresql.org/docs/current/datatype-numeric.html