Adding columns NOT NULL

Hi,

There is a little anomaly in the way adding an extra column is treated in pgAdmin III 1.8.2.
... particularly if this is a NOT NULL column.

When adding the column my_col with a DEFAULT value, the code generated will be:
ALTER TABLE my_table ADD COLUMN my_col boolean;
ALTER TABLE my_table ALTER COLUMN my_col SET DEFAULT false;

This works fine ... as long as I don't insert columns with NOT NULL property.
In which case, I SUPPOSE it generates:
ALTER TABLE my_table ADD COLUMN my_col boolean NOT NULL;
ALTER TABLE my_table ALTER COLUMN my_col SET DEFAULT false;

This will not work, because the column is created with no default (hence no values) and does not support NULL values, hence creation fails.

** In pgAdmin, adding an extra column with NOT NULL property is impossible ! **

So I would suggest to generate the code:
ALTER TABLE my_table ADD COLUMN my_col boolean NOT NULL DEFAULT false;

Which does work !
And that allows to create a column with not NULL values, in one operation, and more importantly with the column populated.
At the moment, to perform the same operation I have to
- create the column, with NULL values.
- update the table to populate the column
- modify the column to NOT NULL
... or write my-self the ALTER TABLE statement !

Cheers,
L(at)u
The Computing Froggy

_____________________________________________________________________________
Envoyez avec Yahoo! Mail. Une boite mail plus intelligente http://mail.yahoo.fr