|
Hi there,
Heare is an issue I found with pgadmin2 ver 1.4.0
and 1.4.12 which is NOT in ver 1.2
Have a table (structure is at the end of this
mail).
My key is:
CONSTRAINT inventoryindex UNIQUE (warehouse_code,
serial_number, id),
CONSTRAINT inventory_key PRIMARY KEY (warehouse_code,
serial_number, id),
(id is an autonumber, serial_number is
unique regardless of warehouse_code so the whole key is unique.)
A select statement (on serial_number=....) returns ONE record - in both ver 1.4.x and 1.2.x Click Edit, change anything and try to
save
ver 1.2.x SAVES,
ver 1.4.x returns
warning:
"The selected record could
not be uniquely identified. 7782 records match and will all be updated if you
proceed. Do you ..."
I went back to ver 1.2.x for now, just to be on the
safe side...
If you want more details please feel free to email
me.
Alex
CREATE TABLE inventorymaster (warehouse_code char(3) NOT NULL, serial_number varchar(16) NOT NULL, class_code char(4) NOT NULL, length int2 NOT NULL, diameter int2 NOT NULL, manufactured_date date NOT NULL, sold_date char(10), returned_date char(10), customer_code char(6), so_number numeric(10, 0), inumcad numeric(10, 0), bfm_unit_volume numeric(15, 2), spothlf numeric(15, 2), sale_currency char(3), costrm numeric(15, 2), costoh numeric(15, 2), qty numeric(15, 2), id int4 DEFAULT nextval('id'::text) NOT NULL, spothwh numeric(15, 2), spcadwh numeric(15, 2), inumoth numeric(10, 0), uom char(6), bfm numeric(15, 5), spcadlf numeric(15, 2), CONSTRAINT inventoryindex UNIQUE (warehouse_code, serial_number, id), CONSTRAINT inventory_key PRIMARY KEY (warehouse_code, serial_number, id), CONSTRAINT "<unnamed>" FOREIGN KEY (warehouse_code) REFERENCES warehousemaster (warehouse_code) ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT "<unnamed>" FOREIGN KEY (class_code) REFERENCES classmaster (class_code) ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE) WITH OIDS; |
