From: | "Dave Page" <dpage(at)pgadmin(dot)org> |
---|---|
To: | "Adam Taft" <adam(at)adamtaft(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Timestamp Length or Precision Bug |
Date: | 2008-02-08 14:17:00 |
Message-ID: | 937d27e10802080617g68be08bbv783381329251d0a4@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Feb 8, 2008 12:40 AM, Adam Taft <adam(at)adamtaft(dot)com> wrote:
> Hi,
>
> I've noticed this bug for quite a few versions of PgAdmin now. I was
> hoping that a bug reporting tool would someday appear on the website. I
> guess this is the best way to report the problem.
That is the correct method.
> When creating a 'timestamp without timezone' and specifying the 'length'
> parameter, invalid SQL is generated. The generated SQL is this:
>
> ALTER TABLE usertags ADD COLUMN a timestamp without time zone(3);
Thanks, fixed in SVN for 1.8.3.
> Additionally, the 'length' field is used in the PgAdmin UI, whereas in
> the PostgreSQL documention, the field is referred to as 'precision.'
> I'm wondering if the Precision input box in the PgAdmin UI should be
> enabled instead of the Length input box.
I'm not so worried about that - everyone know what it means and it's
more than just a couple of lines of code to change it.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Taft | 2008-02-08 15:40:19 | Re: Timestamp Length or Precision Bug |
Previous Message | Adam Taft | 2008-02-08 00:40:58 | Timestamp Length or Precision Bug |