Postgres Pro
Downloads
Home   >   mailing lists

Thread: Precision modifier in multi-word field types

Precision modifier in multi-word field types

From
Erwin Brandstetter
Date:
Hi developers! Hi Dave!

Testing pgAdmin III v1.6.3 rev: 6112, client Win XP, host: Debian Sarge, 
PG 8.1.8.

It looks like an old bug has found its way back in. A snapshot from the 
SQL query dialogue:
   CREATE TABLE termin   (     beginn timestamp(0 without time zone,     ...   )

Note the missing closing bracket! Might be related to that one (quote 
from pgadmin.org/development/changelog.php):

2006-12-07 DP  1.6.2  Reverse engineer columns with multi-word names (like                     'timestamp with
timezone')correctly so that precision                     and array modifiers are included properly. Per Erwin.
 



Regards
Erwin

Re: Precision modifier in multi-word field types

From
Dave Page
Date:
Erwin Brandstetter wrote:
> Hi developers! Hi Dave!
> 
> Testing pgAdmin III v1.6.3 rev: 6112, client Win XP, host: Debian Sarge, 
> PG 8.1.8.
> 
> It looks like an old bug has found its way back in. A snapshot from the 
> SQL query dialogue:
> 
>    CREATE TABLE termin
>    (
>      beginn timestamp(0 without time zone,
>      ...
>    )
> 
> Note the missing closing bracket! Might be related to that one (quote 
> from pgadmin.org/development/changelog.php):

Related, but not the same. Fixed, thanks :-)

/D