I have a Postgresql server with a data base and table, columns dont matter. My issue is my primary key is set to BIGSERIAL, it auto-increments. However, on MS ACCESS when I create a form to insert new entrys - I am unable to do so unless I enter a digit into the bigserial ID field. It will not automatically increment.
I've tried playing with the enabled and locked settings in Access with no luck.
Found this person with same issue that seemed to never have been resolved.