Radicore Forum: RADICORE Installation Issues » Duplicate key value in Postgresql dict-data.sql

Home » RADICORE » RADICORE Installation Issues » Duplicate key value in Postgresql dict-data.sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Duplicate key value in Postgresql dict-data.sql [message #2258]

Wed, 12 August 2009 14:08

ocelotl
Messages: 4
Registered: August 2009

Junior Member

When you import the dictionary data in Postgresql results in:

psql:dict-data.sql:634: ERROR: duplicate key value violates unique constraint "dict_relationship_pkey"

Report message to a moderator

Re: Duplicate key value in Postgresql dict-data.sql [message #2259 is a reply to message #2258]

Wed, 12 August 2009 14:16

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

What file are you importing?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Duplicate key value in Postgresql dict-data.sql [message #2260 is a reply to message #2259]

Wed, 12 August 2009 14:20

ocelotl
Messages: 4
Registered: August 2009

Junior Member

The file is:
radicore/dict/sql/postgresql/dict-data.sql

Report message to a moderator

Re: Duplicate key value in Postgresql dict-data.sql [message #2261 is a reply to message #2260]

Wed, 12 August 2009 15:35

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

That fle is a copy of dict\sql\mysql\dict-data.sql which uses REPLACE instead of INSERT. Apart from the fact that it allows the script to be run more than once without error, it also caters for the fact that where a record has two foreign keys it is specified once for each foreign key.

I get round any problem by loading the script with pgAdminIII and the 'Execute pgscript' function instead of the 'Execute query' function. This issues a warning with each duplicate key, not an error.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Duplicate key value in Postgresql dict-data.sql [message #2262 is a reply to message #2261]

Wed, 12 August 2009 17:17

ocelotl
Messages: 4
Registered: August 2009

Junior Member

ok, thanks

Report message to a moderator

Previous Topic:	XML/XSL rights issue
Next Topic:	Data base import and 'dict_table(list)2'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Jul 06 01:18:53 EDT 2025

Total time taken to generate the page: 0.10211 seconds