Received: from web313.mail.yahoo.com (web313.mail.yahoo.com [216.115.105.78]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f15ICUx45639 for ; Mon, 5 Feb 2001 13:12:30 -0500 (EST) (envelope-from bmatzelle@yahoo.com) Message-ID: <20010205181228.5051.qmail@web313.mail.yahoo.com> Received: from [192.104.254.70] by web313.mail.yahoo.com; Mon, 05 Feb 2001 10:12:28 PST Date: Mon, 5 Feb 2001 10:12:28 -0800 (PST) From: "Brent R. Matzelle" Subject: Re: Lowercase problem To: pgsql-php@postgresql.org In-Reply-To: <4.3.2.7.2.20010205084023.036ddee8@rccd.cc.ca.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200102/3 X-Sequence-Number: 142 Postgre uses only lowercase table names. Even if you created the table with uppercase letters, the database converts them to lowercase. I'm not sure if that is your problem in any case. I could help you better if you provided your query code and the error results. Brent --- "Julio Cuz, Jr." wrote: > Hi-- > > I don't know where the problem resides, but when I call a > table or a field > name from Postgresql using PHP4, it treats the string ALL > LOWERCASE, so I > get an error about 'field/table not relational..." do you know > where the > problem is? > > P.S. Some tables have upper and lowercase, as well as field > names...I had > to transfer everything to lowercase to get it working. > > Julio Cuz, Jr. > Riverside Community College > jcuz@rccd.cc.ca.us > __________________________________________________ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/