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

From: Patryk Kordylewski <pk(at)imos(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: table row type and query-specified row type do not match
Date: 2007-08-30 07:00:08
Message-ID: fb5ptj$2sv0$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Tom,

we are running PostgreSQL 8.2.4.

Tom Lane wrote:
> Patryk Kordylewski <pk(at)imos(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-08-30 07:14:26 Re: \copy only select rows
Previous Message Ow Mun Heng 2007-08-30 06:59:06 \copy only select rows