solidus

Captura desde 2023-02-22 14-50-40.png

HI everyone!
Last week I've done the migration of my Solidus development database from Sqlite to Postgres.
Today I can not clone or create new products. I receive this error...

Translation from Spanish;

PG::NotNullViolation: ERROR: the null value in the &lt;&lt;id&gt;&gt; column in &lt;&lt;spree_prices&gt;&gt; relation, violates the NotNullViolation
DETAIL: The row wich fails contains (null, 104, 30.00, EUR, null, 2023-02-22 13:38:41.276947+00, 2023-02-22 13:38:41.276947+00, null).

Captura desde 2023-02-22 14-54-28.png

Captura desde 2023-02-22 14-51-25.png

There is a problem with the spree_price id. But I don't know how to fix it.
I don't understand why it is not working because I've changed nothing in the `schema.rb`or the migrate files.
I've make the db migration from Sqlite with PGloader.

Not a PG expert, but your id column is marked as `serial`, so the insert action should auto-generate an ID if none is provided (which appears to be the case in your server log!) - but it looks like that's not happening for some reason.

I would double check in PG that `spree_prices` id actually _is_ `serial`, or if that somehow got missed in the migration?

Captura desde 2023-02-22 16-42-05.png

I've changed the constraints to serial in pgAdmin.
But the first time I've created a new product, I've received and error; the ID (1) was already been used. So I've changed the start row number to 130 because a had 129 prices ID.