[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

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
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
Ledger-smb-users mailing list