From: Richard Sydney-Smith <richard@ibisaustralia.com>
To: pgsql-sql@postgresql.org
Subject: restoring dbschema
Date: Fri, 19 Sep 2003 22:09:56 +0800
Message-ID: <004c01c37eb8$1328d070$101b32d2@athlon2000> (raw)
I have a database created with pg 7.3.1
In pgAdminII I have saved the DBSchema
After creating a new database in pgAdmin I opened a SQL box and loaded the dbschema.sql file and tried to run it.
A number of errors occured. The first was that the public namespace was already defined this was followed by:pgSQL language not defined properly, and a number of view already defined and other errors.
I worked through the batch file and eventually re-created all objects but am puzzled as to why it is not a clean operation.
Is their another way I should be running this file?
Thanks.
Richard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: richard@ibisaustralia.com
Subject: Re: restoring dbschema
In-Reply-To: <004c01c37eb8$1328d070$101b32d2@athlon2000>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox