On Fri, Mar 7, 2008 at 10:30 AM, Laurent ROCHE <[EMAIL PROTECTED]> wrote:
>
> So I would suggest to generate the code:
> ALTER TABLE my_table ADD COLUMN my_col boolean NOT NULL DEFAULT false;
It actually does do this already if you add the column through the
table dialogue. I've fixed the column d
Hi,
Laurent ROCHE wrote:
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 bo
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 ALT
