Re: Schema + User-Defined Data Type Indexing problems... - Mailing list pgsql-sql

Chris Gamache <cgg007@yahoo.com> writes:
> So, is the best-practice for the my_schema tables to reference the
> user-defined datatype in the "public" schema?

Not necessarily, but if you put it somewhere else you'll want to add
the somewhere else to your default search path (probably via ALTER
DATABASE).
        regards, tom lane