ebi-chebi / ChEBI

Chemical Entities of Biological Interest (ChEBI) is a freely available dictionary of molecular entities focused on ‘small’ chemical compounds.

https://www.ebi.ac.uk/chebi

Creative Commons Attribution 4.0 International

42 stars 10 forks source link

PostgreSQL dump file restore problem #4412

Open kingstdio opened 1 year ago

kingstdio commented 1 year ago

ISSUE

When I use the provided SQL script and dump file to reconstruct the database using PostgreSQL, I encountered an error while importing the compound_origins table: "UndefinedColumn: column 'component_accession' of relation 'compound_origins' does not exist."

CAUSE

The field component_accession in the compound_origins.sql file and pgsql_create_tables.sql file do not match due to a spelling error.

Please help to resolve this problem.

Thanks.