Re: DBD::Pg::st execute failed: ERROR: permission denied for relation...

[blck shp <..hidden..>]

Thanks you. I don't mind booger hunting. :D

Speaking of, tried to apply the updated preprocessed Roles.sql and got this:

psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:1086:
ERROR:  relation "acount_heading_id_seq" does not exist
psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:1088:
ERROR:  relation "account_link_id_seq" does not exist
psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:1091:
ERROR:  syntax error at or near "GRANT"
LINE 2: GRANT INSERT ON account_heading TO "lsmb_ledgersmb13__accoun...
              ^
psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:1092:
ERROR:  relation "acount_heading_id_seq" does not exist
psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:1094:
ERROR:  relation "account_link_id_seq" does not exist


Lines 1086 and 1092 look like spelling. What values were to be
inserted between 1090 and 1091? And I am supposing that
"account_link_id_seq" has a different name for the other two.




On Tue, Oct 27, 2009 at 2:43 PM, Chris Travers <..hidden..> wrote:
>
>
> On Tue, Oct 27, 2009 at 12:11 PM, blck shp <..hidden..> wrote:
>>
>> Hmmm...OK.
>>
>> Looking back when I applied the pre-processed roles sql:
>> su - postgres -c "psql -U ledgersmb -d ledgersmb13 -f
>> /usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql"
>>
>>
>> I now see several of the following:
>>
>> psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:10:
>> ERROR:  relation "entity_craccount_edit" does not exist
>
> Crap.................
>
> Ok, fixing this :-).
>
> Committed a fix.  (Why this is pre-beta still).
>
> Best Wishes,
> Chris Travers
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>