Query execution order

From: Miha Radej <miha(dot)radej(at)siix(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Query execution order
Date: 2003-12-16 12:33:05
Message-ID: 6.0.0.14.0.20031216132427.027141b0@mail.over.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi!

I've been playing a bit with my frinends' tables and I wanted to remove an
existing unique constraint and add a primary key with the same name.
However, instead of first removing an existing constraint and then adding a
new one, I added the primary key and then deleted the unique constraint.
When I hit OK I got a pgsql error, telling me that a relation with that
name already exists.

The SQL tag had these queries:
ALTER TABLE uporabniki ADD CONSTRAINT uporabniki_primary_key_key PRIMARY
KEY (primary_key);
ALTER TABLE uporabniki DROP CONSTRAINT uporabniki_primary_key_key;

Is it possible for pgAdmin to reorder the queries so that the drop queries
are first and all the rest follow? Or if it could at least check for
existing constraint names?

Thanks and best regards,
Miha

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Andreas Pflug 2003-12-16 13:05:56 Re: Query execution order
Previous Message Adam H.Pendleton 2003-12-14 01:50:41 Re: building wxPython on OS X