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@xxxxxxxx> 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) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/