Re: [BUGS] ERROR: invalid INTERVAL typmod: 0xc

#1

Darcy Buskermolen <darcy (AT) wavefire (DOT) com> writes:

Quote:

The following query works in 7.3 but errors in 7.4.x as well as devel with
the above error

SELECT quote_ident(nspname) as namespace, format_type(pg_type.oid, typlen) as
type_name FROM pg_catalog.pg_type JOIN pg_catalog.pg_namespace ON
(pg_namespace.oid = typnamespace) WHERE pg_type.oid = '1186';

It's mere chance if it worked in 7.3. The second argument of
format_type is supposed to be atttypmod, not typlen. In this case
it seems you don't have any particular typmod available, so pass
NULL (or -1).

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] ERROR: invalid INTERVAL typmod: 0xc

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] ERROR: invalid INTERVAL typmod: 0xc - 01-28-2004 , 04:53 PM