Found it in template 1. This seems strange as both servers and pgadmins are
the same version and I haven't opened the template until today.
Bob
----- Original Message -----
From: "Richard Huxton" <dev@archonet.com>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Dave Page" <[EMAIL PROTECTED]>; "Shoaib Mir" <[EMAIL PROTECTED]>;
"Postgresql" <pgsql-general@postgresql.org>
Sent: Wednesday, January 03, 2007 10:44 AM
Subject: Re: [GENERAL] Backup Restore
Bob Pawley wrote:
Looking through PGAdmin where would I find the spatial references that
the errror message references?
Bob Pawley wrote:
Following is the error message on pg_restore:-
"pg_restore: ERROR: duplicate key violates unique constraint
"spatial_ref_sys_pkey"
CONTEXT: COPY spatial_ref_sys, line 1: "2000 EPSG 2000
PROJCS["Anguilla 1957 / British West Indies Grid",GEOGCS["Anguilla
1957",DATUM["Angui..."
Looking at this, you should have a table "spatial_ref_sys" with a primary
key constraint "spatial_ref_sys_pkey"
Find the table via the left-hand tree conrol and its details should be
listed on the right-hand side. The primary key will be detailed at the top
and bottom
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly