| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: pg_dump vs. TRANSFORMs |
| Date: | 2016-05-04 20:56:05 |
| Message-ID: | 0a288671-29ec-ecdd-d8ae-e0f5c73dcc8d@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2016-05-04 21:00:01 | Re: atomic pin/unpin causing errors |
| Previous Message | Alvaro Herrera | 2016-05-04 20:55:29 | Re: Timeline following for logical slots |