On 05/19/2017 01:06 PM, Micky Hulse wrote:
> ERROR: type "xxx_xxx_xxxxx" does not exist
> LINE 1: DECLARE results xxx_xxx_xxxxx;
It sounds like the type might be in a different schema. You can say \dn
to see the schemas in your database, and \dT+ will show the types along
with their schema. You could also do \dT+ foo.* to see all the types in
schema foo.
If you find that the type isn't in the public schema, try setting your
schema search path so that the function can locate it, e.g.:
SET search_path TO foo, public;
Good luck!
Paul