Re: [GeneX-dev] Re: xml2db.pl errors...

[<ja...@op...>]

"Jiaye Zhou" <ze...@in...> writes:

> Hi michael,
> 
> Quoting Michael Pear <mic...@ho...>:
> 
> > Found the following errors so far with xml2db.pl
> > 
> > 1) Stopped on a contact "genex" that was in the initial database (not
> > added by
> > me) when looking up the record. 
> > DBD::Pg::st execute failed: ERROR:  parser: parse error at or near ""
> > 7Contact: SELECT con_pk from Contact where contact_person = 'genex' AND 
> >  at /var/genex/local/bin/xml2db.pl line 1656.
> 
> Hmmmm, why is genex in the contact info? -U option is only used for
> initializing the connection string. The above error occured when the
> program is checking for existing data in the database.

I knew this would happen, but I couldn't think of a better name.

There are two uses of the name 'genex':

1) A postgres user, entered into the pg_shadow table. This user is
   given SELECT, INSERT, and DELETE privelege to all tables in the
   genex DB dump

2) An entry in the UserSec table. This entry is listed as owning all
   experiment sets, arraymeasurements and USF entries in the public DB
   dump. It also has a corresponding entry in the Contact table.

They have nothing to do with one another, except (confusingly) they
have the same name.

The error your seeing is with the UserSec and Contact entries.

I hope it's a bit clearer, and I would *love* suggestions as to how to
make this clearer in the future.

jas.