Error importing BBS into PostgreSQL 8.4; Ubuntu 10.04

[weecology]

Error importing BBS into PostgreSQL 8.4; Ubuntu 10.04

[ethanwhite]

Thanks Brady. I can confirm this same error on 11.04.

[ethanwhite]

So it's a problem with the Species table, which is a perennial hassle since we have to parse it from a poorly formated text file. It works on the other database management systems so this is some little oddity with Postgres. We're working on running that down, but if you want everything but the Species table there's a quick work around, which is to edit the script to get rid of the species table import. I've done this and tested it so if you'd like the quick fix let me know and I can send you the modified script. You just drop it in the scripts folder that the Retriever creates, run the retriever again, and use the special BBS option.

[ethanwhite]

The problem appears to be larger than the species table in that the tables do not appear to exist in Postgres even when everything is successful. This holds true for other datasets as well.

[bendmorris]

Brady, are you using "\d" to try and find the tables? Try typing "\dn" in the psql prompt or running a query like "SELECT * FROM bbs.routes;" and let me know if it doesn't work.

[allredbw]

Ben,

Yep, I always make the silly mistakes. I kept using "\dt" to show tables, but the "bbs" schema wasn't in my search path (this isn't the first time this has happened to me, I need to remember better). The data were always there. After altering the search path to include "bbs", the tables are easily shown, but of course you knew that :-) Thanks. I'll continue to monitor for a fix to the species table.