>>>>> "David" == "David Gardner" <dgard...@creatureshop.com> writes:
David> The following bug has been logged online: David> Bug reference: 5240 David> Logged by: David Gardner David> Email address: dgard...@creatureshop.com David> PostgreSQL version: 8.4.1 David> Operating system: Debian Linux, amd64 2.6.30 David> Description: Stable Functions that return a table type with a dropped David> column fail David> Details: David> SELECT foo(); works while SELECT * FROM foo(); fails. David> However redefining the function as volatile fixes the David> issue. Possibly related to BUG #4907. I don't think it's particularly closely related to #4907. I've confirmed this bug still exists in both 8.4.2 and HEAD; it's clearly a problem that affects only inlined SQL functions (making the function volatile defeats inlining, and thus avoids the bug). -- Andrew (irc:RhodiumToad) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
