Re: pg_dump not including custom CAST based on table types

From: Greg Jaskiewicz <gryzman(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Frédéric Rejol <frederic(dot)rejol(at)sescoi(dot)fr>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump not including custom CAST based on table types
Date: 2011-10-19 16:56:24
Message-ID: FF3E8F7B-0DE4-4884-90CA-EBF1E1398BBF@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 18 Oct 2011, at 20:17, Tom Lane wrote:

> =?ISO-8859-1?Q?Fr=E9d=E9ric_Rejol?= <frederic(dot)rejol(at)sescoi(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-10-19 17:03:19 Re: pg_dump not including custom CAST based on table types
Previous Message Jeff Adams 2011-10-19 16:40:06 Date Range Using Months and Days Only