Re: pg_dump not including custom CAST based on table types

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Jaskiewicz <gryzman(at)gmail(dot)com>
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 17:03:19
Message-ID: 18489.1319043799@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Jaskiewicz <gryzman(at)gmail(dot)com> writes:
> On 18 Oct 2011, at 20:17, Tom Lane wrote:
>> 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.

If I hadn't done it yesterday, maybe so.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2011-10-19 17:08:03 Re: psqlODBC connection
Previous Message Greg Jaskiewicz 2011-10-19 16:56:24 Re: pg_dump not including custom CAST based on table types