Re: pg_dump not including custom CAST based on table types

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Frédéric Rejol <frederic(dot)rejol(at)sescoi(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump not including custom CAST based on table types
Date: 2011-10-18 18:17:10
Message-ID: 8585.1318961830@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra 2011-10-18 18:23:27 Re: Postgre Performance
Previous Message Alban Hertroys 2011-10-18 18:16:45 Re: Use true and false when bulk-exporting boolean data