PGAdminIII 1.4.1 bug in view_data - getting wrong PK.
| От | Scott Chapman |
|---|---|
| Тема | PGAdminIII 1.4.1 bug in view_data - getting wrong PK. |
| Дата | |
| Msg-id | 43C52484.8060802@mischko.com обсуждение исходный текст |
| Список | 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;
В списке pgadmin-hackers по дате отправления: