From: Thomas Bednarz <lists@...>
Date: 2012-09-18T16:02:29+09:00
Subject: Ruby Postgres driver (pg) and case sensitivity

I am playing around with ruby and postgres. Postgresql is usually cAsE
SenSiTive. When I create a prepared statement in ruby like

conn = PGconn.open(.....)
conn.prepare('stmt1', 'insert into MyTable(my_number, my_string)
values($1, $2)'
conn.exec_prepared('stmt1', [@number, @string])

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!

Thanks for any hints.
Tom

-- 
Posted via http://www.ruby-forum.com/.