I'm new to postgres and pgadmin3 (on Windows XP).
I've just tried to make a change to a table using pgAdmin3 (1.0.2) and I get:-
--------------------------- pgAdmin III --------------------------- An error has occured:
ERROR: adding columns with defaults is not implemented HINT: Add the column, then use ALTER TABLE SET DEFAULT.
--------------------------- OK ---------------------------
When will this be fixed? Is this the right forum for discussing unimplemented fuctions? Is there somewhere or someone specific to point is out with?
Chris,
This isn't a pgadmin bug--it is a limitation of Postgres. You can't add a column to a table *and* set a default value for it all in one statement. Try the hint that is given: add the column, then alter the column to set the default value. You can read the details of using the ALTER command in the Postgres online documentation.
Regards,
Bill Montgomery
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
