That doesn't seem unreasonable. It should probably include a comment
in that case, explaining why there are two versions of the SQL.
On Thu, Aug 23, 2012 at 10:09 AM, Timon wrote:
> maybe we should show this script as comment in sql pane? like DROP column sql
>
> 2012/8/23 Dave Page :
>> On Thu,
maybe we should show this script as comment in sql pane? like DROP column sql
2012/8/23 Dave Page :
> On Thu, Aug 23, 2012 at 9:33 AM, Timon wrote:
>> I found it
>> http://archives.postgresql.org/pgadmin-support/2012-07/msg7.php
>
> Yeah, that was the most recent one (though, that was really
On Thu, Aug 23, 2012 at 7:19 AM, Timon 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 tabl
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 COLU