|| at May 16, 2011 at 2:33 pm
Guillaume Lelarge writes:
Le 05/12/2011 03:52 AM, Wells Oliver a écrit :
If I'm understanding things, pg_dump will not dump casts b/c they are system
objects and belong to neither schema nor database.
It doesn't dump system casts because they are system objects, and so
always available. But it does dump user casts.
Of course the trick is to tell which is which. According to the pg_dump
code the current rule is
* As per discussion we dump casts if one or more of the underlying
* objects (the conversion function and the two data types) are not
* builtin AND if all of the non-builtin objects are included in the dump.
* Builtin meaning, the namespace name does not start with "pg_".
Possibly Oliver is falling foul of that rule somehow --- it's certainly
not perfect, especially in a partial dump scenario.
regards, tom lane