RobR wrote
> I then concluded that the table was being created with the double quotes
> included in the table name.
In short:
log = "log"
Log = "log"
Log = log
LoG = lOg
Log <> "Log"
Again, this is all just parser stuff. Whatever is present post-parse on a
create table is stored, as-is, in the
RobR wrote
> I selected the database in PGAdmin, went down to the Tables list (which
> said I had 0 table), right clicked on the word "Tables", and selected "New
> table". In the new table dialog I entered the table name as Log (no
> quotes)
Enter the table name in lower-case. If you cannot surr
Rob, this is what you do.
Either:
1. Use plain lowercase for all of your tablevar and other entity names, meaning
it will work both quoted and unquoted in all contexts.
2. If you use any uppercase, then if writing SQL you use double-quotes around
said entity nmes everywhere they appear.
Se
Thank you for your reply. You said, in part:
What's happening in your case is that the table must have been created
like this:
create table "Log" [.]
But the whole point of my message is that that is not how this table was
created. I did not open an SQL window a
On 30/05/2014 20:49, Rob Richardson wrote:
> I just spent half a day trying to set up a log4net AdoNetAppender to
> write into a PostgreSQL table named “Log”. It was not working, and I
> was not getting any error messages anyplace. Not my application, not
> PostgreSQL log files. I stripped the l
I just spent half a day trying to set up a log4net AdoNetAppender to write into
a PostgreSQL table named "Log". It was not working, and I was not getting any
error messages anyplace. Not my application, not PostgreSQL log files. I
stripped the log4net configuration file to a bare minimum, whe
