From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Hengky Lie <hengkyliwandouw(at)gmail(dot)com> |
Cc: | pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Simple Problem ? |
Date: | 2008-09-16 06:32:01 |
Message-ID: | 48CF52E1.3080207@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2008-09-16 07:32:31 | Re: Simple Problem ? |
Previous Message | Hengky Lie | 2008-09-16 05:01:11 | Simple Problem ? |