Robert Haas <robertmh...@gmail.com> writes: > I suppose that the root of the problem here is that foo() is not > really immutable - it gives different results depending on the search > path.
Yeah. The declaration of the function is broken --- it's not pg_dump's fault that the function misbehaves. > I actually wonder if we shouldn't automatically tag plpgsql functions > with the search_path in effect at the time of their creation (as if > the user had done ALTER FUNCTION ... SET search_path=...whatever the > current search path is...). That would be extremely expensive and not very backwards-compatible. In the case at hand, just writing "RETURN bar.bar();" would be the best-performing solution. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers