Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Simon RiggsDate: 2009-05-08 18:15:19
Subject: Re: BUG #4801: Performance failure: 600 MB written to eachWAL log
Previous:From: Tom LaneDate: 2009-05-08 17:08:33
Subject: Re: BUG #4798: BitMapAnd never works with gin

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group