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'; 1186 ( the interval type) is the only row that this does not work for. -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
