Re: [GENERAL] createlang and Schemas

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Justin Clift <justin(at)postgresql(dot)org>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] createlang and Schemas
Date: 2003-02-14 14:41:34
Message-ID: 200302141441.h1EEfYL07404@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Added to TODO:

* Add schema option to createlang

---------------------------------------------------------------------------

Justin Clift wrote:
> Bruce Momjian wrote:
> > Is this a TODO? Not sure.
>
> Is this a mis-feature (not really a bug) that should be fixed in 7.3.2?
>
> Regards and best wishes,
>
> Justin Clift
>
> > ---------------------------------------------------------------------------
> >
> > Tom Lane wrote:
> >
> >>"Ian Harding" <ianh(at)tpchd(dot)org> writes:
> >>
> >>>createlang seems not to take a schema argument. Should it?
> >>
> >>Hm. The language itself does not have any associated schema --- but the
> >>underlying call handler function does. Perhaps there should be a way to
> >>tell createlang which schema to put the function in. Right now it will
> >>be effectively determined by the default search path, so you could do
> >>
> >> PGOPTIONS='--search_path=myschema' createlang plpgsql mydb
> >>
> >>but this seems inelegant.
> >>
> >> regards, tom lane
> >>
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 5: Have you checked our extensive FAQ?
> >>
> >>http://www.postgresql.org/users-lounge/docs/faq.html
> >>
> >
> >
>
>
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
> - Indira Gandhi
>
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Hanak 2003-02-14 14:46:15 Problems with insert rule called from plpython
Previous Message Bruce Momjian 2003-02-14 14:40:27 Re: location of the configuration files