0

I was trying to update the enum label using the following SQL query

UPDATE pg_enum SET enumlabel = 'Cash Recivied' WHERE enumtypid = '1203702' AND enumlabel = 'Cash';

but it throws an error

ERROR:  cannot update table "pg_enum" because it does not have a replica identity and publishes updates

HINT:  To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.

So, I have tried to alter the table using query

ALTER TABLE pg_enum REPLICA IDENTITY FULL;

but got an error

ERROR:  permission denied: "pg_enum" is a system catalog
SQL state: 42501

Is there any solution for this ?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.