Re: tables with small letters?

Gerhard Häring <[email protected]> Tue, 08 Feb 2005 19:50:55 +0100
Newsgroups gmane.comp.python.db.pypgsql.user
Message-ID <[email protected]>
Mican Bican wrote:
> Hello,
> 
> I write a test python file to connect my postgresql database. My table 
> called Testtabelle. Python always bring an error... "a relation called 
> testtabelle not exists" or so.. So I try to change the tablename from 
> Testtabelle to testtabelle... uups and it works..?? Is this possible 
> that pypgsql only allows tablenames with small letters????

pyPgSQL has nothing to do with it. Probably the table was created with 
something like:

create table "Testtabelle"

and then, case does matter I believe. At least I've seen something like 
this recently in Oracle.

-- Gerhard


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click