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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
