Skip site navigation (1) Skip section navigation (2)

Re: MSysConf on PG 8.2 ?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
Cc: Frank Brown <frankjbrown(at)gmail(dot)com>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: MSysConf on PG 8.2 ?
Date: 2007-03-03 01:27:42
Message-ID: 45E8CF0E.7070906@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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/


In response to

Responses

pgsql-odbc by date

Next:From: Richard Broersma JrDate: 2007-03-03 01:37:18
Subject: Re: MSysConf on PG 8.2 ?
Previous:From: Richard Broersma JrDate: 2007-03-03 01:12:14
Subject: Re: MSysConf on PG 8.2 ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group