Precision modifier for time-types displayed incorrectly

Поиск
Список
Период
Сортировка
От Erwin Brandstetter
Тема Precision modifier for time-types displayed incorrectly
Дата
Msg-id 45772768.3080306@falter.at
обсуждение исходный текст
Ответы Re: Precision modifier for time-types displayed  (Dave Page <dpage@postgresql.org>)
Список 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
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


В списке pgadmin-support по дате отправления:

Предыдущее
От: Erwin Brandstetter
Дата:
Сообщение: Comments cut off after line break
Следующее
От: Dave Page
Дата:
Сообщение: Re: Comments cut off after line break