Glad you were able to sort it out on your own and be sure that it would have taken ages to find this. :-)
Cheers 2014-05-30 21:32 GMT+02:00 Rob Richardson <[email protected]>: > Sorry to bother you. The problem turns out to be what seems to me an > unbelievable bug (feature?) in the PostgreSQL administration tool PGAdmin > shipped with version 9.3: if you use that tool to create a table, the name > of the table includes double quotes. > > > > I decided, just for grins, to try the insert statement I specified in my > configuration file: > > INSERT INTO Log (message) VALUES ('This is a log message') > > It didn’t work! > > Neither did: > > INSERT INTO log (message) VALUES ('This is a log message') > > But this worked: > > INSERT INTO “Log” (message) VALUES ('This is a log message') > > > > But I don’t know how to include double quotes inside an XML attribute. > So, I deleted the table and recreated it manually, making sure not to use > double-quotes around the identifiers. Once I did that, I got the log > messages in the table as expected. > > > > RobR > -- Dominik Psenner
