| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | werner(dot)fraga(at)computalog(dot)com |
| Cc: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] problems creating functions and triggers |
| Date: | 2000-01-11 00:40:16 |
| Message-ID: | 7468.947551216@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Werner Fraga <werner(dot)fraga(at)computalog(dot)com> writes:
> 1. I noticed that some examples show the LANGUAGE in the CREATE FUNCTION
> command can be 'plpgsql'. However, if I try using this instead of 'sql', I get
> ERROR: Unrecognized language specified in a CREATE FUNCTION ...
You need to run the "createlang" script to install plpgsql in the
particular database you are using.
If you want plpgsql to be available by default in a given installation,
you can install it in template1 --- subsequently created DBs will be
clones of template1.
> 3. Is there anywhere I can find a list of the system tables? (that section in
> Bruce's book is still empty...)
\dS in psql...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2000-01-11 13:26:42 | Re: [SQL] createdb -D xxxx not working |
| Previous Message | Werner Fraga | 2000-01-10 22:32:19 | problems creating functions and triggers |