OID insert fails between MS-Access 2000 and Postgresql 6.5.2
От | rdear@egomaniacs.net (Rick Dearman) |
---|---|
Тема | OID insert fails between MS-Access 2000 and Postgresql 6.5.2 |
Дата | |
Msg-id | 001201bf794b$9481b5e0$2837370a@egomaniacs.net обсуждение исходный текст |
Список | pgsql-interfaces |
internallength=4, externallength=10,
input=int4in, output=int4out,
default='', passedbyvalue
);
create table employee (
id integer,
name varchar(30),
picture lo
);
CONN ERROR: func=SQLGetConnectOption, desc='fOption=30002', errnum=205, errmsg='Unknown connect option (Get)'
------------------------------------------------------------
henv=139198596, conn=138152060, status=0, num_stmts=16
sock=139198612, stmts=139198652, lobj_type=-999
---------------- Socket Info -------------------------------
socket=-1, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=138158388, buffer_out=138162488
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
CONN ERROR: func=SQLSetConnectOption, desc='fOption=30002, vParam=122356332', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=139198596, conn=138152060, status=0, num_stmts=16
sock=139198612, stmts=139198652, lobj_type=-999
---------------- Socket Info -------------------------------
socket=-1, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=138158388, buffer_out=138162488
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
conn=138152060, SQLDriverConnect( in)='DSN=PostgreSQL;UID=test_user;PWD=;DATABASE=test;SERVER=10.55.55.1;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;', fDriverCompletion=0
DSN info: DSN='PostgreSQL',server='10.55.55.1',port='5432',dbase='test',user='test_user',passwd='test_user001'
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=1, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=138152060, query=' '
conn=138152060, query='set DateStyle to 'ISO''
conn=138152060, query='set geqo to 'OFF''
conn=138152060, query='set ksqo to 'ON''
conn=138152060, query='select oid from pg_type where typname='lo''
[ fetched 1 rows ]
[ Large Object oid = 22720 ]
conn=138152060, SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=test;SERVER=10.55.55.1;PORT=5432;UID=test_user;PWD=test_user001;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=138152060, query='SELECT Config, nValue FROM MSysConf'
ERROR from backend during send_query: 'ERROR: msysconf: Table does not exist.'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=138152060, stmt=138166588, result=0
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_CUR083C413C'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: msysconf: Table does not exist.'
------------------------------------------------------------
henv=139198596, conn=138152060, status=1, num_stmts=16
sock=139198612, stmts=139198652, lobj_type=22720
---------------- Socket Info -------------------------------
socket=224, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=138158388, buffer_out=138162488
buffer_filled_in=42, buffer_filled_out=0, buffer_read_in=42
conn=138152060, query='SELECT "employee"."id" FROM "employee" '
[ fetched 0 rows ]
ERROR from backend during send_function: 'ERROR: lo_lseek: invalid large obj descriptor (0)
'
STATEMENT ERROR: func=SQLPutData, desc='', errnum=1, errmsg='Couldnt open large object for writing.'
------------------------------------------------------------
hdbc=138152060, stmt=138166588, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=139200792, parameters_allocated=3
statement_type=1, statement='INSERT INTO "employee" ("id","name","picture") VALUES (?,?,?)'
stmt_with_params=''
data_at_exec=0, current_exec_param=2, put_data=1
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name=''
----------------QResult Info -------------------------------
CONN ERROR: func=SQLPutData, desc='', errnum=110, errmsg='ERROR: lo_lseek: invalid large obj descriptor (0)
'
------------------------------------------------------------
henv=139198596, conn=138152060, status=1, num_stmts=16
sock=139198612, stmts=139198652, lobj_type=22720
---------------- Socket Info -------------------------------
socket=224, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=138158388, buffer_out=138162488
buffer_filled_in=53, buffer_filled_out=0, buffer_read_in=53
conn=138152060, SQLDisconnect
В списке pgsql-interfaces по дате отправления:
Следующее
От: Guido GoldsteinДата:
Сообщение: Re: [INTERFACES] link problems when inheriting from libpq++