The following bug has been logged online:

Bug reference: 1010
Logged by: Jeff Davis
Email address: pg (AT) xarg (DOT) net
PostgreSQL version: 7.4
Operating system: Linux, Mac OS X 10.3
Description: format_type errors oin formatting type interval.
Details:

head=# select version();
version
--------------------------------------------------------
PostgreSQL 7.4 on powerpc-apple-darwin7.0.0, compiled by GCC gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build 1495)

head=# select pg_catalog.format_type(oid, typlen) from pg_type where typname = 'interval';
ERROR: invalid INTERVAL typmod: 0xc

Same error on linux. Does not happen on 7.3.4.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
This is not a bug. format_type's second arg is typmod, not typlen.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org