Postgres Pro
Downloads
Home   >   mailing lists

problem while adding a column - Mailing list pgsql-general

From Shoaib Mir
Subject problem while adding a column
Date
Msg-id bf54be870604192043u34b64b0bo2fbdb50c9cf4f389@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
When ever trying to add a new column to the table get the following error

ERROR:  duplicate key violates unique constraint
"pg_attribute_relid_attnum_index"

While the new column that is added is not there in the table before.

Doing a select * from table from the same tables also giving an error saying:

ERROR:  cache lookup failed for type 0

Any idea what could be going wrong here??

/Shoaib

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: locating a primary key
Next
From: "Joshua D. Drake"
Date:
Subject: Re: locating a primary key