From: | Stephen Frost <sfrost(at)snowman(dot)net> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Fix dumping of casts and transforms using built-in functions |
Date: | 2016-12-21 18:47:47 |
Message-ID: | E1cJlvX-0001s1-OD@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Fix dumping of casts and transforms using built-in functions
In pg_dump.c dumpCast() and dumpTransform(), we would happily ignore the
cast or transform if it happened to use a built-in function because we
weren't including the information about built-in functions when querying
pg_proc from getFuncs().
Modify the query in getFuncs() to also gather information about
functions which are used by user-defined casts and transforms (where
"user-defined" means "has an OID >= FirstNormalObjectId"). This also
adds to the TAP regression tests for 9.6 and master to cover these
types of objects.
Back-patch all the way for casts, back to 9.5 for transforms.
Discussion: https://www.postgresql.org/message-id/flat/20160504183952.GE10850%40tamriel.snowman.net
Branch
------
REL9_3_STABLE
Details
-------
http://git.postgresql.org/pg/commitdiff/1f2cfd26f50d3a7d885961aa68361d40d7753949
Modified Files
--------------
src/bin/pg_dump/pg_dump.c | 13 ++++++++++---
1 file changed, 10 insertions(+), 3 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2016-12-21 20:05:51 | pgsql: Improve ALTER TABLE documentation |
Previous Message | Dean Rasheed | 2016-12-21 17:55:47 | Re: pgsql: Fix base backup rate limiting in presence of slow i/o |