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

Re: wrong order of drop ... create ... sentences

From: Diego Gil <diego(at)adminsa(dot)com>
To: PgAdmin Hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: wrong order of drop ... create ... sentences
Date: 2005-09-19 19:19:56
Message-ID: 1127157596.3178.11.camel@roadwarrior.adminsa.com (view raw or flat)
Thread:
Lists: pgadmin-hackerspgadmin-support
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.
> 
> 
> 


In response to

Responses

pgadmin-hackers by date

Next:From: svnDate: 2005-09-19 22:10:32
Subject: SVN Commit by andreas: r4456 - trunk/pgadmin3/src/include/images
Previous:From: Andreas PflugDate: 2005-09-19 14:38:43
Subject: Re: Slony scripts

pgadmin-support by date

Next:From: Lane Van IngenDate: 2005-09-19 21:01:40
Subject: Silent Install of pgAdmin3
Previous:From: Andreas PflugDate: 2005-09-19 14:44:24
Subject: Re: HELP - Recover function delete

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