Chris Gamache <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster