Re: How to make the user-defined function or type being accessed in the global database server? - Mailing list pgsql-general

From John R Pierce
Subject Re: How to make the user-defined function or type being accessed in the global database server?
Date
Msg-id 4D60958B.20700@hogranch.com
Whole thread Raw
In response to How to make the user-defined function or type being accessed in the global database server?  ("页公倒龙" <77287991@qq.com>)
List pgsql-general
On 02/19/11 5:57 PM, 页公倒龙 wrote:
> hello, i had defined user-defined function and type in database A by
> using user Root.when i want to access the function and type in another
> database B by using the same user Root, but found that i could't
> access them. How to make the user-defined function or type being
> accessed in the global database server?
>
> I look forward to hearing from you again soon.
>

functions are only defined in the context of the database you define
them in. you'll need to add your function to any database you want to
use it in.




pgsql-general by date:

Previous
From: PANAGIOTIS GERMANIS
Date:
Subject: Mac OSX 10.6 libpq.5.dylib
Next
From: Scott Ribe
Date:
Subject: Re: Mac OSX 10.6 libpq.5.dylib