[storm] PostgreSQL issue

Jamu Kakar jkakar at kakar.ca
Sun Oct 3 10:45:22 BST 2010


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.



More information about the storm mailing list