X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 82D81D1B518
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 19 Sep 2003 14:10:35 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 46801-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 19 Sep 2003 11:10:07 -0300 (ADT)
Received: from server146.hostingrevolution.com
	(server146.hostingrevolution.com [64.21.143.245])
	by svr1.postgresql.org (Postfix) with ESMTP id C1B79D1B50F
	for <pgsql-sql@postgresql.org>; Fri, 19 Sep 2003 11:10:03 -0300 (ADT)
Received: from 016.c.001.pth.iprimus.net.au ([210.50.27.16] helo=athlon2000)
	by server146.hostingrevolution.com with smtp (Exim 4.23)
	id 1A0LxD-0004xD-Nv
	for pgsql-sql@postgresql.org; Fri, 19 Sep 2003 09:09:26 -0500
Message-ID: <004c01c37eb8$1328d070$101b32d2@athlon2000>
From: "Richard Sydney-Smith" <richard@ibisaustralia.com>
To: <pgsql-sql@postgresql.org>
Subject: restoring dbschema
Date: Fri, 19 Sep 2003 22:09:56 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_000B_01C37EFA.C2652C40"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-AntiAbuse: This header was added to track abuse,
	please include it with any abuse report
X-AntiAbuse: Primary Hostname - server146.hostingrevolution.com
X-AntiAbuse: Original Domain - postgresql.org
X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12]
X-AntiAbuse: Sender Address Domain - ibisaustralia.com
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/198
X-Sequence-Number: 15176

This is a multi-part message in MIME format.

------=_NextPart_000_000B_01C37EFA.C2652C40
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 alr=
eady 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 a=
m puzzled as to why it is not a clean operation.

Is their another way I should be running this file?

Thanks.
Richard



------=_NextPart_000_000B_01C37EFA.C2652C40
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I have a database created with pg=20
7.3.1</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>In pgAdminII I have saved the DBSchema</FO=
NT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>After creating a&nbsp; new database in pgA=
dmin I=20
opened a SQL box and loaded the dbschema.sql file and tried to run&nbsp;=20
it.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>A number of errors occured. The first was =
that the=20
public namespace was already defined this was followed by:pgSQL language no=
t=20
defined properly, and a number of view already defined and other=20
errors.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I worked through the batch file and eventu=
ally=20
re-created all objects but am puzzled as to why it is not a clean=20
operation.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Is their another way I should be running t=
his=20
file?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Richard</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_000B_01C37EFA.C2652C40--