Hi, It seems strange to me that nobody else reported this behavior, maybe a bug.
It just me or what ?. :-). Today I compiled revision 4455, with an updated postgresql 8.1 beta 2 and still can't modify any table due to "ADD before DROP" issue. It seems to happen only in table properties dialog. I can add or modify any table object using ad-hoc property dialogs. To reproduce it, open a table property dialog and look to SQL tab. It should say "-- nothing to change" but in my case shows constraints's add code and corresponding constraints's drop code. Regards, Diego. El vie, 16-09-2005 a las 23:53 -0300, Diego Gil escribió: > Hi: > > I just realized that I am having the following trouble : > > If open properties of a table, to adding a column i.e., and that table > has some constraints, the SQL tab show code similar to : > > ALTER TABLE circulation.deliveries ADD CONSTRAINT > deliveries_delivery_type_id_fk FOREIGN KEY (delivery_type_id) > REFERENCES circulation.deliveries_types (delivery_type_id) MATCH > SIMPLE > ON UPDATE RESTRICT ON DELETE RESTRICT; > > ALTER TABLE circulation.deliveries DROP CONSTRAINT > deliveries_delivery_type_id_fk; > > (there are other constraints, deleted for easing the lecture) > > which cause an error because constraint already exist: DROP is after > ADD. And these code should not appears at all, because I did not any > change to these constraints. Usually says "--nothing to change" or > similar. > > It is a bug or I am doing anything wrong ?. I guess I am using revision > 4442. > > Regards, > Diego. > > > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
