pg_restore problem with type

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: pg_restore problem with type
Date: 2011-04-10 11:20:56
Message-ID: 4DA19298.8090802@compulab.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a backup of a database from 8.2.x and I am trying to restore it
into 9.0.x

In 8.2.x I used the citext data type from pgfoundry (before it was part
of contrib) and it was put in the pg_catalog.

In 9.0 I am using the citext data type in contrib and it put it into the
public schema.

When I restore, using pgadmin, I get an error that citext type does not
exist for all schemas except public.

If I execute the DDL command by itself, it works.

It looks like the public schema is not in the search path during the
restore. Does this make any sense? How can I work around this?

Thanks

Sim

Browse pgsql-general by date

  From Date Subject
Next Message Arash pajoohande 2011-04-10 11:41:33 what data type to store fixed size integer?
Previous Message Noah Misch 2011-04-10 10:12:39 Re: Transaction wraparound vacuum synchronicity