Re: pg_dump not including custom CAST?

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "D(dot) Dante Lorenso" <dante(at)lorenso(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump not including custom CAST?
Date: 2007-11-17 14:49:36
Message-ID: 3882B95B-6FB3-4A79-8D68-4A4A35E22227@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Nov 17, 2007, at 0:36 , Tom Lane wrote:

> "D. Dante Lorenso" <dante(at)lorenso(dot)com> writes:
>> I did this in my database:
>> CREATE CAST (VARCHAR AS BYTEA) WITHOUT FUNCTION;
>
>> I'm using PostgreSQL 8.2.4 for both the dump and restore
>> database. Why
>> doesn't the CAST dump and restore?
>
> pg_dump thinks it's a built-in system object.

What other objects might be susceptible to this? Operators? Operator
classes?

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Kohll 2007-11-17 15:06:38 max_fsm_relations
Previous Message Christian Schröder 2007-11-17 14:41:23 Re: "and then" / "or else"