|
|
|
|
|
|
| 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: 2367
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
|
|
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
