The foundation for your business
Fork me on GitHub
Re: [ledgersmb-users] Running LedgerSMB 1.5 with a schema other than public
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ledgersmb-users] Running LedgerSMB 1.5 with a schema other than public

Erik Huelsmann a écrit :
> I've created a change to the code base which is at least a step in the right
> direction. Could you check that it works when you place these files on your
> server:
> https://github.com/ledgersmb/LedgerSMB/blob/
> 8f5782ee9fe2e6159f42b652fd77c331dd25a737/lib/LedgerSMB/PGOld.pm
> https://github.com/ledgersmb/LedgerSMB/blob/
> 8f5782ee9fe2e6159f42b652fd77c331dd25a737/lib/LedgerSMB/PGObject.pm
> ?


  It seems to work, thank you !
  I found other places where schema public explicitely appears :
* In sql/changes/1.5/open_forms_callers.sql, there are three requests
explicitely mentioning table « public.open_forms ». This prevents the
complete upgrade of the tables from 1.3 to 1.5. I patched the file by
suppressing « public. » and it works.
* In sql/modules/Roles.sql, there is a request « GRANT ALL ON SCHEMA
public TO public; ».

users mailing list