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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED] On Behalf Of Doug McNaught Sent: Monday, January 12, 2004 4:44 PM To: Thapliyal, Deepak Cc: '[EMAIL PROTECTED]' Subject: Re: [GENERAL] Parse error help needed... "Thapliyal, Deepak" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend