I get an error that mytable was not found! (the tablename is now all
lowercase!)
Does the pg ruby driver automatically convert all table names to
lowercase?? Is there any way to configure this behaviour? If you access
legacy databases there is no way to influence their naming conventions!
I get an error that mytable was not found! (the tablename is now all
lowercase!)
Does the pg ruby driver automatically convert all table names to
lowercase?? Is there any way to configure this behaviour? If you access
legacy databases there is no way to influence their naming conventions!
-----
1
(1 row)
rklemme=> select * from Ta;
val
-----
1
(1 row)
rklemme=> select * from TA;
val
-----
1
(1 row)
rklemme=> select * from tA;
val
-----
1
(1 row)
rklemme=> select * from "Ta";
val
-----
2
(1 row)
rklemme=> \d
List of relations
Schema | Name | Type | Owner
--------+--------------------------+----------+---------
public | Ta | table | rklemme
public | ta | table | rklemme
Maybe you can do this:
conn.prepare('stmt1', 'insert into "MyTable"(my_number, my_string)
values($1, $2)'
Well the postgres server is not the problem, I use pgAdmin with its ISQL
to execute statements and there case doesn't matter either.
I had the problem with the Ruby Driver, but I will extend my test
programm a little to see, if this is really true in various situations
(updates, deletes, inserts and calls of stored procedures).
Well the postgres server is not the problem, I use pgAdmin with its ISQL
to execute statements and there case doesn't matter either.
I know. I used psql to illustrate the point about case handling
because I assume that it might be similar with pg driver. Apparently
that wasn't clear to you.
I had the problem with the Ruby Driver, but I will extend my test
programm a little to see, if this is really true in various situations
(updates, deletes, inserts and calls of stored procedures).