I have a question regarding a strange behaviour.
I use postgreSQL 7.0.3 on SuSE Linux, Coldfusion 4.5.2 SP2 and the pgAdmin
7.0.4. For development I use Ultradev 4.0.
I created a database with
createdb customer with a table order.
The query select * from order dosn't work. Doing select * from "order" is
ok. When i do a query on as system table the quotes are not needed. Since
Ultradev builds queries without the quotes, I can't use the queries with
the quotes.
Why do I need the quotes on my new defined table ? Is Encoding the point ?
Thanks in advance ... jr
============================================
PFISTER + PARTNER, SYSTEM - ENGINEERING AG
Juerg Rietmann
Grundstrasse 22a
6343 Rotkreuz
Switzerland
phone: +4141 790 4040
fax: +4141 790 2545
mobile: +4179 211 0315
============================================
