| 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: | Whole Thread | Raw Message | 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 |