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

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

From

Ronny Kurniawan

Date:

25 November 2014, 11:18:17

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;