Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

Next:From: Andreas PflugDate: 2004-08-17 17:17:56
Subject: Re: weird problem, cant edit data in tables
Previous:From: Roger D. VargasDate: 2004-08-17 17:08:04
Subject: Re: error with pgadmin for linux

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group