Re: Re: 42804: structure of query does not match error where using RETURN QUERY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michal Szymanski <mich20061(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Re: 42804: structure of query does not match error where using RETURN QUERY
Date: 2009-05-08 17:26:47
Message-ID: 10322.1241803607@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Michal Szymanski <mich20061(at)gmail(dot)com> writes:
>> Exactly what modifications did you make?

> We have added few new columns and we delete one column.

[ experiments... ] Hmm, looks like RETURN QUERY isn't too bright about
dropped columns in the function result type. I'm not too sure about how
hard this is to fix, but in the meantime you will need to dump and
recreate/reload that particular table in order to get it to work.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Simon Riggs 2009-05-08 18:15:19 Re: BUG #4801: Performance failure: 600 MB written to each WAL log
Previous Message Tom Lane 2009-05-08 17:08:33 Re: BUG #4798: BitMapAnd never works with gin