Hengky Lie a écrit :
> [...]
> I really amazed with this problem and need your help.
>
> I run simple query from Query window of PgAdmin3: SELECT * FROM mytable
> limit 10;
>
> and the result are NON UPDATABLE QUERY, while i need the result are
> updatable.
>
> I run the same query from Passthrough SQL in Microsoft Access, the
> result are the same (non updatable). But when i run this query from EMS
> SQLMANAGER for postgre, the result are UPDATABLE. I really amazed.
>
> Could someone help me ?
>
Do you have a primary key on mytable or OID ?
If you don't, pgAdmin3 can't allow modification because it doesn't know
how to select a line uniquely. I suppose it is the same for Access. And
it is a really bad behaviour of EMS SQL Manager.
Regards.
--
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com
