The following bug has been logged on the website: Bug reference: 7786 Logged by: Douglas Toltzman Email address: d...@oakstreetsoftware.com PostgreSQL version: 9.2.2 Operating system: Linux CentOS Description:
in the interest of simplicity, I've got a view that calls a stored procedure to compute a value ... create view testv as select tt.field1, tt.intfield, compute_val(tt.field1) AS compute1 from tt; If compute_val() selects sum(intfield) from the testv view, compute_val() is called again when selecting records from testv (even though compute1 was not selected), resulting in infinite recursion (stack overflow). In retrospect, I realize this may have been a bad thing to do, but it worked in version 8.1.x. I recently upgraded to 9.2.2 and I had to create a 2nd view that didn't include the computed values, so I could use that view in the stored procedures. It seems like a performance problem to compute all columns in a view when selecting only specific columns. I've already fixed my stack overflow, so I'll let you decide if this is a bug or a feature. If you're interested in reproducing this and you don't understand my description, I'd be happy to provide a test case. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
