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

msysconf error

From: David Chapman <david(dot)luckychap(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: msysconf error
Date: 2006-01-22 02:39:28
Message-ID: 9c7f5eb30601211839t55b50913sacd7c5219bb36ef2@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
I am using Postgresly 8 running on Fedora C3. The clients are Microsoft
Access connecting using ODBC.

Recently I rebuilt my development database. Now I am getting an error
referring to a missing msysconf, which shows up as an error in the calling
statements, although the postresql statements (insert and update) execute
correctly. Can some one please advise me on where to find msysconf and how
to fix the problem.
The extract from  the odbc log is bellow

David

conn=137311856, query='set client_encoding to 'UTF8''

conn=137311856, PGAPI_DriverConnect(out)=''

conn=137311856, query='SELECT Config, nValue FROM MSysConf'

ERROR from backend during send_query: 'ERROR: relation "msysconf" does not
exist'

STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while
executing the query'

------------------------------------------------------------

hdbc=137311856, stmt=137340976, result=137340840

manual_result=0, prepare=0, internal=0

bindings=0, bindings_allocated=0

parameters=0, parameters_allocated=0

statement_type=0, statement='SELECT Config, nValue FROM MSysConf'

stmt_with_params='SELECT Config, nValue FROM MSysConf'

data_at_exec=-1, current_exec_param=-1, put_data=0

currTuple=-1, current_col=-1, lobj_fd=-1

maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1

cursor_name='SQL_CUR082FA830'

----------------QResult Info -------------------------------

fields=137346856, manual_tuples=0, backend_tuples=0, tupleField=0, conn=0

fetch_count=0, num_total_rows=0, num_fields=0, cursor='(NULL)'

message='ERROR: relation "msysconf" does not exist', command='(NULL)',
notice='(NULL)'

status=7, inTuples=0

CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: relation
"msysconf" does not exist'

------------------------------------------------------------

--

David Chapman
David's Backyard Computing

PLEASE RECORD MY NEW EMAIL ADDRESS
david(dot)luckychap(at)gmail(dot)com

Responses

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2006-01-23 06:21:00
Subject: Re: Forums
Previous:From: Michael FuhrDate: 2006-01-21 05:22:46
Subject: Re: column number instead of column name

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