Re: Schema + User-Defined Data Type Indexing problems...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cgg007(at)yahoo(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Schema + User-Defined Data Type Indexing problems...
Date: 2004-06-10 15:40:58
Message-ID: 25094.1086882058@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Chris Gamache <cgg007(at)yahoo(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Franco Bruno Borghesi 2004-06-10 15:45:45 Re: query optimization
Previous Message Richard Huxton 2004-06-10 15:38:42 Re: Function returns error