Re: pg_dump ignore CASTs when using --schema

Felix Ostmann <felix(dot)ostmann(at)gmail(dot)com> writes:
> we have a problem with pg_dump and CAST.

Casts don't have names, therefore they don't have schemas, therefore
a dump that is restricted to a particular schema won't select them.
So this isn't a bug; it's operating as designed.

This is kind of unfortunate in many scenarios, but it's hard to see a
principled way around it. You might propose something like pretending
that a cast is in the same schema as its implementation function, but
what about casts that have no implementation function? Likewise,
tying it to the schema of either the input or the output datatype
seems arbitrary and about as likely to be wrong as right.

regards, tom lane