PostgreSQL-For-Wordpress/postgresql-for-wordpress

Detect usage of AUTO_INCREMENT and add relevant auto incrementing type

mattbucci opened this issue 10 months ago · 2 comments

mattbucci commented 10 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 10 months ago

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

mattbucci commented 9 months ago

Closed by #76