Update problems - PLEASE HELP

[Serpha]

Hi, I'm having problems with the UPDATE sql command when connecting postgresql to a java program. In my debug process I then tried the command directly in postgres (which also did not work).
But get this, if I then create new data in postgres the SAME sql command works! (although UPDATE still doesn't work when tried via the java program) I am also using simple delete , select and insert commands in the java program which work fine so I am not sure that it is my java skills that are at fault here.

Can anyone suggest anything because i'm stumped with this. Thanks

 

[BenBaron]

What Error are you getting back??
Dont know if this is helpful but I had a problem awhile back when I started, after coverting from access, in that I didnt use lower case for the field names in both query and field Def, and when I tried a select it worked but an update didnt! Dodgy but still perhaps thats it?

 

[Serpha]

Thanks Ben, I had a previous pg_dump of my database and tried the radical step of removing then reinitialising the database which for some reason worked (at least I know that my programming wasn't at fault!). However, now my insert commands work sporadically (such as inserting the first two characters instead of the full string)

Hmm, I think there may be something wrong with my postgresql install.