| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | Carlos Moreno <moreno(at)mochima(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Question on triggers and plpgsql |
| Date: | 2005-04-08 12:28:42 |
| Message-ID: | BE1E8DAA-A829-11D9-9125-000A95B03262@pgedit.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Fradkin | 2005-04-08 13:29:13 | getting count for a specific querry |
| Previous Message | Dinesh Pandey | 2005-04-08 04:52:14 | Re: Table PARTITION |