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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Re: 42804: structure of query does not match error where using RETURN QUERY
Дата
Msg-id 200906021422.n52EMCR20588@momjian.us
обсуждение исходный текст
Ответ на Re: Re: 42804: structure of query does not match error where using RETURN QUERY  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Re: 42804: structure of query does not match error where using RETURN QUERY  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: failed to run initdb: 255!
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: 42804: structure of query does not match error where using RETURN QUERY