Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: 42804: structure of query does not match error where using RETURN QUERY - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Re: 42804: structure of query does not match error where using RETURN QUERY
Date
Msg-id 10322.1241803607@sss.pgh.pa.us
Whole thread Raw
In response to Re: 42804: structure of query does not match error where using RETURN QUERY  (Michal Szymanski <mich20061@gmail.com>)
Responses Re: Re: 42804: structure of query does not match error where using RETURN QUERY  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
Tree view 
Michal Szymanski <mich20061@gmail.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4798: BitMapAnd never works with gin
Next
From: Simon Riggs
Date:
Subject: Re: BUG #4801: Performance failure: 600 MB written to each WAL log