Re: weird problem, cant edit data in tables

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

In response to

Responses

Browse pgadmin-support by date

  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