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: | [email protected] |
Views: | Whole Thread | Raw Message | 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.
Branch
------
master
Modified Files
--------------
src/bin/pg_dump/pg_dump.c | 46 +++++++++++++++++-----
src/bin/pg_dump/t/002_pg_dump.pl | 85 +++++++++++++++++++++++++---------------
2 files changed, 90 insertions(+), 41 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 |