export of schema only

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: export of schema only
Date: 2006-03-30 17:30:51
Message-ID: 6992E470F12A444BB787B5C937B9D4DF03D36FBA@ca-mail1.cis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

This is the scenario:

1. Export schema only
2. On a different postgres box, drop the existing database,
recreate the database and run psql with the exported schema file.
3. One of the views did not import. I get an error saying relation
<view-name> does not exist
4. I recreate the view and then I get an error relation not
available /30142/14567...etc which looks like a system error

The database into which I import is on a different tablespace which is
not in the default data directory

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message lmyho 2006-03-30 17:33:18 more- Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
Previous Message lmyho 2006-03-30 17:27:50 Re: Postgresql server does not start!:( -Re: PostgreSQl newbie!