-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello.
Yes, I know BioSQL well! :) The script 'create' statements are of the form: create X as select Y from Z; These statements will therefore create tables and simultaneously populate them. In order to do this, the script requires full read permissions on the source schema, and full write permissions on the target schema, and needs to be run whilst logged in as the target schema owner. cheers, Richard Brian Osborne wrote: > mart-dev, > > I?m just starting to use BioMart 0.5, my aim is to build new marts from > various bio-schemas and see if I can contribute to the documentation. My > first target schema is Biosql (biosql.org), I?m using their latest > schema from their CVS and have created my database in Postgres and > loaded it with a small number of sequence records, ~2000. I don?t know > if you know Biosql, it?s a small-ish schema dealing with sequence, > sequence annotation, and taxonomy. There is a central bioentry table > with identifiers and descriptive information on sequences. > > My question: I?m on page 17 of the manual (nice manual, by the way) > which describes how to use MartBuilder. I?ve created an SQL script from > my Biosql database that should make a new mart but I?m a bit puzzled ? > shouldn?t this script contain data? That?s what page 17 seems to be > saying. The SQL script I?ve created has create and alter and drop > statements but not much more. I?m also having trouble executing this > script but let?s take this one step at a time... > > Thanks again, > > Brian O. > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGVaL04C5LeMEKA/QRAuABAJ9KxlvbF3H5iQotiH5GC27QeCI/rACeJt4v 0OiuCFNL0hF2IWN7n7VQF2w= =dxRe -----END PGP SIGNATURE-----
