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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Problem editing table data...


  • From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
  • To: "Keith C. Perry" <netadmin(at)vcsn(dot)com>, <pgadmin-support(at)postgresql(dot)org>
  • Subject: Re: Problem editing table data...
  • Date: Fri, 2 Sep 2005 21:18:18 +0100
  • Message-id: <E7F85A1B5FF8D44C8A1AF6885BC9A0E4AC9E49(at)ratbert(dot)vale-housing(dot)co(dot)uk>

 

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of 
> Keith C. Perry
> Sent: 02 September 2005 20:43
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Problem editing table data...
> 
> Greetings,
> 
> I apologized if I've missed a discussion on this but there 
> seems to be a problem
> inserting and editing table data when there is no oid column 
> present.  I'm using
> pgadmin 1.2.2 (slackware 10.1) and pg 8.0.3.  Has anyone else 
> reported this? If
> not, does anyone have an idea what might be causing this?

You need either a primary key or an oid column if you want to edit data.
Without, pgAdmin can't properly identify rows.

Regards, Dave



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group