Re: Shadowing type names because I am not smart

On Wed, 2026-07-29 at 22:19 +0000, PG Doc comments form wrote:
> When playing around, I accidentally created a composite type called "text",
> and this caused all kinds of trouble that took a while for me to sort out.
> (Some GUI clients really don't behave nicely in this situation.)  Even after
> I realized what I'd done, I found that it behaved in strange ways that
> differed from user type names which shadow other built-in type names.

I'd say that's a problem of the schema search path: the system schema
pg_catalog is *always* on "search_path", and by default at the beginning.

To access your custom created type, you'd have to schema-qualify it:

DROP TYPE public.text;

Yours,
Laurenz Albe