|
|
|
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 message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
AJM
Messages: 2361 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
|
|
|
|