X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 387C856527 for ; Thu, 10 Mar 2005 16:10:03 +0000 (GMT) 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 70095-04 for ; Thu, 10 Mar 2005 16:09:44 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id B9C77564B9 for ; Thu, 10 Mar 2005 16:09:44 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j2AG9h5Y070918 for ; Thu, 10 Mar 2005 16:09:44 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j2AFfhZY062610 for pgsql-admin@postgresql.org; Thu, 10 Mar 2005 15:41:44 GMT (envelope-from news) From: Edmund Bacon X-Newsgroups: pgsql.admin Subject: Re: Schemas to Search_path Date: 10 Mar 2005 08:41:48 -0700 Organization: Hub.Org Networking Services Lines: 17 Message-ID: References: <6B26A56846293C4488B54CF3E4403354339DF2@mxca2.corp.netopia.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.2 To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/199 X-Sequence-Number: 16697 SSubbiah@netopia.com ("Subbiah, Stalin") writes: > I created schema name "foo_schema" different from user name "foo". > However, when I created the schema, I had specified authorization set to > foo user. > > Does that mean, if the owner of the schema and schema name are > different, then only way, is to set through alter user set or search > path correct ? > There is also ALTER DATABASE foo SET search_path TO schema [, schema] ... > Thanks Much! -- Remove -42 for email