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
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 |