Re: pg_dump vs. TRANSFORMs

On 5/4/16 2:39 PM, Stephen Frost wrote:
> These checks are looking for the functions used by the transform in the
> list of functions that pg_dump has loaded, but in 9.5, we don't load any
> of the function in pg_catalog, and even with my patches, we only dump
> the functions in pg_catalog that have an ACL which has been changed from
> the default.

This issue is not specific to transforms.  For example, if you create a 
user-defined cast using a built-in function, the cast won't be dumped. 
Obviously, this is a problem, but it needs a more general solution.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services