Postgres Fields are marked ReadOnly

sandeep_c24 · Post by **sandeep_c24** » 30.01.2011, 14:03

I am using Zeos from trunk to connect to Postgres 8.4. When I open TZquery all fields are marked as ReadOnly. I am not sure what is going, has anyone else seen this problem?

Regards

Sandeep

Post by **seawolf** » 30.01.2011, 15:45

Could be a problem related to the user right you are using to connect to pg?

Have you recently updated Zeos libs or PG?

trupka · Post by **trupka** » 31.01.2011, 10:51

Never encountered something like this (Delphi 7-2010, Pg8.3 - 9.0).
Are you using joins in SQL?

mrLion · Post by **mrLion** » 31.01.2011, 18:51

sandeep_c24, may be you are open View?

sandeep_c24 · Post by **sandeep_c24** » 01.02.2011, 23:30

I spent some time debugging it and the problem is in caused because my sql command was like

select * from Bill

but the table name is "bill". Data is retrieved but the postgres metadata sql uses "like" to get the column info and that's why the fields were marked readonly.

Sandeep