Search Postgresql Archives

Re: ERROR: table row type and query-specified row type do not match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux