Commands running simultaneously:

• make inputs/.TNRS/tnrs/test.by_col.xml verbosity=3
• make test by_col=1

Error for make test by_col=1:

Testing /Users/aaronmk/Documents/BIEN/svn/inputs/CTFS/StemObservation/test.by_col.xml...
>StemObservation/test.by_col.xml env test=1 n=2 by_col=1 env in_database=vegbien in_schema=CTFS in_table=StemObservation out_database=vegbien ../../map StemObservation/VegBIEN.csv
 TransactionRollbackError: deadlock detected 
DETAIL:  Process 88837 waits for ShareLock on transaction 216702951; blocked by process 89010.
Process 89010 waits for ShareUpdateExclusiveLock on relation 529874657 of database 4687426; blocked by process 88837.
HINT:  See server log for query details.
query: [input] INSERT INTO "party" 
("creator_id", "organizationname")
SELECT
E'0' AS "creator_id" 
, E'TNRS' AS "organizationname" 
/* EXPLAIN:
Result  (cost=0.00..0.01 rows=1 width=0)
*/
RETURNING "party_id" 
/* EXPLAIN:
Insert  (cost=0.00..0.03 rows=1 width=0)
  ->  Subquery Scan on "*SELECT*"  (cost=0.00..0.03 rows=1 width=0)
        ->  Result  (cost=0.00..0.01 rows=1 width=0)
*/
node:
<party>
    <creator_id>0</creator_id>
    <organizationname>TNRS</organizationname>
</party>
Traceback (most recent call last):
  File "../../bin/../lib/sql_io.py", line 609, in put_table
    main_select, **insert_args)
  File "../../bin/../lib/sql.py", line 866, in insert_select
    into, recover=recover, cacheable=cacheable, log_level=log_level)
  File "../../bin/../lib/sql.py", line 637, in run_query_into
    if into == None: return run_query(db, query, **kw_args)
  File "../../bin/../lib/sql.py", line 516, in run_query
    return with_savepoint(db, run)
  File "../../bin/../lib/sql.py", line 499, in with_savepoint
    def with_savepoint(db, func): return db.with_savepoint(func)
  File "../../bin/../lib/sql.py", line 436, in with_savepoint
    return func()
  File "../../bin/../lib/sql.py", line 514, in run
    debug_msg_ref, **kw_args)
  File "../../bin/../lib/sql.py", line 380, in run_query
    try: cur.execute(query)
make[2]: *** [StemObservation/test.by_col.xml] Error 1
make[1]: *** [CTFS/test] Error 2
make: *** [inputs/test] Error 2