Re: pgadmin2 1.4.12 edit record- update record

-----Original Message-----
From: Alex Balan [mailto:abalan@telus.net]
Sent: 16 January 2003 20:48
To: pgadmin-hackers@postgresql.org
Subject: [pgadmin-hackers] pgadmin2 1.4.12 edit record- update record
Importance: High

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;