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

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

pgadmin-support by date

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

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