|
We have run into postgres bug #4907 : stored procedures and changed tables To say, we have created a function and made changes to the table and the procedure no longer works giving the error below ERROR: structure of query does not match function result type CONTEXT: PL/pgSQL function "related_screens" line 2 at RETURN QUERY We have worked around this problem by creating different type and assigned it to (RETURNS SETOF public.t1020screen_duplicate) and this works. We are using this version of postgres. PostgreSQL 8.3.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-9) My question, is there a fix available for postgres 8.3.3 According to the link below this happens in 8.3.7 and 8.4.0. Are there patches for these as well. We currently run all three versions. http://archives.postgresql.org/message-id/162867790907121325n7d65480alfea999afae8cdcce@xxxxxxxxxxxxxx Stay on top of things, check email from other accounts! Check it out. |
