Re: pg_dump not including custom CAST? - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump not including custom CAST?
Date
Msg-id 17086.1195315287@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump not including custom CAST?  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-general
Michael Glaesemann <grzm@seespotcode.net> writes:
> On Nov 17, 2007, at 0:36 , Tom Lane wrote:
>> pg_dump thinks it's a built-in system object.

> What other objects might be susceptible to this? Operators? Operator
> classes?

It's just casts.  They're a bit of a problem since they have neither
owners nor schemas, so there's not anything very concrete to base a
dump-or-don't-dump decision on.  The rule pg_dump uses is to dump it
if at least one of the three underlying objects (source type, dest type,
or function) is dumpable.  Here you've got 2 builtin types and
no function, so you lose.

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Qeury a boolean column?(using postgresql & EJB)
Next
From: Shane Ambler
Date:
Subject: Re: Need help with complicated SQL statement