I came into the problem today where if a postgres table has a long name and a sequenced id, then the sequence name is truncated by postgres. However, the postgres adapter looks for the untruncated name.
For example, given a table:
Postgres generates a sequence name of:
Postgres adapter searches for sequence name:
Throwing the following error on save:
PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "sales_order_fitting_confirmation_id_sales_order_fitting_confirm" does not exist
Is there a way to force a sequence name in a model? Should this behaviour not be also built into the adapter? Thanks for the help guys