I want to change some data in a table with _id_seq suffix with this sql query:
UPDATE user_custom_fields_id_seq SET last_value = 1000;
but I get the following error:
ERROR: cannot change sequence "user_custom_fields_id_seq"
Is there anyway to bypass this error by using just SQL?