Re: weird problem, cant edit data in tables

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Roger D(dot) Vargas" <roger(at)ehtsc(dot)co(dot)cu>, "PgAdmin Support Mailing List" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: weird problem, cant edit data in tables
Date: 2004-08-18 07:11:05
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E41A779D@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
> Roger D. Vargas
> Sent: 17 August 2004 13:14
> To: PgAdmin Support Mailing List
> Subject: Re: [pgadmin-support] weird problem, cant edit data in tables
>
> 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)

You need one in each table, otherwise pgAdmin has no way of identifying which row you are editting.

Regard,s Dave.

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2004-08-18 10:18:42 Re: pgAdmin3 bug
Previous Message Joe Grist 2004-08-18 06:34:42 PGAdmin does not support tables that have reseved words for tables well