Custom types and pg_dump - Mailing list pgsql-general

From Roderick A. Anderson
Subject Custom types and pg_dump
Date
Msg-id 49EDE123.6050804@cyber-office.net
Whole thread Raw
Responses Re: Custom types and pg_dump
List pgsql-general
A quick request for a pointer to look or an answer.

Background:

I was asked to test the results of a pg_dump of a database.

While and after doing a import ("\i file_dump") I notice one table had
two attributes with a type of "unknown".  I'm not sure of the Pg version
it cam from but I was putting it into an 8.3.6 database from the PGDG
yum repo on a CentOS 5.2 system.

So the question is; is it possible to have a custom type in a cluster
that is accessible/usable in a database but isn't picked up by pg_dump?

Again a pointer of where to look would be fine.  (I've never seen this
mentioned, not that is unusual for me, in the pg_dump documentation.)


TIA,
Rod
--

pgsql-general by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: Re: Doubt about join queries
Next
From: Tom Lane
Date:
Subject: Re: Custom types and pg_dump