Thread: improvement for version after the current one...
hello,
pg_admin is creating the SQL for creating / dropping various database objects.
I suggest that the DROP SQL is extended by "IF EXISTS" on objects that support "if exists"
-- DROP TABLE otpflichtfeld;
the SQL in that pane would be
-- DROP TABLE IF EXISTS otpflichtfeld;
best wishes
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
LASIK good, steroids bad?
pg_admin is creating the SQL for creating / dropping various database objects.
I suggest that the DROP SQL is extended by "IF EXISTS" on objects that support "if exists"
-- DROP TABLE otpflichtfeld;
the SQL in that pane would be
-- DROP TABLE IF EXISTS otpflichtfeld;
best wishes
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
LASIK good, steroids bad?
> I suggest that the DROP SQL is extended by "IF EXISTS" on objects that
yes, it does exist. In the database I am connected to. One rather common situation is to have more then one database of the "same" content - staging / production, customer 1 / customer2; version 3 / version 4.
And the obligation to exchange DML from one to the other. Copying the SQL from pgadmin, collecting it in files and mailing them as DB-service-packs to other places ... where the object may or may not exist. Or also developing within the TEST-database with PGADMIN and copying the DML to files to put in RCS.
"DROP IF EXISTS" does work; "DROP" raises an error which has to be dealt with. That dealing is in 90% usage "go on", as the next command usually is to create that object.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
LASIK good, steroids bad?
> support "if exists"Why? If pgAdmin is emitting 'DROP TABLE foo', that is because foo exists.
>
And the obligation to exchange DML from one to the other. Copying the SQL from pgadmin, collecting it in files and mailing them as DB-service-packs to other places ... where the object may or may not exist. Or also developing within the TEST-database with PGADMIN and copying the DML to files to put in RCS.
"DROP IF EXISTS" does work; "DROP" raises an error which has to be dealt with. That dealing is in 90% usage "go on", as the next command usually is to create that object.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
LASIK good, steroids bad?