Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'Ankur Kaushik *EXTERN*'" <ankurkaushik(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
Date: 2015-06-17 09:43:27
Message-ID: A737B7A37273E048B164557ADEF4A58B50F652A7@ntex2010a.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ankur Kaushik 2015-06-17 10:04:34 Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
Previous Message Ankur Kaushik 2015-06-17 08:58:29 Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"