>>>>> "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.

    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.

Binand

_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/linux-india-help

Reply via email to