From: Eric.Boyer at insa-toulouse.fr (Eric BOYER)
Date: Tue, 11 Apr 2006 12:06:33 +0200
Subject: [Pljava-dev] Reload postgres
Message-ID: <443B7FA9.8070401@insa-toulouse.fr>

Hello,

I would like to don't have to restart postgres every times I change the 
class launched ...

I use :
select 
sqlj.install_jar('file:///usr/local/aladin/jars/trigger_exploitation.jar','aladin',true);
select sqlj.set_classpath('exploitation','aladin');
or
select 
sqlj.replace_jar('file:///usr/local/aladin/jars/trigger_exploitation.jar','aladin',true);

the content of the jar is :
     0 Tue Apr 11 11:47:54 CEST 2006 META-INF/
   174 Tue Apr 11 11:47:52 CEST 2006 META-INF/MANIFEST.MF
     0 Tue Apr 11 11:17:24 CEST 2006 deployment/
   628 Tue Apr 11 11:17:24 CEST 2006 deployment/triggerExpl.ddr
    89 Mon Apr 10 10:52:50 CEST 2006 deployment/triggerExpl.manifest
     0 Mon Apr 10 15:35:22 CEST 2006 fr/
     0 Mon Apr 10 15:35:22 CEST 2006 fr/insat/
     0 Mon Apr 10 15:35:26 CEST 2006 fr/insat/aladin/
     0 Mon Apr 10 15:35:24 CEST 2006 fr/insat/aladin/service/
   600 Tue Apr 11 11:47:50 CEST 2006 
fr/insat/aladin/service/TriggerClient$1.class
 11658 Tue Apr 11 11:47:50 CEST 2006 
fr/insat/aladin/service/TriggerClient.class


When I change TriggerClient.java, I have to restart postgres !

What do I have to do for only use sqlj.replace_jar ?

Thanks,
Eric.

PS
My ddr is :
SQLActions[ ] = {
        "BEGIN INSTALL

         CREATE FUNCTION exploitation.alloTrigger()
                        RETURNS trigger
                        AS 'fr.insat.aladin.service.TriggerClient.traiter'
                        LANGUAGE javaU;
       
        CREATE TRIGGER trigCategorie
                        AFTER INSERT OR UPDATE OR DELETE ON 
exploitation.categorie
                        FOR EACH ROW
                        EXECUTE PROCEDURE exploitation.alloTrigger ();
        END INSTALL",                   

        "BEGIN REMOVE               
                DROP FUNCTION exploitation.alloTrigger() CASCADE;
        END REMOVE"           
        }

I really need javaU.