Changing a sequence datatype from INT to BIGINT PostgreSQL

Question

Hi I have PostgreSQL database with some values. When I created the tables, I didn’t pay much attention to their ID column. Now if I check the sequences, I see that the max value of some of them is of type int. How to change them to bigint without changing the IDs of the data. I changed the ID fields type in the tables from int to bigint. then ALTER SEQUENCE public.kvitansiya_id_seq MAXVALUE 9223372036854775807; command returns an error such as

SQL Error [22023]: ERROR: MAXVALUE (9223372036854775807) out of sequence data type (integer).

Here is photo of sequences tables on DBeaver.

Try this ALTER SEQUENCE public.kvitansiya_id_seq as bigint MAXVALUE 9223372036854775807 — Akhilesh Mishra
– Akhilesh Mishra, Commented Nov 21, 2020 at 5:42

Hayrulla Melibayev · Accepted Answer · 2020-11-21 06:17:52Z

16

Thank you @akhilesh-mishra. The solution

ALTER SEQUENCE public.kvitansiya_id_seq as bigint MAXVALUE 9223372036854775807;

was wonderfull.

answered Nov 21, 2020 at 6:17

Hayrulla Melibayev

5622 gold badges6 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Adrian Klaver Over a year ago

FYI, the docs spell this out ALTER SEQUENCE under 'data_type'.

Hayrulla Melibayev Over a year ago

Dear Adrian @adrian-klaver, you are right 100 percently. I didn’t notice or understand this in the documentation.

Pavan Varyani Over a year ago

Do you really need the max value in your command, I tried ALTER SEQUENCE seq_name as bigint and it set the max value automatically to what you mentioned

Collectives™ on Stack Overflow

Changing a sequence datatype from INT to BIGINT PostgreSQL

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related