Re: Question on triggers and plpgsql

On Apr 7, 2005, at 5:45 PM, Carlos Moreno wrote:

> The thing seems to work -- I had to go in a shell as user
> postgres and execute the command:
>
> $ createlang -d dbname plpgsql
>
> (I'm not sure I understand why that is necessary, or
> what implications -- positive or negative -- it may have)

As a security measure, no pl language is available by default. What you 
did is correct. There is not much (any?) risk with pl/pgsql, so you can 
install it in template1 so it will be available in any new database you 
create.

>
> Am I doing the right thing?  Have I introduced some sort
> of catastrophe waiting to happen?

I did not notice any problems.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL