Alexandre Caneo wrote:
When I select the datas with this instruction "select a.x from a,b where a.z = b.z order by 1" the program run very well and I can insert, update and delete rows. But, when I select any column from table b an error occurs when I try to modify the column value from textbox for an example. "Binding Collection Error. field not updatable".
Maybe you should try your query from psql, and see if it works fine there. If it does, then you know the problem is in your data access driver or application.
At a guess, I'd say you'll be having issues with data type support in the data access driver. You are using a prehistoric programming language, which won't be helping.
You should post your query (if it's generated by your app at runtime, get it by enabling query logging in the database and fishing it out of the PostgreSQL log) and the schema definition of the problem table as obtained with psql's \d command.
-- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
