pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedLowercase problem
3+ messages / 3 participants
[nested] [flat]
* Lowercase problem
@ 2001-02-05 17:25 Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
2001-02-05 17:37 ` Re: Lowercase problem Mitch Vincent <mitch@venux.net>
2001-02-05 18:12 ` Re: Lowercase problem Brent R. Matzelle <bmatzelle@yahoo.com>
0 siblings, 2 replies; 3+ messages in thread
From: Julio Cuz, Jr. @ 2001-02-05 17:25 UTC (permalink / raw)
To: pgsql-php; php-db@lists.php.net
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Lowercase problem
2001-02-05 17:25 Lowercase problem Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
@ 2001-02-05 17:37 ` Mitch Vincent <mitch@venux.net>
1 sibling, 0 replies; 3+ messages in thread
From: Mitch Vincent @ 2001-02-05 17:37 UTC (permalink / raw)
To: pgsql-php; php-db@lists.php.net; Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
Try quoting your table names.
SELECT * FROM "WHATEVER";
-Mitch
----- Original Message -----
From: "Julio Cuz, Jr." <jcuz@rccd.cc.ca.us>
To: <pgsql-php@postgresql.org>; <php-db@lists.php.net>
Sent: Monday, February 05, 2001 12:25 PM
Subject: [PHP] Lowercase problem
> 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
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Lowercase problem
2001-02-05 17:25 Lowercase problem Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
@ 2001-02-05 18:12 ` Brent R. Matzelle <bmatzelle@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: Brent R. Matzelle @ 2001-02-05 18:12 UTC (permalink / raw)
To: pgsql-php
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." <jcuz@rccd.cc.ca.us> 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/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-02-05 18:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-05 17:25 Lowercase problem Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
2001-02-05 17:37 ` Mitch Vincent <mitch@venux.net>
2001-02-05 18:12 ` Brent R. Matzelle <bmatzelle@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox