Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

db error in Connection.pm #27

Open
ClayBirkett opened this issue Jul 1, 2020 · 0 comments
Open

db error in Connection.pm #27

ClayBirkett opened this issue Jul 1, 2020 · 0 comments

Comments

@ClayBirkett
Copy link
Member

When running bin/load_map_data.pl I get an error
DBD::Pg::db selectrow_array failed: ERROR: cross-database references are not implemented: "sgn.sgn.map_map_id_seq"
LINE 1: SELECT currval('sgn.sgn.map_map_id_seq')
at /home/production/cxgn/cxgn-corelibs/lib/CXGN/DB/Connection.pm line 71, line 1

The error can be fixed by the following changing
my ($id) = $self->selectrow_array("SELECT currval('$schema.$seq')")
to
my ($id) = $self->selectrow_array("SELECT currval('$seq')")

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant