Re: SELECT clause no relation found.

It could also be that the table was created as "person" (with the quotes)
instead of minus the quotes. SQL is suposed to be a caseless language, but
if you force a case structure on it, it will conform to it quite rigidly.
If you use case to define an object, you will be forced to continue to
specify the case.

>Mika,
>
>If you turn sql statement tracing on on the server, you could then see
>the exact sql statements that are being sent from the jdbc driver to the
>server.
>
>thanks,
>--Barry
>
>Mika Pesu wrote:
>> what's wrong with key sql
>>
>> select * from person;
>>
>> gives me error no person relation found
>>
>> but when i use
>> select * from "person"
>>
>> doesn't give any error.
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>> message can get through to the mailing list cleanly
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org