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(at)imos(dot)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)