From: | Diego Gil <diego(at)adminsa(dot)com> |
---|---|
To: | PgAdmin Hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | wrong order of drop ... create ... sentences |
Date: | 2005-09-17 02:53:34 |
Message-ID: | 1126925614.9785.17.camel@roadwarrior.adminsa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers pgadmin-support |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | svn | 2005-09-17 21:22:39 | SVN Commit by andreas: r4445 - trunk/pgadmin3/docs/en_US |
Previous Message | Devrim Gunduz | 2005-09-16 09:25:47 | Re: Pgadmin III connection error |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2005-09-17 22:00:31 | Re: PG Agent Job Viewing bug |
Previous Message | Roberto Tagliaferri | 2005-09-16 13:56:48 | Error in pgadmin |