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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michal Szymanski <mich20061(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Re: 42804: structure of query does not match error where using RETURN QUERY
Date: 2009-06-02 14:22:11
Message-ID: 200906021422.n52EMCR20588@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane wrote:
> 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.

Is this a TODO?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-06-02 14:47:36 Re: Re: 42804: structure of query does not match error where using RETURN QUERY
Previous Message Dave Page 2009-06-02 11:26:42 Re: failed to run initdb: 255!