Bug Report: Length incorrectly specified when creating columns of 'time without time zone'

From: Ronny Kurniawan <ronny3710(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Bug Report: Length incorrectly specified when creating columns of 'time without time zone'
Date: 2014-11-25 08:18:04
Message-ID: CAJdaHbMPATRDtGTS05ScmDt-JJe5oH_cMmtT9kX4xhTbeq2v0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

pgAdmin version: 1.18.1
OS: Windows 7 SP1 x64

Bug:
adding a column type 'time without time zone' with length will produce
invalid sql syntax:
e.g:

ALTER TABLE mytable
ADD COLUMN mytimecolumn time without time zone(4);

it should've produce this sql statement:

ALTER TABLE mytable
ADD COLUMN mytimecolumn time(4) without time zone;

Browse pgadmin-support by date

  From Date Subject
Next Message Akshay Joshi 2014-11-25 09:27:24 Re: [pgadmin-hackers] potential invalid input field of pgAdmin New Column GUI
Previous Message Sanket Mehta 2014-11-24 11:48:00 Re: [pgadmin-hackers] potential invalid input field of pgAdmin New Column GUI