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@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