On Thu, Aug 23, 2012 at 7:19 AM, Timon <timo...@gmail.com> wrote: > 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
I can't find the references in the archives (I'm sure this has come up before), but iirc, we intentionally didn't do this as it wouldn't be clear to the user that despite they might be about to cause a huge write. I'm sure there was more to it than that, but my Google-fu is failing me at the moment. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
