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)