Skip site navigation (1) Skip section navigation (2)

wrong order of drop ... create ... sentences

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 (view raw or flat)
Thread:
Lists: pgadmin-hackerspgadmin-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.





Responses

pgadmin-hackers by date

Next:From: svnDate: 2005-09-17 21:22:39
Subject: SVN Commit by andreas: r4445 - trunk/pgadmin3/docs/en_US
Previous:From: Devrim GunduzDate: 2005-09-16 09:25:47
Subject: Re: Pgadmin III connection error

pgadmin-support by date

Next:From: Andreas PflugDate: 2005-09-17 22:00:31
Subject: Re: PG Agent Job Viewing bug
Previous:From: Roberto TagliaferriDate: 2005-09-16 13:56:48
Subject: Error in pgadmin

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group