Hi, I've encountered a serious Postgres bug which apparently has a fix that hasn't been released in a patch. How or where can I look up its status?
This is a serious bug- it basically renders RETURN QUERY useless in any environment where you don't have the option of dropping and re-creating a table, so I'm surprised to see that it's been outstanding for this long. 42804: structure of query does not match error where using RETURN QUERY Tom Lane wrote: > Michal Szymanski <mich20...@...> 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 <br...@...> http://momjian.us EnterpriseDB http://enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-b...@...) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs Re: Re: 42804: structure of query does not match error where using RETURN QUERY by Tom Lane-2 Jun 02, 2009; 07:47am :: Rate this Message: - Use ratings to moderate (?) Reply | Reply to Author | Print | View Threaded | Show Only this Message Bruce Momjian <br...@...> 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 table in order to get it to work. > Is this a TODO? It's already there. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
