Cannot update table "schema_version" because it does not have a replica identity and publishes updates

[jackwilsdon]

Running tern migrate on a server which is using PostgreSQL publications returns the following error:

ERROR: cannot update table "schema_version" because it does not have a replica identity and publishes updates (SQLSTATE 55000)

golang-migrate gets around this by making version a primary key: https://github.com/golang-migrate/migrate/blob/8b9c5f77128ef93d65a082208a2009a3911fe6d4/database/pgx/v5/pgx.go#L469

I've tested making version a primary key and it seems to work fine.

Happy to open a PR to make version a primary key if this functionality is desired.

[jackc]

Seems reasonable.

[pscheid92]

Hey all, since this had been stale for a while, I thought I'd implement it.

There are two commits:

• Adding the primary key for new version tables
• Adding the primary key for existing version tables