-----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-----
