pl/pgSQL development environment

Поиск
Список
Период
Сортировка
Искать
От
Wm.A.Stafford
Тема
pl/pgSQL development environment
Дата
Msg-id
48975B24.1050502@marine.rutgers.edu
Список
Дерево обсуждения
pl/pgSQL development environment "Wm.A.Stafford" <stafford@marine.rutgers.edu>
Re: pl/pgSQL development environment Tom Lane <tgl@sss.pgh.pa.us>
Re: pl/pgSQL development environment "Charles N. Charotti" <ccharotti@yahoo.com>
Re: pl/pgSQL development environment "Richard Broersma" <richard.broersma@gmail.com>
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 по дате отправления
От: Frank Bax
Дата:
Сообщение: Re: OIDS question
От: Richard Broersma
Дата:
FAQ