In pgAdmin III v.1.14.1, if you navigate to
schemas/public/tables/<table>/Columns/<column> and right-click on the column
name and press "create script", you often get a script that will not execute.
The problem occurs when you have a column that has "NOT NULL" and a "DEFAULT"
property.
e.g. A script generated by pgadmin might be as follows:
-- Column: waged
-- ALTER TABLE custom_ccowa_kwc DROP COLUMN waged;
ALTER TABLE custom_ccowa_kwc ADD COLUMN waged2 integer;
ALTER TABLE custom_ccowa_kwc ALTER COLUMN waged2 SET NOT NULL;
ALTER TABLE custom_ccowa_kwc ALTER COLUMN waged2 SET DEFAULT 1;
But if you delete that column and insert the above text into the SQL editor
and press "Execute query". then you get the following error message:
ERROR: column "waged2" contains null values
********** Error **********
ERROR: column "waged2" contains null values
SQL state: 23502
Could pgAdmin please be modified to generate a script like this instead:
ALTER TABLE custom_ccowa_kwc ADD COLUMN waged2 integer NOT NULL DEFAULT 1;
Thanks for considering this, I couldn't find a similar bug report in the
archives.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support