Re: MSysConf on PG 8.2 ?

Richard Broersma Jr wrote:
>> We have a PG 8.2 database upon which we report using MS Access using 8.02.02
>> psqlodbc35w.dll dated 10/24/2006.   I've noticed errors being returned
>> within the logs such as " relation 'msysconf' does not exist"  .
>
> I am getting this error in my postgresql log files also.
>
> this is what I am seeing in various places in my pg_log file:
>
> 2007-03-01 13:44:39 LOG:  statement: select oid, typbasetype from pg_type where typname = 'lo'
> 2007-03-01 13:44:40 LOG:  statement: SELECT Config, nValue FROM MSysConf
> 2007-03-01 13:44:40 ERROR:  relation "msysconf" does not exist
> 2007-03-01 13:44:40 STATEMENT:  SELECT Config, nValue FROM MSysConf
>

I don't use the lo type but it looks like you need to install it from
contrib.

Joshua D. Drake

> Regards,
> Richard Broersma Jr.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                 http://www.postgresql.org/about/donate
>


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/