Обсуждение: 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'

От
Ronny Kurniawan
Дата:
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;