add functions for forcing auto increment (serial data type) on postgres

bcc-code / directus-schema-sync

The better way to sync your Directus schema and data between environments

Apache License 2.0

90 stars 4 forks source link

add functions for forcing auto increment (serial data type) on postgres #17

Closed adelinn closed 5 months ago

adelinn commented 5 months ago

This removes "nextval" functions meant to increment sequences that can be replaced with serial type. Having those "nextval" functions as default value for some fields is not supported by Directus when importing a schema. It will just fail because the PostgreSQL function is interpreted as text and the field type is set to integer. This fixes that problem.

adelinn commented 5 months ago

This is a continuation of https://github.com/bcc-code/directus-schema-sync/pull/13