ok the complete error is:
----------------
NOTICE: plpgsql: ERROR during compile of add_one
near line 1
"RROR: parse error near "
----------------
I was trying to select the add_one function in the
documentation.
In the pg_language table I have entries for internal,
c, sql and plpgsql. The plpgsql record reads:
lanname = plpgsql
lanispl = t
lanpltrusted = t
pancallfoid = 19488
lancompiler = PL/pgSQL
the createlang statement I used was:
createlang plpgsql db_name -L /usr/local/pgsql/lib
this is on a new install of slackware 7.1
Culley
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Culley Harrelson <culleyharrelson@yahoo.com> writes:
> > I ran createlang successfully and I'm still
> getting
> > compile errors on basic plpgsql functions (sql
> > functions work).I'm assuming I have to do
> something
> > like:
>
> > create trusted procedural language plpgsql
> > handler = ????
>
> No, createlang should've done that for you.
>
> What do you get from "select * from pg_language" ?
>
> Also, it would help if you mentioned the exact error
> message
> you're getting.
>
> regards, tom lane
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/