On 25 May 2007, at 11:08, Richard Holland wrote:
-----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!
'public' is just a default postgress schema. If you setup
a new database and you do not specify otherwise, your tables will
go by default to a public schema. Assuming that your source schema
is in public, it would be probably best to set target schema in MBuilder
as other than public to keep mart and source schema separated
(as we normally do anyway)
a.
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-----
------------------------------------------------------------------------
-------
Arek Kasprzyk
EMBL-European Bioinformatics Institute.
Wellcome Trust Genome Campus, Hinxton,
Cambridge CB10 1SD, UK.
Tel: +44-(0)1223-494606
Fax: +44-(0)1223-494468
------------------------------------------------------------------------
-------