Re: pg_dump not including custom CAST based on table types - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump not including custom CAST based on table types
Date
Msg-id 8585.1318961830@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump not including custom CAST based on table types  (Frédéric Rejol <frederic.rejol@sescoi.fr>)
Responses Re: pg_dump not including custom CAST based on table types  (Greg Jaskiewicz <gryzman@gmail.com>)
List pgsql-general
=?ISO-8859-1?Q?Fr=E9d=E9ric_Rejol?= <frederic.rejol@sescoi.fr> writes:
> I created a custom CAST to cast from one table type to another.
> pg_dump does not include my custom CAST.

Hmm.  The reason for that is that the table types aren't considered
dumpable objects.  I suppose we need to fix that, but in the meantime
you'd have better luck if you created the types as composite types
instead of implicit table rowtypes.

            regards, tom lane

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Use true and false when bulk-exporting boolean data
Next
From: Raghavendra
Date:
Subject: Re: Postgre Performance