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

Reply via email to