-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 To be honest I'm not a Postgres expert. From what I understand 'public' is some kind of special schema that shouldn't normally be used, but I might be wrong!
Let me know how you get on with trying to do this within a non-public schema. cheers, Richard Brian Osborne wrote: > Richard, > > I think I see the problem, not a surprising one. Biosql's Postgres script > does not create a schema within the Biosql database, you're just populating > the db with tables. Within MartBuilder you must specify a schema, entering > database as 'bioseqdb' and schema as 'bioseqdb' does not work ('schema > connection failed'). So I tried other possibilities and 'public' worked for > some reason. Perhaps it shouldn't have? > > However, since 'public.bioentry' doesn't exist the mart is not built. Looks > like I have to modify the Biosql Postgres script to create a schema, not > just a database (it's based on Mysql). > > > BIO > > > On 5/24/07 10:36 AM, "Richard Holland" <[EMAIL PROTECTED]> wrote: > >> Yes, I know BioSQL well! :) > > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGVrWt4C5LeMEKA/QRAgBZAJ0QJYP39xRn+WABo/k2gXvRBjfHqQCfWinl ENmJDju5IJkaFLKbwtVkRoo= =O74g -----END PGP SIGNATURE-----