You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Postgres will throw an error if an update tries to change a generated always identity column, pg-mem will not throw. Tests will pass in dev but code will fail once deployed.
To Reproduce
createtabletest (id integer generated always as identity, value text);
insert into test (value) values ('test');
update test set id=1where id=1;
ERROR: column "id" can only be updated to DEFAULT
DETAIL: Column "id" is an identity column defined as GENERATED ALWAYS.
pg-mem version
version 3.0.4
The text was updated successfully, but these errors were encountered:
Describe the bug
Postgres will throw an error if an update tries to change a generated always identity column, pg-mem will not throw. Tests will pass in dev but code will fail once deployed.
To Reproduce
pg-mem version
version 3.0.4
The text was updated successfully, but these errors were encountered: