Re: installing pl/pgsql
От | Emmanuel SARACCO |
---|---|
Тема | Re: installing pl/pgsql |
Дата | |
Msg-id | 1011294362.485.279.camel@sartre обсуждение исходный текст |
Ответ на | installing pl/pgsql ("Johnson, Shaunn" <SJohnson6@bcbsm.com>) |
Список | pgsql-general |
hi, just do a "createlang plpgsql YOURDB" bye le jeu 17-01-2002 à 18:22, Johnson, Shaunn a écrit : > Howdy: > > I'm running Postgres 7.1.3 on Mandrake Linux 8.0, kernel > version 2.4.16. > > I'm reading through a bit of documentation regarding pl/pgsql > and I don't see too much about it. As for installing it, the > documentation says, 'by default, it's there', but how can I > tell? > > I thought I'd try this as an example: > > [snip] > > CREATE FUNCTION a_function () RETURNS int4 AS ' > DECLARE > an_integer int4; > BEGIN > an_integer := 10 * 10; > return an_integer; > END; > ' LANGUAGE 'plpgsql'; > > [/snip] > > But I get an error saying something about no such language, > use C, sql, etc ... > > Now, having said all of that ... > > I would like to install it, but I'm not sure what the ramifications > are. (Should I stop and restart Postgres? How does this effect > the existing database / table? Should I install anything else > before / after this? Is it as straightforward as > http://www.postgressql.info/x5371.htm > makes it out to be?) > > Any suggestions or pointers would be appreciated > > TIA > > -X -- Emmanuel SARACCO Email: esaracco@noos.fr
Вложения
В списке pgsql-general по дате отправления: