Re: Problem editing table data...

From: "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Problem editing table data...
Date: 2005-09-03 22:53:36
Message-ID: 1125788016.431a2970826dd@webmail.vcsn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Ahhh, after all this time using pgadmin, this was the first time I've created
tables from scratch *and* for some reason, I didn't define the pkey (duh).
Least I know whats going on now. Thanks.

Quoting Dave Page <dpage(at)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
>

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Tala Halaseh 2005-09-04 18:44:10 i need some help
Previous Message Andreas Pflug 2005-09-02 22:31:36 Re: Problem editing table data...