Looking for some help here - I'm working on a site that is using a PostgreSQL db and am running into an issue. When saving a large Matrix field with multiple block types I was receiving the following error:
Integrity constraint violation SQLSTATE: Not null violation: 7 ERROR: null value in column "id" violates not-null constraint
At first, I thought there was something corrupted with the Matrix so I nuked it and rebuilt it - everything seemed to be working fine until I created a new channel section - when I tried to create an entry there, I got the following error:
Integrity constraint violation SQLSTATE: Not null violation: 7 ERROR: null value in column "id" violates not-null constraint The SQL being executed was: INSERT INTO "drafts" ("sourceId", "creatorId", "name", "notes") VALUES (NULL, 5772, 'First draft', NULL)).
Similar to the above, just a new table this time.
Everything I am reading points to an auto-increment issue, though in both cases there does seem to be the appropriate sequence in the db. I've barely used PostgreSQL and never with Craft, though I'm not 100% certain it has to do with the db.
Any thoughts on what could be causing this?