|
From: Noel C. <NO...@mi...> - 2001-08-11 07:16:32
|
well... that worked .. I printed the readme off the website which is a little different to the one in ./sql-ledger/docs Thanks for the quick response Dieter. ----- Original Message ----- From: "Dieter Simader" <dsi...@sq...> To: <sql...@li...> Sent: Saturday, August 11, 2001 10:09 AM Subject: Re: newbie question > The README file in the doc section has the right info. > > schema scripts are in the sql directory. > > to setup the tables > > $ psql dbname < acc-Pg.sql > > > Dieter Simader http://www.sql-ledger.org (780) 472-8161 > DWS Systems Inc. Accounting Software Fax: 478-5281 > =========== On a clear disk you can seek forever =========== > > On Sat, 11 Aug 2001, Noel Cordell wrote: > > > Hi, > > > > I think I have successfully installed sql ledger and required > > components. > > > > In the readme under SETUP A DATABASE AND THE TABLES there is an > > instruction to select the Database Administration link.. I don't see > > that link. I created a user and filled in the relevant information, > > dbname port etc, I manually created a database at the command line that > > I referenced here. > > > > Regarding the tables in the database, do I need to create these manually > > too, or does the script do this? > > > > Apologies if I am missing something obvious here. > > > > Thanks > > > > Noel Running Redhat Linux 7.0 > > > > P.S. Login works fine, but selecting links on the left results in > > errors. There are no tables in the database to query, so this is > > predictable I guess. > > > > eg > > ERROR: Relation 'chart' does not exist SELECT accno, description FROM > > chart WHERE link LIKE '%CT_tax%' AND chart.id = tax.chart_id ORDER BY > > accno > > > > > > > > > > > > > > > > |