Re: Duplicate primary keys/rows - Mailing list pgsql-general

From Tom Lane
Subject Re: Duplicate primary keys/rows
Date
Msg-id 6694.1128983548@sss.pgh.pa.us
Whole thread Raw
In response to Re: Duplicate primary keys/rows  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> On Mon, Oct 10, 2005 at 05:28:17PM -0400, Tom Lane wrote:
>> But people were a bit worried about what
>> might break.

> In catalog/heap.c there already is a SystemAttributeByName() to do the
> legwork. Seems to me all you'd need to do is check just as you're about
> to fail on "attribute not found".

We could certainly make it work as far as the backend is concerned.
The issue is whether there is any client code out there that will fail
if these entries are no longer present in pg_attribute.

            regards, tom lane

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Duplicate primary keys/rows
Next
From: "Jim C. Nasby"
Date:
Subject: Re: INSERT OR UPDATE?