Database import problem on EnterpriseDB

Bigduke
2007-03-22
2013-05-02
  • Bigduke

    Bigduke - 2007-03-22

    Has anyone encountered this warning while importing the DB for enterpriseDB?

    pg_restore: WARNING:  foreign key constraint "fk703_14574_8472" will require costly sequential scans
    DETAIL:  Key columns "m_attributesetinstance_id" and "m_attributesetinstance_id" are of different types: numeric and integer.

    Unfortunately the import process halts after this ... its beginning to be very frustrating because the installation steps only cover import on Oracle.

     
    • Trifon (An ADempiere founder)

      Hi,

      >Has anyone encountered this warning while importing the DB for enterpriseDB?

      Just one important step is missing here. Compiere ERP-CRM do not support Enterprise DB or Postgres. Any attemps to import dump into Enterprise DB are useless.

      Kind regards,
      Trifon

      P.S. I will not write about one project (fork of Compiere ERP-CRM which support Postgres, as i do not want to make advertisement here, but please try to find it)

       
      • Yves Sandfort

        Yves Sandfort - 2007-03-22

        Trifon, you should check before writing, Enterprise DB etc. is in final test phase for weeks now...

        So please stop telling people that it doesn't work, we have seen posts from fork people more than once now...

         
        • Trifon (An ADempiere founder)

          Hi Yves,

          >Enterprise DB etc. is in final test phase for weeks now

          good news, can u help the user to use Enterprise DB?

          kind regards,
          Trifon

           
        • Trifon (An ADempiere founder)

          Hi Yves,

          sorry but it is me again.

          I would like to suggest you one challenge.

          You state that Compiere works on Enterprise DB.
          >Trifon, you should check before writing, Enterprise DB etc. is in final test phase for weeks now...

          If you manage to run Compiere 2.6.0c on Enterprise DB i will reconsider my opinion about Compiere Inc. that they lack knowledge how to make DB independence and will start advertise Compiere ERP-CRM as semi-DB indepenedent application.

          Also one question:
          On which version of Compiere, Enterprise DB works with Compiere?

          Kind regards,
          Trifon

           
          • Yves Sandfort

            Yves Sandfort - 2007-03-23

            I have seen systems working with Enterprise DB, I currently hadn't time to testdrive it myself, but I have seen the results from the partners. Also the developers say it is final check phase to fix the final bugs.

            On the last training people used it also the first time, and as I heard even some tried it already with postgres.

            So at the moment I can't explain how to install, as I have only tested already setup systems. But if there is no answer here one might consider doing a support request for it.

            It should be fully in since 2.6.0c, but we constantly provide updates, so keeping uptodate is a good idea.

            Yves

             

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

Sign up for the SourceForge newsletter:





No, thanks