Hi, Is there a way to change a data type from serial to int? I tried with : ALTER TABLE "admin".db_jobs ALTER COLUMN id TYPE int USING id::int; But this seems not to change anything, as if Posgres woud consider the statement as a no-op.
My problem is that "serial" is not exported with pg_dump. Creating a db from the dump will hence result into a different table definition (which is equivalent tough) We are trying a transfer/migration tool on Azure, that check the table definitions between the source and target before starting the data transfer, and it blocks on that difference. best regards, Marc Mamin
