I'm having an issue with backing up and restoring databases with pgAdmin 3 (1.10.0). The problem is with how pgAdmin is converting every "serial" type column to it's "int" equivalent.

For example the following table:

Code:
CREATE TABLE users_ranks
(
  id serial NOT NULL,
  rank character varying(10) NOT NULL,
  CONSTRAINT users_ranks_pkey PRIMARY KEY (id)
)
Is converted to this after the dumb/restore:

Code:
CREATE TABLE users_ranks
(
  id integer NOT NULL DEFAULT nextval(('public.users_ranks_id_seq'::text)::regclass),
  rank character varying(10) NOT NULL,
  CONSTRAINT users_ranks_pkey PRIMARY KEY (id)
)
In the past I've been backing up the databases as SQL files, editing the backup SQL to blow away the the DEFAULT crap and change the columns back to their orignal "serial" type. This is, of course, a giant pain in my ***.

Is there something I'm doing wrong or is this a bug?