X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EC155D1B37C for ; Thu, 10 Jun 2004 12:41:01 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78476-09 for ; Thu, 10 Jun 2004 15:40:59 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 279F9D1B379 for ; Thu, 10 Jun 2004 12:40:59 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i5AFewRN025095; Thu, 10 Jun 2004 11:40:58 -0400 (EDT) To: cgg007@yahoo.com Cc: pgsql-sql@postgresql.org Subject: Re: Schema + User-Defined Data Type Indexing problems... In-reply-to: <20040610143454.13820.qmail@web13804.mail.yahoo.com> References: <20040610143454.13820.qmail@web13804.mail.yahoo.com> Comments: In-reply-to Chris Gamache message dated "Thu, 10 Jun 2004 07:34:54 -0700" Date: Thu, 10 Jun 2004 11:40:58 -0400 Message-ID: <25094.1086882058@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=MAILTO_TO_SPAM_ADDR X-Spam-Level: * X-Archive-Number: 200406/88 X-Sequence-Number: 18033 Chris Gamache 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