pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Lowercase 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