On 7/21/20 11:17 AM, Adrian Klaver wrote:
On 7/21/20 8:30 AM, Mohamed Wael Khobalatte wrote:
Hi all,
> test_(aklaver)5432> alter table change_seq alter COLUMN id set data type
bigint;
ALTER TABLE
test_(aklaver)5432> \d change_seq
Table "public.change_seq"
Column | Type | Collation | Nullable | Default
--------+--------+-----------+----------+----------------------------------------
id | bigint | | not null |
nextval('change_seq_id_seq'::regclass)
Indexes:
"change_seq_pkey" PRIMARY KEY, btree (id)
Forgot sequences are bigint by default. It would not hurt to check
pg_sequence just to make sure they are that. In that case the below is
not needed.
test_(aklaver)5432> alter sequence change_seq_id_seq as bigint;
ALTER SEQUENCE
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
