Hi,
We use BASE with MySQL but we are planning to move to pgsql at some
point. So we installed BASE (latest) with pqsql (version 8.1.0).
We just tried to load a reporter map and BASE was reporting errors due
to invalid SQL about the omim and locuslink columns. It is clearly
something that works with MySQL and I can't imagine this to be buggy in
PgSQL since this should have been reported already.
We traced the error and found that, in the SQL (both mysql and pgsql),
these 2 columns are defined as integer while the
reporter_columns.inc.php defines them as XCOL_STRING.
We changed XCOL_STRING to XCOL_INT and it worked fine. In fact, I
wonder why it works with MySQL and , maybe with older version of
PgSQL...
I haven't made the change in CVS yet as I am a bit surprised by the
fact it worked so far and because it seems that it was not a problem
until here.
Could PgSQL users comment on this? Do you changed this ( XCOL_STRING to
XCOL_INT) on your installations?
Cheers
Charles
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
The BASE general discussion mailing list
basedb-users@lists.sourceforge.net
unsubscribe: send a mail with subject "unsubscribe" to
[EMAIL PROTECTED]
