Postgres Pro
Downloads
Home   >   mailing lists

Bug Report: Length incorrectly specified when creating columns of 'time without time zone' - Mailing list pgadmin-support

From Ronny Kurniawan
Subject Bug Report: Length incorrectly specified when creating columns of 'time without time zone'
Date
Msg-id CAJdaHbMPATRDtGTS05ScmDt-JJe5oH_cMmtT9kX4xhTbeq2v0A@mail.gmail.com
Whole thread Raw
List pgadmin-support
Tree view
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;

pgadmin-support by date:

Previous
From: Sanket Mehta
Date:
Subject: Re: [pgadmin-hackers] potential invalid input field of pgAdmin New Column GUI
Next
From: Akshay Joshi
Date:
Subject: Re: [pgadmin-hackers] potential invalid input field of pgAdmin New Column GUI