Обсуждение: New feature request
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.WhenI 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 isno longer good. One must first DROP all depending objects, drop the main object, recreate it, and then recreate dependingobjects. It would be really nice if there were an option to create a SQL script doing all this ;-) I hope my request was clear enough... Anyway, thank you for giving us this good piece of software! Gino Lucrezi Penta Consulting Service
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.WhenI 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 scriptis no longer good. One must first DROP all depending objects, drop the main object, recreate it, and then recreatedepending 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. Regards, Andreas
> 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. So if I upgrade the underlying database from postgreSQL 7.3 to 8.0 I won't have to DROP and re-CREATE tables and/or viewsso often? That would be very good! Unfortunately I only have experience with 7.3 Thank you for the hint Gino Lucrezi Penta Consulting Services Srl
Gino Lucrezi wrote: >>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. > > > So if I upgrade the underlying database from postgreSQL 7.3 to 8.0 I won't have to DROP and re-CREATE tables and/or viewsso often? There have been many improvements, adding many ALTER <dbobject> commands in 7.4 and 8.0, makink life a lot easier. Regards, Andreas