Richard, if I may pitch in a question: can one use MartBuilder to
pull data out of say PostgreSQL and create + load into a mart in
MySQL? The answer might be in the manual somewhere but I'm sure you
have the quick answer!
It's possible I might for my project end up having the master
database in PostgreSQL (for various reasons), but then have the
corresponding Mart in MySQL + read-only MyISAM tables for speed.
Mummi
-----------------------------------------------------------
Gudmundur A. Thorisson, PhD student, Brookes lab
Department of Genetics
University of Leicester
University Road
Leicester, LE1 7RH, UK
E-mail: [EMAIL PROTECTED]
Tel: +44 (0)116 252-3055
On 24 May 2007, at 16:34, Richard Holland wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The public thing is interesting.
When you originally connected MartBuilder to your source schema, I'm
assuming you used database=postgres and schema=bioseqdb?
What target schema did you give it when you asked it to generate the
SQL? Was is bioseqdbmart?
Are both the bioseqdb and bioseqdbmart schemas in the same
database, ie.
postgres?
cheers,
Richard
Brian Osborne wrote:
Richard,
So the SQL file's name is bioseqdbmart.sql, the source is bioseqdb
and the
mart or target is bioseqdbmart. OK, so:
psql bioseqdbmart postgres < bioseqdbmart.sql
might not work, I should be logged in. Let's log in...
Hmm. I see:
bioseqdbmart=# \i bioseqdbmart.sql
psql:bioseqdbmart.sql:1: ERROR: schema "bioseqdbmart" already exists
SET
psql:bioseqdbmart.sql:6: ERROR: relation "public.bioentry" does
not exist
SET
psql:bioseqdbmart.sql:9: ERROR: relation "bioseqdbmart.temp__1"
does not
exist
SET
...and more errors.
"public.bioentry" is troubling, it should be
"public.bioseqdb.bioentry" or
"bioseqdb.bioentry", I think. That error comes from this:
bioseqdbmart=# create table bioseqdbmart.TEMP__1 as select
a.accession as
accession,a.biodatabase_id as biodatabase_id,
bioseqdbmart-# a.bioentry_id as bioentry_id_key,a.description as
description,a.division as division,a.identifier as
bioseqdbmart-# identifier,a.name as name,a.taxon_id as
taxon_id,a.version as
version,b.authority as authority,
bioseqdbmart-# b.description as description_biodatabase,b.name as
name_biodatabase from public.bioentry as a left join
bioseqdbmart-# public.biodatabase as b on
a.biodatabase_id=b.biodatabase_id;
ERROR: relation "public.bioentry" does not exist
bioseqdbmart=#
Brian O.
On 5/24/07 10:36 AM, "Richard Holland" <[EMAIL PROTECTED]> wrote:
run whilst logged in as the target schema owner.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGVbCJ4C5LeMEKA/QRAr1lAKCfLBi6HpDwCo1liCikscGmVxxdjQCeKljT
zHNwNkyL8Y8DDVlSjGaKJeY=
=6VHt
-----END PGP SIGNATURE-----
