Re: pg_dump vs. TRANSFORMs - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: pg_dump vs. TRANSFORMs
Date
Msg-id 0a288671-29ec-ecdd-d8ae-e0f5c73dcc8d@2ndquadrant.com
Whole thread Raw
In response to pg_dump vs. TRANSFORMs  (Stephen Frost <sfrost@snowman.net>)
Responses Re: pg_dump vs. TRANSFORMs  (Stephen Frost <sfrost@snowman.net>)
Re: pg_dump vs. TRANSFORMs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Timeline following for logical slots
Next
From: Jeff Janes
Date:
Subject: Re: atomic pin/unpin causing errors