Re: Simple Problem ?

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.org
http://dalibo.com