Re: [HACKERS] Broken Catalog? -- 7.4.2

2004-04-27 Thread Rod Taylor
On Mon, 2004-04-26 at 22:04, Alvaro Herrera wrote: On Mon, Apr 26, 2004 at 09:36:26PM -0400, Rod Taylor wrote: The function format_type() fails only for interval when used on the interval type template1=# select format_type(oid, typlen) from pg_type; select format_type(oid, typtypmod)

[HACKERS] Broken Catalog? -- 7.4.2

2004-04-26 Thread Rod Taylor
The function format_type() fails only for interval when used on the interval type template1=# select format_type(oid, typlen) from pg_type; ERROR: invalid INTERVAL typmod: 0xc template1=# select format_type(oid, typlen) from pg_type where typname != 'interval'; -- Many results

Re: [HACKERS] Broken Catalog? -- 7.4.2

2004-04-26 Thread Alvaro Herrera
On Mon, Apr 26, 2004 at 09:36:26PM -0400, Rod Taylor wrote: The function format_type() fails only for interval when used on the interval type template1=# select format_type(oid, typlen) from pg_type; select format_type(oid, typtypmod) from pg_type; -- works In fact, I believe this is the