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? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq