I am exercising some functional testing I wrote that create new company
databases using setup.pl (and curl).  

It is failing with head of SVN (of a week ago about). 
In the postgresql logs I am seeing:

STATEMENT:  insert into batch_class (id,class) values (7,'receipt_reversal');
WARNING:  sequence "new_shipto_id_seq" only supports USAGE, SELECT, and UPDATE 
privileges
ERROR:  role "lsmb_<?lsmb dbname ?>__part_edit" does not exist
STATEMENT:  GRANT "lsmb_newco__file_read" TO "lsmb_<?lsmb dbname ?>__part_edit";
ERROR:  role "lsmb_<?lsmb dbname ?>__part_edit" does not exist
STATEMENT:  GRANT ALL ON partscustomer_entry_id_seq 
        TO "lsmb_newco__contact_edit", "lsmb_<?lsmb dbname ?>__part_edit";
ERROR:  Cannot grant permissions to a non-existant user.

Notice it has <?lsmb dbname ?>, which I don't think belongs in the SQL!!!
There are some other errors that I see, but they most be non-fatal.

Also, is there a sane way to drop all of these created roles, or do they
go away when I drop the database involved?

-- 
]               Never tell me the odds!                 | ipv6 mesh networks [ 
]   Michael Richardson, Sandelman Software Works        | network architect  [ 
]     [email protected]  http://www.sandelman.ca/        |   ruby on rails    [ 
        


------------------------------------------------------------------------------
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Reply via email to