just to close this, i reloaded the shapefile data & its working ok. i don't recall doing anything to the generated sql but hey i'm getting on in years ;-) thanks for the help.