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

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: 2370
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

[Message index]

		Duplicate key value in Postgresql dict-data.sql By: ocelotl on Wed, 12 August 2009 14:08
		Re: Duplicate key value in Postgresql dict-data.sql By: AJM on Wed, 12 August 2009 14:16
		Re: Duplicate key value in Postgresql dict-data.sql By: ocelotl on Wed, 12 August 2009 14:20
		Re: Duplicate key value in Postgresql dict-data.sql By: AJM on Wed, 12 August 2009 15:35
		Re: Duplicate key value in Postgresql dict-data.sql By: ocelotl on Wed, 12 August 2009 17:17

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: Tue Nov 26 04:19:41 EST 2024

Total time taken to generate the page: 0.02846 seconds