Re: 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