Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: table row type and query-specified row type do not match - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: table row type and query-specified row type do not match
Date
Msg-id 14068.1188433551@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: table row type and query-specified row type do not match  (Patryk Kordylewski <pk@imos.net>)
Responses Re: ERROR: table row type and query-specified row type do not match  (Patryk Kordylewski <pk@imos.net>)
List pgsql-general
Tree view 
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?

            regards, tom lane

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: counting columns
Next
From: "Stuart Cooper"
Date:
Subject: Re: PostgreSQL Conference Fall 2007