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

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to make the user-defined function or type being accessed in the global database server?
Date: 2011-02-20 04:16:11
Message-ID: 4D60958B.20700@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2011-02-20 04:30:38 Re: Mac OSX 10.6 libpq.5.dylib
Previous Message 页公倒龙 2011-02-20 01:57:11 How to make the user-defined function or type being accessed in the global database server?