From: | "Roger D(dot) Vargas" <roger(at)ehtsc(dot)co(dot)cu> |
---|---|
To: | PgAdmin Support Mailing List <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: weird problem, cant edit data in tables |
Date: | 2004-08-17 17:09:55 |
Message-ID: | 1092762594.18997.3.camel@prospero.ehtsc.co.cu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
El mar, 17-08-2004 a las 14:46, Andreas Pflug escribió:
> Roger D. Vargas wrote:
> > El mar, 17-08-2004 a las 08:11, Dave Page escribió:
> >
> >>>my version is 1.0.2 for windows, and some recently created
> >>>tables cant be edited to insert/update values. Simply the
> >>>grid doesnt appears or if there is data (inserted in psql by
> >>>hand) it cant be modified. Seems to happen only for tables
> >>>that has a field referencing a master table.
> >>>I created the table using pgadmin, and then using sql
> >>>commands in psql, but the result is the same.
> >>
> >>Do you have a primary key specified?
> >>
> >
> > Yes, in the master table (created using pgadmin)
>
> What is a master table?
>
> In order to edit tables, they need to have uniquely identifyable rows,
> see the doc.
Sorry for the term, a master table is the one that contains the primary
key, the "detail" table references the primary key in that master table,
a "master-detail" relationship.
--
Roger Durañona Vargas
Linux user #180787
A cada momento nos rodea lo desconocido. Es alli
donde uno tiene que buscar el conocimiento.
Paul Muad'Dib Atreides. Children of Dune
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-08-17 17:17:56 | Re: weird problem, cant edit data in tables |
Previous Message | Roger D. Vargas | 2004-08-17 17:08:04 | Re: error with pgadmin for linux |