_PepeR_ wrote:

lms=> BEGIN; BEGIN lms=> ALTER TABLE nodes DROP CONSTRAINT nodes_mac_key; ERROR: ALTER TABLE / DROP CONSTRAINT: nodes_mac_key does not exist lms=> UPDATE dbinfo SET keyvalue = '2004042000' WHERE keytype = 'dbversion'; ERROR: current transaction is aborted, queries ignored until end of transaction block lms=> COMMIT; COMMIT

a masz w ogóle unique constraint na polu mac w tabeli nodes, phppgadmin to ladnie pokazuje (wiecy integralnosci) moze ma inna nazwe? albo tego nie masz? Jaki jest komunikat gdy dodajesz taki sam mac?