Rao,
>ERROR: Unable to find static method com.test.HelloWorld.getName with
>signature (Lorg/postgresql/pljava/TriggerData;)V
>
>
>The function is working fine if I execute as ordinary function ,I mean
>without trigger.
>Create function tgfun() returns varchar as 'com.test.HelloWorld.getName'
>language java;
>
>
PL/Java requires that all trigger functions take a
org.postgresql.pljava.TriggerData argument. So your method must look
something like this:
public static void getName(TriggerData td)
{
}
Regards,
Thomas Hallgren