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

2009-06-02 Thread Tom Lane
Bruce Momjian writes: > Tom Lane wrote: >> [ 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 ta

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

2009-06-02 Thread Bruce Momjian
Tom Lane wrote: > Michal Szymanski 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 abou

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

2009-05-08 Thread Tom Lane
Michal Szymanski 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

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

2009-05-08 Thread Michal Szymanski
> Exactly what modifications did you make? We have added few new columns and we delete one column. Michal Szymanski http://blog.szymanskich.net -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

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

2009-05-08 Thread Michal Szymanski
> you have to do vacuum full  cerber.cerber_account Yes I've made vacuum full - result was the same. Regards Michal Szymanski -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

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

2009-05-08 Thread Michal Szymanski
We use Postgres 8.3.7 on Linux -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs