Horton

Re: BUG #14706: Dependencies not recorded properly for base types

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: khuddleston@pivotal.io
Cc: pgsql-bugs@postgresql.org
Date: 2017-06-15T00:42:16Z
Lists: pgsql-bugs 
khuddleston@pivotal.io writes:
> CREATE FUNCTION base_fn_in(cstring) returns opaque as 'boolin' language
> internal;
> CREATE FUNCTION base_fn_out(opaque) returns opaque as 'boolout' language
> internal;
> CREATE TYPE base_type(input=base_fn_in, output=base_fn_out);

You realize of course that this is long-deprecated style.

> DROP TYPE base_type;
> \df
> ERROR:  cache lookup failed for type 22241 (format_type.c:137)

... but yeah, as long as we're supporting it at all, that shouldn't
happen.  Thanks for the report!

			regards, tom lane

Commits

  1. Fix dependency, when changing a function's argument/return type.