pl/pgSQL development environment
От | Wm.A.Stafford |
---|---|
Тема | pl/pgSQL development environment |
Дата | |
Msg-id | 48975B24.1050502@marine.rutgers.edu обсуждение исходный текст |
Ответы |
Re: pl/pgSQL development environment
Re: pl/pgSQL development environment Re: pl/pgSQL development environment |
Список | pgsql-novice |
I have to convert a large number of Oracle pl/sql scripts to PostgreSQL 8.3 pl/pgSQL and I am stuck on the most basic part, how to do development with pl/pgSQL. First of all what is the development model for pl/pgSQL development, i.e. What is the 'industry standard' way edit, compile and test functions and procedures? I don't see any examples of a complete process in the documentation. I created the following simple function as a first try: CREATE OR REPLACE FUNCTION testfunc() RETURNS integer AS $$ BEGIN RAISE DEBUG 'Output from testfunc'; return 2 ; END ; $$ LANGUAGE plpgsql; Using both psql and pgADMINIII I was able to load and execute this and see 2 as the output but I did not see the output of the RAISE statement. The RAISE output was not in the log file either. Where does it go and can it be redirected to stdout? Since pl/pgSQL does not have packages, what is the usual way of managing groups of related functions and procedures. For example I have a group pl/sql procedures that call functions from a library. The library is one package. The procedures that use the library are in separate packages. Thanks for any help and/or guidance, Bill Stafford
В списке pgsql-novice по дате отправления: