Column Data Type wont change to serial

Asked Nov 29 '15 at 12:59

Active Nov 29 '15 at 14:28

Viewed 2,739 times

I want to change a column data type from integer to a serial

ALTER TABLE "TestTable" ALTER COLUMN "ID" TYPE serial ;

but it seem can to change for anything except serial !! i got this error

ERROR: type "serial" does not exist ********** Error **********

ERROR: type "serial" does not exist SQL state: 42704

is there any way to solve the problem ? Thanks in advance

edited Nov 29 '15 at 14:28

asked Nov 29 '15 at 12:59

Hamza Benzaoui

1

serial is a pseudo data type. Check this answer. http://stackoverflow.com/questions/27307835/how-to-convert-primary-key-from-integer-to-serial – Marlon Abeykoon Nov 29 '15 at 13:03
that dint solve anything of what i am trying to do!! – Hamza Benzaoui Nov 29 '15 at 14:29
See also this question: http://stackoverflow.com/q/25972630/330315 or this: http://dba.stackexchange.com/q/78732/1822 – Nov 29 '15 at 14:35

0 Answers0