Fix pg_dump to dump casts between auto-generated types.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: b246207bd7b553317fd90d7aefd9520eed27609a
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2011-10-18T21:10:56Z
Releases: 9.2.0
Fix pg_dump to dump casts between auto-generated types.

The heuristic for when to dump a cast failed for a cast between table
rowtypes, as reported by Frédéric Rejol.  Fix it by setting
the "dump" flag for such a type the same way as the flag is set for the
underlying table or base type.  This won't result in the auto-generated
type appearing in the output, since setting its objType to DO_DUMMY_TYPE
unconditionally suppresses that.  But it will result in dumpCast doing what
was intended.

Back-patch to 8.3.  The 8.2 code is rather different in this area, and it
doesn't seem worth any risk to fix a corner case that nobody has stumbled
on before.

Files

PathChange+/−
src/bin/pg_dump/common.c modified +1 −1
src/bin/pg_dump/pg_dump.c modified +20 −6