Thread: SELECT clause no relation found.

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.

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@postgresql.org so that your
> message can get through to the mailing list cleanly
>

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@postgresql.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@postgresql.org