Here is my first post which missed the list. Not that it makes that
much of a difference now as all my points have been addressed by others.
raa
Himanshu Gupta wrote:
Hi,
I have multiple applications, i want to create separate schema for each
of the application. I dont want to change search
Sam Mason wrote:
On Wed, Sep 02, 2009 at 10:52:07AM -0400, Himanshu Gupta wrote:
Thanks for response, bit if I point it to all the schema, I am just
wondering how data insertion will work, I have multiple ables with
same name in these applications.
Do you know that you can schema qualify ta
On Wed, Sep 02, 2009 at 10:52:07AM -0400, Himanshu Gupta wrote:
> Thanks for response, bit if I point it to all the schema, I am just
> wondering how data insertion will work, I have multiple ables with
> same name in these applications.
Do you know that you can schema qualify table names don'
OOPS I got caught by the reply verses reply-all and only sent this to
Scott. Plus I see it has already been addressed in a later message.
raa
Scott Marlowe wrote:
So, can you just set search_path to point to all the schemas at once
then? Or does that not meet your needs?
The only issue I s
I want single user to see all the schema at once. Database server is
on client side and it takes time to get new user or new database
instance, So i am trying to find a workaround for that.
Thanks,
Himanshu
On Sep 1, 2009, at 6:04 PM, Scott Marlowe wrote:
On Tue, Sep 1, 2009 at 2:58 PM, Hi
Hi Scott,
Thanks for response, bit if I point it to all the schema, I am just
wondering how data insertion will work, I have multiple ables with
same name in these applications.
-HImanshu
On Sep 2, 2009, at 10:48 AM, Scott Marlowe wrote:
you just set search_path to point to all the sche
So, can you just set search_path to point to all the schemas at once
then? Or does that not meet your needs?
On Wed, Sep 2, 2009 at 7:19 AM, Himanshu
Gupta wrote:
> I want single user to see all the schema at once. Database server is on
> client side and it takes time to get new user or new datab
On Tue, Sep 1, 2009 at 2:58 PM, Himanshu
Gupta wrote:
> Hi,
>
> I have multiple applications, i want to create separate schema for each of
> the application. I dont want to change search path, since have only one
> user. I went through couple of post's talking about some patch related to
> that. I
Hi,
I have multiple applications, i want to create separate schema for
each of the application. I dont want to change search path, since
have only one user. I went through couple of post's talking about some
patch related to that. It seems that patch got rejected. Any help is
appreciated
