Dump of table structure is not consistent
Hi,
\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
How can I make the dump consistent ?
PostgreSQL 8.1.9 on i486-pc-linux-gnu, compiled by GCC gcc-4.0.gcc-opt
(GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5)
Poul
\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 dbI'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