'not a sequence' issue

[amaximus]

I'm not a database expert, therefore I'm not sure if it was caused by the conversion tool but I ended up with the following error:

gerrit> SELECT nextval('change_id') from changes;
ERROR: ERROR: "change_id" is not a sequence
gerrit> \d changes
                     Table changes
 COLUMN_NAME          | TYPE
 ---------------------+--------------------------------------------------------------------
 change_key           | varchar(60) DEFAULT ''::character varying NOT NULL
 created_on           | timestamp DEFAULT now() NOT NULL
 last_updated_on      | timestamp DEFAULT '-infinity'::timestamp without time zone NOT NULL
 owner_account_id     | int4 DEFAULT 0 NOT NULL
 dest_project_name    | varchar(255) DEFAULT ''::character varying NOT NULL
 dest_branch_name     | varchar(255) DEFAULT ''::character varying NOT NULL
 status               | bpchar(1) DEFAULT ''::bpchar NOT NULL
 current_patch_set_id | int4 DEFAULT 0 NOT NULL
 subject              | varchar(255) DEFAULT ''::character varying NOT NULL
 topic                | varchar(255)
 row_version          | int4 DEFAULT 0 NOT NULL
 change_id            | int4 DEFAULT 0 NOT NULL
 original_subject     | varchar(255)
 submission_id        | varchar(255)

Indexes on changes:
  changes_pkey UNIQUE (change_id)
gerrit>

Reindex didn't help. Data can be queried, however inserts are failing.
Do you have any hint on what could have caused this?

Thanks.

[amaximus]

Turned out that the sequences all have an extra _s_seq postfix:

gerrit> SELECT c.relname FROM pg_class c WHERE c.relkind = 'S';
 relname
 -----------------------
 account_group_id_s_seq
 account_id_s_seq
 change_id_s_seq
 change_message_id_s_seq
(4 rows; 1 ms)
gerrit>

Renaming sequence fails with below message as existing change_id is not a sequence but a relation:

gerrit> alter sequence change_id_s_seq rename to change_id;
ERROR: ERROR: relation "change_id" already exists
gerrit> select c.relname, c.relnamespace from pg_class c where c.relname='change_id';
 relname   | relnamespace
 ----------+-------------
 change_id | 2200
(1 row; 1 ms)
gerrit>