pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedInstalling pgplsql on postgresql ver. 7.4 on os x 10.3
2+ messages / 2 participants
[nested] [flat]
* Installing pgplsql on postgresql ver. 7.4 on os x 10.3
@ 2003-12-29 15:13 beyaRecords - The home Urban music <uzo@beya-records.com>
2003-12-29 19:28 ` Re: Installing pgplsql on postgresql ver. 7.4 on os x 10.3 Michael Fuhr <mike@fuhr.org>
0 siblings, 1 reply; 2+ messages in thread
From: beyaRecords - The home Urban music @ 2003-12-29 15:13 UTC (permalink / raw)
To: pgsql-sql
HI,
after my initial message yesterday asking how to use stored procedures
in postgresql, it has become clear to me that I need to run a script
called createlang to install pgplsql into template 1 database.
I am running postgresql 7.4 on os x 10.3. Postgresql is situated in
directory /usr/local/pgsql. I have been unable to locate the createlang
script so my question is how do I intsall pgplsql on version 7.4 on OS
X 10.3?
regards
Uzo
On 29 Dec 2003, at 02:02, Christopher Browne wrote:
> uzo@beya-records.com (beyaRecords - The home Urban music) wrote:
>> I am new to this list and the world of postgreSQL, and would like to
>> know how create stored procedures in postgreSQL.
>
> Have you considered looking at the documentation?
>
> It is fairly well documented there.
>
> % man "CREATE FUNCTION"
>
> is quite likely to provide you with the documentation you require.
> --
> If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne; rate me
> http://www3.sympatico.ca/cbbrowne/postgresql.html
> "We have no need to punish Pascal programmers. Pascal programming,
> like chastity, is its own punishment. The only way I could imagine to
> make their wretched state any worse would be to make them use Ada."
> -- Scott Fahlman
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Installing pgplsql on postgresql ver. 7.4 on os x 10.3
2003-12-29 15:13 Installing pgplsql on postgresql ver. 7.4 on os x 10.3 beyaRecords - The home Urban music <uzo@beya-records.com>
@ 2003-12-29 19:28 ` Michael Fuhr <mike@fuhr.org>
0 siblings, 0 replies; 2+ messages in thread
From: Michael Fuhr @ 2003-12-29 19:28 UTC (permalink / raw)
To: beyaRecords - The home Urban music <uzo@beya-records.com>; +Cc: pgsql-sql
On Mon, Dec 29, 2003 at 03:13:56PM +0000, beyaRecords - The home Urban music wrote:
>
> after my initial message yesterday asking how to use stored procedures
> in postgresql, it has become clear to me that I need to run a script
> called createlang to install pgplsql into template 1 database.
createlang is a compiled program, not a script.
Whether you need to install plpgsql in template1 or not depends on
what you want to do: if you want all databases created in the future to
automatically have plpgsql, then it makes sense to create the language
in template1. If you want only certain databases to have plpgsql, then
you might want to create the language in only those databases but not
in template1. I'm assuming (possibly incorrectly) that you're using
template1 for its intended purpose (database template) and not for
any work.
> I am running postgresql 7.4 on os x 10.3. Postgresql is situated in
> directory /usr/local/pgsql. I have been unable to locate the createlang
> script so my question is how do I intsall pgplsql on version 7.4 on OS
> X 10.3?
You could mess around with CREATE LANGUAGE but createlang is easier.
Where have you looked for createlang? It's typically installed in
the same directory as the other PostgreSQL programs (psql, createdb,
etc.). If not, then try running something like "locate createlang"
or "find / -name createlang" to see if you can find it. It would be
odd for a PostgreSQL installation to be missing some of its utilities,
so I'm guessing it's there somewhere.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-12-29 19:28 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-29 15:13 Installing pgplsql on postgresql ver. 7.4 on os x 10.3 beyaRecords - The home Urban music <uzo@beya-records.com>
2003-12-29 19:28 ` Michael Fuhr <mike@fuhr.org>
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