problem while adding a column

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: problem while adding a column
Date: 2006-04-20 03:43:00
Message-ID: bf54be870604192043u34b64b0bo2fbdb50c9cf4f389@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-04-20 03:45:28 Re: locating a primary key
Previous Message Klint Gore 2006-04-20 03:38:06 Re: primary keys