> \d my.table is showing me the primary key as:
> "unitstat_pkey" PRIMARY KEY, btree (id)
>
> But the looking into the table structure produced by
> pg_dump -s -n my -t table db
>
> I'm getting gthe primary key shown as:
> ADD CONSTRAINT unistat_pkey PRIMARY KEY (id);
>
> That has been the name of it, but I altered it executing:
> ALTER TABLE unistat_pkey RENAME TO unitstat_pkey
>
Solved it with this statement
update pg_catalog.pg_constraint set conname = 'unitstat_pkey' where
conname = 'unistat_pkey'
Poul
