[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Installing LedgerSMB into a schema?



Tony is right.  I misread the documentation.  The tables go into the
first schema found in the searchpath.

On 11/7/06, Tony Fraser <..hidden..> wrote:

use admin.pl to create the dataset using your existing DB and the new
user lsmb_mycompany. PostgreSQL should place the LedgerSMB tables in the
ledgersmb schema because it is the first schema in the users search
path.

In fact I bet Chris's idea would work without altering the Pg-*.sql
files because new unqualified tables are created in the first schema
listed in the search path.

--
Tony Fraser
..hidden..
Sybaspace Internet Solutions                        System Administrator
phone: (250) 246-5368                                fax: (250) 246-5398


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users