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

From Greg Jaskiewicz
Subject Re: pg_dump not including custom CAST based on table types
Date
Msg-id FF3E8F7B-0DE4-4884-90CA-EBF1E1398BBF@gmail.com
Whole thread Raw
In response to Re: pg_dump not including custom CAST based on table types  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dump not including custom CAST based on table types  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 18 Oct 2011, at 20:17, Tom Lane wrote:

> =?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.


Maybe worth adding to the TODO.
Casts do exist in the database persistently, don't they ?

In which case it is only fair to have them in pg_dump, me thinks.


pgsql-general by date:

Previous
From: Jeff Adams
Date:
Subject: Date Range Using Months and Days Only
Next
From: Tom Lane
Date:
Subject: Re: pg_dump not including custom CAST based on table types