Re: tables with small letters?

Mican Bican <[email protected]> Tue, 08 Feb 2005 20:28:29 +0100
Newsgroups gmane.comp.python.db.pypgsql.user
Message-ID <[email protected]>
Gerhard Häring schrieb:

> 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
> _______________________________________________
> Pypgsql-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/pypgsql-users
>
I  create the tabel with pgadmin, I run the programm with IDLE .. I dont 
know what is the problem.. all tools are the last version..
i add one screenshot from the error.. probably it is a problem from python??

--Muhlis
error1.PNG (image/png, 42.2 KB) - not displayed