search

PostgreSQL-For-Wordpress / postgresql-for-wordpress

A maintained fork of https://wordpress.org/plugins/postgresql-for-wordpress/
GNU General Public License v2.0
209 stars 68 forks source link

Detect usage of AUTO_INCREMENT and add relevant auto incrementing type #75

Closed mattbucci closed 6 months ago

mattbucci commented 8 months ago

bigint UNSIGNED AUTO_INCREMENT should probably be bigserial https://www.postgresql.org/docs/current/datatype-numeric.html

Today we simply remove the unsigned part and add a sequence

mattbucci commented 8 months ago

See: https://github.com/PostgreSQL-For-Wordpress/postgresql-for-wordpress/blob/v3/pg4wp/rewriters/CreateTableSQLRewriter.php

mattbucci commented 6 months ago

Closed by https://github.com/PostgreSQL-For-Wordpress/postgresql-for-wordpress/pull/76