How to set a default value in PgSQL?

Question

PHP

what is the problem?
why is the default value not being set?
"it is written, etc", it is written that it is not possible to set an integer, but why?

Answer 1

It is written in English:
The existing values ​​in the ip column cannot be automatically converted to the integer type. Use USING to cast the old type to the new one.

Answer 2

ALTER TABLE the_table ALTER COLUMN col_name TYPE integer USING (col_name::integer);

Answer 3

thanks, I already tried it, the trouble is that you can’t translate from cidr to integer, I had to recreate the table, thanks for the help )