Re: Parse error help needed...

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(at)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(at)wireboard(dot)com] On Behalf Of Doug
McNaught
Sent: Monday, January 12, 2004 4:44 PM
To: Thapliyal, Deepak
Cc: 'pgsql-general(at)postgresql(dot)org'
Subject: Re: [GENERAL] Parse error help needed...

"Thapliyal, Deepak" <dthapliyal(at)soe(dot)sony(dot)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