logging-log4net-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dominik Psenner <dpsen...@gmail.com>
Subject Re: AdoNetAppender not working PostgreSQL database using Npgsql
Date Fri, 30 May 2014 19:51:44 GMT
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 <RDRichardson@rad-con.com>:

>  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

Mime
View raw message