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

From Bruce Momjian
Subject Re: Re: 42804: structure of query does not match error where using RETURN QUERY
Date
Msg-id 200906021422.n52EMCR20588@momjian.us
Whole thread Raw
In response to Re: Re: 42804: structure of query does not match error where using RETURN QUERY  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: 42804: structure of query does not match error where using RETURN QUERY  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane wrote:
> 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.

Is this a TODO?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-bugs by date:

Previous
From: Dave Page
Date:
Subject: Re: failed to run initdb: 255!
Next
From: Tom Lane
Date:
Subject: Re: Re: 42804: structure of query does not match error where using RETURN QUERY