pg_dump not including custom CAST?

From: "D(dot) Dante Lorenso" <dante(at)lorenso(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump not including custom CAST?
Date: 2007-11-17 01:29:54
Message-ID: 473E4412.2010105@lorenso.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

All,

I did this in my database:

CREATE CAST (VARCHAR AS BYTEA) WITHOUT FUNCTION;

But when I use pg_dump to dump the database and use pg_restore to bring
it back on a freshly created database, the CAST is the only part of the
restore which is missing.

I'm using PostgreSQL 8.2.4 for both the dump and restore database. Why
doesn't the CAST dump and restore?

-- Dante

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2007-11-17 02:01:43 Re: Qeury a boolean column?(using postgresql & EJB)
Previous Message Gregory Stark 2007-11-17 01:21:25 Re: Primary Key