From: Subbiah, Stalin <SSubbiah@netopia.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: Schemas to Search_path
Date: Wed, 9 Mar 2005 17:21:05 -0800
Message-ID: <6B26A56846293C4488B54CF3E4403354339DF2@mxca2.corp.netopia.com> (raw)
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 ?
Thanks Much!
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, March 09, 2005 4:57 PM
To: Subbiah, Stalin
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Schemas to Search_path
"Subbiah, Stalin" <SSubbiah@netopia.com> writes:
> I logged into foodb as foo user and tried to create a table. Bang!
> ERROR: no schema has been selected to create in. search_path had
> $user, public the default ones, shouldn't the table get created in
> user's authorized schema.
Which one?
Now, if you make the schema name the same as the user name, it will do
what you want --- that's what the $user is for. If you want some other
schema that happens to belong to that user to be the default, you have
to adjust the normal value of search_path. (See ALTER USER SET if you'd
like that adjustment to be done for you automatically at each login.)
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: SSubbiah@netopia.com, tgl@sss.pgh.pa.us
Subject: Re: Schemas to Search_path
In-Reply-To: <6B26A56846293C4488B54CF3E4403354339DF2@mxca2.corp.netopia.com>
References: <6B26A56846293C4488B54CF3E4403354339DF2@mxca2.corp.netopia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox