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
timestampwith time zone, tx0 timestamp(0) with time zone, tx1 timestamp(1) with time zone, tx6 timestamp(6)
withtime 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
withouttime zone(-3), tz6 timestamp without time zone(2), tx timestamp with time zone, tx0 timestamp with
timezone(-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