[PATCH] Fix column SQL

From: Timon <timosha(at)gmail(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: [PATCH] Fix column SQL
Date: 2012-08-23 06:19:13
Message-ID: CAAeC-SswoeyJHdFpH+HQ60PCqtTgsoGdtxYnF=OWmk_L=vgCCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgadmin-support

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 Content-Type Size
0001-Fix-column-SQL.patch application/octet-stream 1.4 KB

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2012-08-23 08:18:16 Re: [PATCH] Fix column SQL
Previous Message Dave Page 2012-08-22 08:18:41 Re: 1.16b4 upgrade report

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2012-08-23 08:18:16 Re: [PATCH] Fix column SQL
Previous Message bimal kanta panda 2012-08-22 11:18:54 regarding opening of pgAdmin III