Re: Backup Restore
От | Bob Pawley |
---|---|
Тема | Re: Backup Restore |
Дата | |
Msg-id | 00af01c72f6d$060d1590$8e904618@owner обсуждение исходный текст |
Ответ на | Backup Restore (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: Backup Restore
|
Список | pgsql-general |
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" <rjpawley@shaw.ca> Cc: "Dave Page" <dpage@postgresql.org>; "Shoaib Mir" <shoaibmir@gmail.com>; "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 >
В списке pgsql-general по дате отправления: