Problems with DEF-VIEW-CLASS
Hi I think I am missing something with DEF-VIEW-CLASS. Here is my example straight from the Gene Ontology (godatabase). GENE_PRODUCT is a table in the (MySQL) db. (def-view-class gps (standard-db-object) ((id :db-kind :key :type integer) (symbol :db-kind :base :reader gene-product-symbol) (dbxref_id :db-kind :base :reader gene-product-dbxref ) (species_id :db-kind :base :reader gene-product-species-id ) (type_id :db-kind :base :reader gene-product-type-id ) (full_name :db-kind :base :reader gene-product-full-name )) (:documentation "The GENE-PRODUCT data base view class.") (:base-table gene_product) ) Then I do: CL-USER 4 > sql:create-view-from-class 'godbtest::gps Error: Table GODBTEST::GENE_PRODUCT already exists in database #<SQL::MYSQL-DATABASE "root{go_local}" 21BFC11B> 1 (abort) Return to level 0. 2 Return to top loop level 0. Type :b for backtrace, :c <option number> to proceed, or :? for other options What am I missing? Can't I create a view that is just a view of a table? Thanks -- Marco Antoniotti