| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
| Cc: | Dave Page <dpage(at)postgresql(dot)org>, Shoaib Mir <shoaibmir(at)gmail(dot)com>, Postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Backup Restore |
| Date: | 2007-01-03 18:44:47 |
| Message-ID: | 459BF99F.3090005@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-01-03 19:01:33 | Re: pg_dump problems |
| Previous Message | Bob Pawley | 2007-01-03 18:07:50 | Re: Backup Restore |