On Thu, May 24, 2001 at 10:07:32AM +0530, Binand Raj S. wrote:
>>>>>> "Rajesh" == Rajesh Fowkar <[EMAIL PROTECTED]> writes:
>
> Rajesh> rajesh=# \i plpgsql.sql psql:plpgsql.sql:5: ERROR:
> Rajesh> Relation 'emp' already exists
>
>That is because you have been running this code many times, the table
>emp was created the first time you ran the code. While debugging, put
>DROP TABLE emp; at the top of the sql file.
That is ok. It is not an error. I should have removed that part from the
mail :-)
>
> Rajesh> Unrecognized language specified in a CREATE FUNCTION:
> Rajesh> 'plpgsql'. Recognized languages are sql, C, internal and
> Rajesh> the created procedural languages.
>
>LANGUAGE is sql, not plpgsql. The error clearly says so.
The message clearly says that. But the example which I have used is
directly from the Postgres manuals. And there they say it is LANGUAGE
'plpgsql', in fact that is correct. It is Procedural Language of Postgres
SQL for Stored Procedures in Database along with triggers.
After looking at the error message, I even tried using LANGUAGE 'sql' but
the same error.
Anyway Binand, thanks a lot.
Warm Regards
--
Rajesh Fowkar
V. S. DEMPO & CO. LTD., PANAJI-GOA
Email ID : [EMAIL PROTECTED], [EMAIL PROTECTED]
Web Site : http://www.dempos.com
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/linux-india-help
