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
