Thx to doug ... Old error is gone .. But I am now getting new error
postgres=# \i a.sql
psql:a.sql:10: ERROR: language "plpgsql" does not exist
But I verified that I setup plpgsql
[postgres@node1]~$ createlang -d test -l
Procedural languages
Name | Trusted?
---------+----------
plpgsql | t
(1 row)
Can u pls advice if u know whats going on.. Am I missing somin obvious here.
..
Thx in advance
Deep
-----Original Message-----
From: Doug McNaught,,, [mailto:doug@wireboard.com] On Behalf Of Doug
McNaught
Sent: Monday, January 12, 2004 4:44 PM
To: Thapliyal, Deepak
Cc: 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] Parse error help needed...
"Thapliyal, Deepak" <dthapliyal@soe.sony.com> writes:
> I am getting this error
>
> postgres=# \i a.sql
> psql:a.sql:10: ERROR: parser: parse error at or near "return" at
> character 26
> create function loadme() return text as '
^^^^^^
I think you want "returns" here.
-Doug
