Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » RADICORE Installation Issues » Duplicate key value in Postgresql dict-data.sql
Duplicate key value in Postgresql dict-data.sql [message #2258] Wed, 12 August 2009 14:08 Go to next message
ocelotl is currently offline  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"
Re: Duplicate key value in Postgresql dict-data.sql [message #2259 is a reply to message #2258] Wed, 12 August 2009 14:16 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2347
Registered: April 2006
Location: Surrey, UK
Senior Member
What file are you importing?

Re: Duplicate key value in Postgresql dict-data.sql [message #2260 is a reply to message #2259] Wed, 12 August 2009 14:20 Go to previous messageGo to next message
ocelotl is currently offline  ocelotl
Messages: 4
Registered: August 2009
Junior Member
The file is:
radicore/dict/sql/postgresql/dict-data.sql
Re: Duplicate key value in Postgresql dict-data.sql [message #2261 is a reply to message #2260] Wed, 12 August 2009 15:35 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2347
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.


Re: Duplicate key value in Postgresql dict-data.sql [message #2262 is a reply to message #2261] Wed, 12 August 2009 17:17 Go to previous message
ocelotl is currently offline  ocelotl
Messages: 4
Registered: August 2009
Junior Member
ok, thanks
Previous Topic: XML/XSL rights issue
Next Topic: Data base import and 'dict_table(list)2'
Goto Forum:
  


Current Time: Tue Mar 19 00:41:59 EDT 2024

Total time taken to generate the page: 0.01016 seconds