Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey" - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
Date
Msg-id A737B7A37273E048B164557ADEF4A58B50F652A7@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"  (Ankur Kaushik <ankurkaushik@gmail.com>)
Responses Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"  (Ankur Kaushik <ankurkaushik@gmail.com>)
List pgsql-admin
Tree view 
Ankur Kaushik wrote:
> So is there any way to restore database without any error , or Can we put one line in database backup
> file , DROP TABLE 'table name' just before CREATE TABLE.

You mean like the -c option in pg_dump or pg_restore?

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Ankur Kaushik
Date:
Subject: Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
Next
From: Ankur Kaushik
Date:
Subject: Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"