[storm] PostgreSQL issue
Rory Brown
gozargozarian at gmail.com
Sun Oct 3 16:50:10 BST 2010
Interesting. So it seems this is a bug with how psycopg2 creates SQL.
Perhaps I'll search around on that. Thanks for everyone's help!
> Hi,
>
> On Sun, Oct 3, 2010 at 3:25 AM, Rory Brown <gozargozarian at gmail.com>
wrote:
>> I am having an issue starting out with Storm and PostgreSQL. I have a
>> simple table called "Users" in the database and have defined my class to
>> have _storm_table_ = "Users". But, when I attempt to use the class, as
it
>> used to work in MySQL, I get the error: ProgrammingError: relation
"users"
>> does not exist. It has made my Users table smallcase. How do I fix that?
>> What did I do wrong? Used to work fine with MySQL and same case, names,
and
>> data.
>
> It looks like you're experiencing this issue:
>
>
http://stackoverflow.com/questions/2774406/psycopg2-doesnt-like-table-names-that-start-with-a-lower-case-letter
>
> You could try:
>
> __storm_table__ = '"Users"'
>
> I'm not sure if it'll actually work, but it might.
>
> Thanks,
> J.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.ubuntu.com/archives/storm/attachments/20101003/a0c603a2/attachment-0001.htm
More information about the storm
mailing list