msysconf error

Поиск
Список
Период
Сортировка
От David Chapman
Тема msysconf error
Дата
Msg-id 9c7f5eb30601211839t55b50913sacd7c5219bb36ef2@mail.gmail.com
обсуждение исходный текст
Список 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.luckychap@gmail.com
 

В списке pgsql-novice по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: column number instead of column name
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Forums