[ic] PostgreSQL - No tables created

Marcel Montes marcel@multimake.com
Fri, 17 Nov 2000 09:47:18 -0300


--------------E8936E72227335B1D5695998
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I sent this in reply of a problem with PostgreSQL that resembled a
problem I had with MySQL. I've already solved
this. I was listing the "side effects" of my problem and my solution, I
wasn't asking for a solution.

Thanks anyway,
                           Marcel Montes

Mark Atkinson wrote:

> You need to setup the catalog.cfg file in order to use the Perl DBI
> database calls to the PostgreSQL server.  I had the same problem with
> MySQL or any other database.  Uncomment out the DSN ODBC information
> out in the catalog.cfg file for the database you are going to use.
> You should not need to change anything else.Restart interchange and
> the tables will be created with the Demo information.  It may be a
> little more involved then what I've stated.  But that will get you
> started.  By default Interchange uses the Interchage Database.  Even
> if you configured it to use another Database like MySQL or
> PostgreSQL.  Hence the errors you are getting.  Look in the error.log
> in your catalog directory and see what errors you get.  If interchange
> starts correctly using the database.  You will see in the log file it
> created all of the tables and data. Hope this helps.Mark

--
 Marcel Montes [marcel(at)multimake(dot)com] - Programmer
 "If our brain were so simple that we could understand it,
 we would be so stupid that we couldn't do so"
-------------------------- EOF ----------------------------



--------------E8936E72227335B1D5695998
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
I sent this in reply of a problem with PostgreSQL that resembled a
problem I had with MySQL. I've already solved

this. I was listing the "side effects" of my problem and my solution, I wasn't asking for a solution.

Thanks anyway,
                           Marcel Montes

Mark Atkinson wrote:

You need to setup the catalog.cfg file in order to use the Perl DBI database calls to the PostgreSQL server.  I had the same problem with MySQL or any other database.  Uncomment out the DSN ODBC information out in the catalog.cfg file for the database you are going to use.  You should not need to change anything else.Restart interchange and the tables will be created with the Demo information.  It may be a little more involved then what I've stated.  But that will get you started.  By default Interchange uses the Interchage Database.  Even if you configured it to use another Database like MySQL or PostgreSQL.  Hence the errors you are getting.  Look in the error.log in your catalog directory and see what errors you get.  If interchange starts correctly using the database.  You will see in the log file it created all of the tables and data. Hope this helps.Mark
-- 
 Marcel Montes [marcel(at)multimake(dot)com] - Programmer  
 "If our brain were so simple that we could understand it, 
 we would be so stupid that we couldn't do so"
-------------------------- EOF ----------------------------
  --------------E8936E72227335B1D5695998--