Re: ERROR: table row type and query-specified row type do not match

Patryk Kordylewski wrote:
> Hi Tom,
>
> we are running PostgreSQL 8.2.4.

Maybe this has something to do with dropped columns?

Patryk: please run

select * from pg_attribute where attrelid = 'foo'::regclass and attisdropped;

Replacing 'foo' with the names of all the tables and views involved in
the query.  If any show up, let us know.


> Tom Lane wrote:
>> Patryk Kordylewski <pk@imos.net> writes:
>>> can someone help/explain me why i get this error when i try to make an
>>> update on that view? It seems that something is wrong with the subselect.
>>> http://fooby.imosnet.de/error.txt
>> AFAICT, this works for me, so either you left something important out of
>> your example or you're looking at an already-fixed bug.  What PG version
>> is that?


--
Alvaro Herrera                               http://www.PlanetPostgreSQL.org/
"Just treat us the way you want to be treated + some extra allowance
 for ignorance."                                    (Michael Brusser)