Dump of table structure is not consistent

From: Poul Møller Hansen <freebsd(at)pbnet(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Dump of table structure is not consistent
Date: 2007-10-01 13:51:04
Message-ID: 4700FB48.8070301@pbnet.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin Marques 2007-10-01 14:00:45 sha1 function
Previous Message Scott Ribe 2007-10-01 13:41:40 Re: Inheritance fixing timeline? (Was "Inherited FK Indexing")