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