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;
