postgresql dump file

Bart
2005-06-01
2013-05-02
  • Bart

    Bart - 2005-06-01

    Hello Victor, Jonah et al
    will 2.5.2b have a new dump file?

    You may recall that I was installing Victors pkg on an OS/2 machine. It seems my problems stem from the dump file. To make it work with the OS/2 postgreSQL 8.0, at a minimum, any occurences of 'libpljava' have to changed to 'pljava'. I have a developer working on this, but it is volunteer work and slow in coming.

    Do you have any suggestions? Don't say "use linux" :-)

    Regards

    Bart

     
    • Bart

      Bart - 2005-06-01

      Sorry, forgot to ask, any users out there near Toronto?

      Bart

       
      • compiere.computing-business.com

        Bart,

        FYI, we are using Compiere and we are Compiere partner located in Toronto.

        Regards,
        S Poon

         
        • Bart

          Bart - 2005-06-07

          Hello S Poon

          do you have a web site?
          I would be interested in seeing your installation of compiere and discussing support options.
          email me at gen_mgr  at  cbm.on.ca

          Regards,
          Bart

           
    • Jonah H. Harris

      Jonah H. Harris - 2005-06-03

      Bart,

      Use Linux :).  Just kidding, OS/2 is cool.

      At this moment, I'm currently building a brand new Red Hat Enterprise Linux Advanced Server 4.0 VMWare system.  When I get it completed I'll get you a much cleaner PostgreSQL dump.  The system should be finished in an hour or so.  Give me a couple days to get CL installed and then I'll get you a nicer dump.

      It the problem solely with the loading of PL/Java into the database?  If so, I can probably get you a dump of the SQLJ schema that *may* work with OS/2.

      -Jonah

       
    • Bart

      Bart - 2005-06-03

      I can't wait to try it! I'll check your questions and reply here later.

      Regards

       
    • Bart

      Bart - 2005-06-03

      Hi Jonah,
      below thisparagrph  is what the programmer of the OS/2 port of postgresql & pljava said. Please let me know if there is anything you can do.

      quote:
      I believe the problems are strictly associated with the PLJava load.

      In OS/2 the library name is pljava.dll and the standard SQL for loading
      the language works OK

      ---------- start of SQL used in OS/2 -------------

      CREATE SCHEMA sqlj;
      GRANT USAGE ON SCHEMA sqlj TO public;
      CREATE FUNCTION sqlj.java_call_handler()
        RETURNS language_handler AS 'pljava'
        LANGUAGE C;
      CREATE TRUSTED LANGUAGE java HANDLER sqlj.java_call_handler;
      CREATE TABLE sqlj.jar_repository(
          jarId        SERIAL PRIMARY KEY,
          jarName        VARCHAR(100) UNIQUE NOT NULL,
          jarOrigin   VARCHAR(500) NOT NULL,
          deploymentDesc INT
      );
      GRANT SELECT ON sqlj.jar_repository TO public;
      CREATE TABLE sqlj.jar_entry(
          entryId     SERIAL PRIMARY KEY,
          entryName    VARCHAR(200) NOT NULL,
          jarId        INT NOT NULL REFERENCES sqlj.jar_repository ON DELETE CASCADE,
          entryImage  BYTEA NOT NULL,
          UNIQUE(jarId, entryName)
      );
      GRANT SELECT ON sqlj.jar_entry TO public;
      ALTER TABLE sqlj.jar_repository
         ADD FOREIGN KEY (deploymentDesc) REFERENCES sqlj.jar_entry ON DELETE
      SET NULL; CREATE TABLE sqlj.classpath_entry(
          schemaName    VARCHAR(30) NOT NULL,
          ordinal        INT2 NOT NULL,
          jarId        INT NOT NULL REFERENCES sqlj.jar_repository ON DELETE CASCADE,
          PRIMARY KEY(schemaName, ordinal)
      );
      GRANT SELECT ON sqlj.classpath_entry TO public;
      CREATE FUNCTION sqlj.install_jar(VARCHAR, VARCHAR, BOOLEAN) RETURNS void
          AS 'org.postgresql.pljava.management.Commands.installJar'
          LANGUAGE java SECURITY DEFINER;
      CREATE FUNCTION sqlj.replace_jar(VARCHAR, VARCHAR, BOOLEAN) RETURNS void
          AS 'org.postgresql.pljava.management.Commands.replaceJar'
          LANGUAGE java SECURITY DEFINER;
      CREATE FUNCTION sqlj.remove_jar(VARCHAR, BOOLEAN) RETURNS void
          AS 'org.postgresql.pljava.management.Commands.removeJar'
          LANGUAGE java SECURITY DEFINER;
      CREATE FUNCTION sqlj.set_classpath(VARCHAR, VARCHAR) RETURNS void
          AS 'org.postgresql.pljava.management.Commands.setClassPath'
          LANGUAGE java SECURITY DEFINER;
      CREATE FUNCTION sqlj.get_classpath(VARCHAR) RETURNS VARCHAR
          AS 'org.postgresql.pljava.management.Commands.getClassPath'
          LANGUAGE java STABLE SECURITY DEFINER;

      ---------- end ------------------------------

       
    • Bart

      Bart - 2005-06-08

      Hey Jonah,
      you asked:
      "Is the problem solely with the loading of PL/Java into the database? If so, I can probably get you a dump of the SQLJ schema that *may* work with OS/2. "

      See my reply 4 posts earlier in this thread.

      Thanks !

      Bart

       
    • Jonah H. Harris

      Jonah H. Harris - 2005-06-08

      Bart,

      Doh!  Sorry, didn't see that.  OK, I'll work on getting you something that works for OS/2.

      -Jonah

       
    • Bart

      Bart - 2005-06-15

      Hello S Poon
      You said you were a compiere partner in Toronto.
      I asked if I could see it running and if you had a web site but I never heard back from you.

      I look forward to your response.

      Bart
      gen_mgr at cbm.on.ca

       
    • Bart

      Bart - 2005-06-15

      Hi Jonah
      is this a good time to ask about the dump file?
      I believe I am working with 2.5.2a, is the table structure any different in 2.5.2b? Is the compiere libero on your website 2.5.2a or b?

      Thanks!
      Bart

       

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks