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

Re: New feature request

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Gino Lucrezi <gino-pgadmin(at)lucrezi(dot)net>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: New feature request
Date: 2004-11-26 17:55:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Gino Lucrezi wrote:
> Hi!
> There are some instances when one can't simply REPLACE an object (e.g. a view) but has to DROP it and then re-CREATE it.When I click on the SQL button pgAdmin, very considerately, will create for me not only a script with the CREATE command, but also with the DROP command (commented) before it.
> The problem arises if there are objects which depend on the object being DROPped and reCREATEd. Obviously, that script is no longer good. One must first DROP all depending objects, drop the main object, recreate it, and then recreate depending objects.
> It would be really nice if there were an option to create a SQL script doing all this ;-)

In most cases, the property dialogs will make the changes for you. The 
reengineered SQL window shows the CREATE command only, and doesn't try 
to cope with changes.
We will add some dependency recreation stuff for ALTER COLUMN for 7.3 
and 7.4 servers, but probably not more.


In response to

pgadmin-support by date

Next:From: Dave PageDate: 2004-11-26 20:40:32
Subject: Re: Installation problem with RC2
Previous:From: Gino LucreziDate: 2004-11-26 11:57:17
Subject: New feature request

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