Precision modifier for time-types displayed incorrectly

From: Erwin Brandstetter <brandstetter(at)falter(dot)at>
To: pgadmin-support(at)postgresql(dot)org
Subject: Precision modifier for time-types displayed incorrectly
Date: 2006-12-06 20:26:16
Message-ID: 45772768.3080306@falter.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi developers! Hi Dave!

Testing pgAdmin III v1.6.1 rev: 5709, client Win XP. Host Debian Sarge,
PG 8.1.4.

The data types "timestamp" and "time" (with or without time zone) with
precision modifiers are displayed incorrectly.
Notably, the data type interval seems not to be affected.
I have created a test case that should speak for itself:

This is how I create the table:

CREATE TABLE test
(
tz timestamp,
tz0 timestamp(0),
tz1 timestamp(1),
tz6 timestamp(6),
tx timestamp with time zone,
tx0 timestamp(0) with time zone,
tx1 timestamp(1) with time zone,
tx6 timestamp(6) with time zone,
i interval,
i0 interval(0),
i1 interval(1),
i6 interval(6),
t time,
t0 time(0),
t1 time(1),
t6 time(6),
ty time with time zone,
ty0 time(0) with time zone,
ty1 time(1) with time zone,
ty6 time(6) with time zone
)
WITHOUT OIDS;

This is what pgAdmin displays in the object browser:

CREATE TABLE test
(
tz timestamp without time zone,
tz0 timestamp without time zone(-4),
tz1 timestamp without time zone(-3),
tz6 timestamp without time zone(2),
tx timestamp with time zone,
tx0 timestamp with time zone(-4),
tx1 timestamp with time zone(-3),
tx6 timestamp with time zone(2),
i interval,
i0 interval(0),
i1 interval(1),
i6 interval(6),
t time without time zone,
t0 time without time zone(-4),
t1 time without time zone(-3),
t6 time without time zone(2),
ty time with time zone,
ty0 time with time zone(-4),
ty1 time with time zone(-3),
ty6 time with time zone(2)
)
WITHOUT OIDS;

Trying to execute this fails with a syntax error, of course.

Regards
Erwin

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2006-12-07 08:44:19 Re: Comments cut off after line break
Previous Message Erwin Brandstetter 2006-12-06 19:26:57 Comments cut off after line break