Custom types and pg_dump

From: "Roderick A(dot) Anderson" <raanders(at)cyber-office(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Custom types and pg_dump
Date: 2009-04-21 15:07:15
Message-ID: 49EDE123.6050804@cyber-office.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
--

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-04-21 15:16:05 Re: Custom types and pg_dump
Previous Message Filip Rembiałkowski 2009-04-21 15:05:06 Re: Doubt about join queries