attached patch fixes SQL of column in SQL pane. sql should be like ALTER TABLE table ADD COLUMN tms timestamp without time zone NOT NULL DEFAULT now(); and not ALTER TABLE table ADD COLUMN tms timestamp without time zone; ALTER TABLE table ALTER COLUMN tms SET NOT NULL; ALTER TABLE table ALTER COLUMN tms SET DEFAULT now();
it avoids not null constraint problem when you add column to existing table with some data -- All bugs reserved
0001-Fix-column-SQL.patch
Description: Binary data
-- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
