Postgres Pro
Downloads
Home   >   mailing lists

Re: error after dropping column - Mailing list pgsql-bugs

From Tom Lane
Subject Re: error after dropping column
Date
Msg-id 21828.1263255165@sss.pgh.pa.us
Whole thread Raw
In response to Re: error after dropping column  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-bugs
Tree view 
Craig Ringer <craig@postnewspapers.com.au> writes:
> On 11/01/2010 10:27 PM, Filip Rembiałkowski wrote:
>> ERROR:  table row type and query-specified row type do not match
>> DETAIL:  Physical storage mismatch on dropped attribute at ordinal
>> position 2.

> I'm pretty certain that's not a bug.

No, it is a bug, or at least an overlooked case.  There might be some
variants of this that aren't readily fixable, but that one is/was:
http://archives.postgresql.org/pgsql-committers/2010-01/msg00168.php

            regards, tom lane

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: error after dropping column
Next
From: Robert Haas
Date:
Subject: Re: BUG #5272: PL/Python SELECT: return composite fields as dict, not str