PGAdminIII 1.4.1 bug in view_data - getting wrong PK.

From: Scott Chapman <scott_list(at)mischko(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: PGAdminIII 1.4.1 bug in view_data - getting wrong PK.
Date: 2006-01-11 15:30:12
Message-ID: 43C52484.8060802@mischko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

View Data is not getting the correct primary key in pgAdminIII 1.4.1
I have a table shown below which shows it correctly.
When I got "view data", the [PK] shows up on the last column, not the correct
one and deletes fail.

CREATE TABLE users
(
email text NOT NULL,
"password" text NOT NULL,
first_name text NOT NULL,
last_name text NOT NULL,
company text,
address1 text NOT NULL,
address2 text,
city text NOT NULL,
state text NOT NULL,
zip text NOT NULL,
phone1 text NOT NULL,
phone2 text,
phonefax text,
weburl text,
services text[],
products text[],
native_percent text,
ecosystem_specialization text[],
sales_types text[],
payment_types text[],
shipping_methods text[],
notes text,
track_provenance text,
user_id bigserial NOT NULL,
job_title text,
region_specialization text[],
CONSTRAINT users_new_pkey PRIMARY KEY (user_id),
CONSTRAINT users_email_key UNIQUE (email)
)
WITHOUT OIDS;
ALTER TABLE users OWNER TO root;

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2006-01-12 08:56:55 Re: PGAdminIII 1.4.1 bug in view_data - getting wrong PK.
Previous Message Dave Page 2006-01-11 09:29:00 Re: Commandline patch oops