[PATCH] Fix column SQL - Mailing list pgadmin-hackers

From Timon
Subject [PATCH] Fix column SQL
Date
Msg-id CAAeC-SswoeyJHdFpH+HQ60PCqtTgsoGdtxYnF=OWmk_L=vgCCg@mail.gmail.com
Whole thread Raw
Responses Re: [PATCH] Fix column SQL  (Dave Page <dpage@pgadmin.org>)
List pgadmin-hackers
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

Attachment

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: 1.16b4 upgrade report
Next
From: Dave Page
Date:
Subject: Re: [PATCH] Fix column SQL