edited title

Link

edited Dec 30, 2019 at 9:52

Nick Barnes

PostgreSQL column type conversion formfrom bigint to bigserial

grammer

Source Link

edited Apr 17, 2018 at 8:04

Eduard Wirch

When I am tryingtry to change the data type of a column in a table by alter command...

alter table temp alter column id type bigserial;

I am gettingget

ERROR:  type "bigserial" does not exist

how is it possible for me toHow can I change the datatype from bigint to bigserial?

When I am trying to change the data type of column in a table by alter command...

alter table temp alter column id type bigserial;

I am getting

ERROR:  type "bigserial" does not exist

how is it possible for me to change the datatype from bigint to bigserial

When I try to change the data type of a column in a table by alter command...

alter table temp alter column id type bigserial;

I get

ERROR:  type "bigserial" does not exist

How can I change the datatype from bigint to bigserial?

added 6 characters in body

Source Link

edited Aug 12, 2015 at 13:45

Craig Ringer

When iI am trying to change the data type of column in a table by alter command...

alter table temp alter column id type bigserial;

alter table temp alter column id type bigserial;

iamI am getting

ERROR: type "bigserial" does not exist

ERROR:  type "bigserial" does not exist

how is it possible for me to change the datatype from bigint to bigserial

When i am trying to change the data type of column in a table by alter command...

alter table temp alter column id type bigserial;

iam getting

ERROR: type "bigserial" does not exist

how is it possible for me to change the datatype from bigint to bigserial

When I am trying to change the data type of column in a table by alter command...

alter table temp alter column id type bigserial;

I am getting

ERROR:  type "bigserial" does not exist

how is it possible for me to change the datatype from bigint to bigserial

Source Link

asked Aug 12, 2015 at 12:39

k s l kumar

Loading

Return to Question