Re: [INTERFACES] new odbc fails

Byron was correct. That message comes from the backend. If you cut out that
last query with all the ANDs and OR's, you will see what I mean. There will be
something in 6.4 to handle this. I am awaiting Bruce's comments to see what form
the solution will take.

John J. Boris, Sr. wrote:

> > Version of PostgreSQL server?
> PostgreSQL 6.3.1
> >
> > Version of ODBC Driver? I know you say you have the latest, but we have
> >had some confusion in the past with old FTP sites.
> PostgreSQL 6.30.0247 from Insight Distribution Systems
> >
> >Could you turn the CommLog under the Advanced Driver Options and send the
> >results of your interaction. The log file is C:\psqlodbc.log. You must
> >close the application before the logging activity is flushed.
> conn=156310432,
> SQLDriverConnect(out)='DRIVER={PostgreSQL};DATABASE=gsyfl;SERVER=bcs-2.onlin
> esvc.com;PORT=5432;UID=postgres;READONLY=0;PWD=onlinesvc;PROTOCOL=;FAKEOIDIN
> DEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=1;SHOWSYSTEMTABLES=1;CONNSETTINGS='
> Global Options: fetch=100, socket=4096, unknown_sizes=0,
> max_varchar_size=254, max_longvarchar_size=4094
> disable_optimizer=0, unique_index=0, use_declarefetch=1
> text_as_longvarchar=1, unknowns_as_longvarchar=1,
> bools_as_char=1
> extra_systable_prefixes='dd_;', conn_settings=''
> conn=156310432, query=' '
> conn=156310432, query='BEGIN'
> conn=156310432, query='set DateStyle to 'ISO''
> conn=156310432, query='declare SQL_CUR156368960 cursor for select oid from
> pg_type where typname='lo''
> conn=156310432, query='fetch 100 in SQL_CUR156368960'
> [ fetched 0 rows ]
> conn=156310432, query='close SQL_CUR156368960'
> conn=156310432, query='END'
> conn=156310432, query='BEGIN'
> conn=156310432, query='declare SQL_CUR156368960 cursor for SELECT Config,
> nValue FROM MSysConf'
> ERROR from backend during send_query: 'ERROR: msysconf: Table does not
> exist.'
> conn=156310432, query='ABORT'
> STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
> executing the query'
> ------------------------------------------------------------
> hdbc=156310432, stmt=156368960, 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='declare SQL_CUR156368960 cursor for
> 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_CUR156368960'
> ----------------QResult Info -------------------------------
> CONN ERROR: func=SC_execute, desc='', errnum=10, errmsg='ERROR: msysconf:
> Table does not exist.'
> ------------------------------------------------------------
> henv=156304960, conn=156310432, status=1, num_stmts=16
> sock=156304976, stmts=156305024, lobj_type=-999
> ---------------- Socket Info -------------------------------
> socket=352, reverse=0, errornumber=0, errormsg='(null)'
> buffer_in=156316448, buffer_out=156320552
> buffer_filled_in=2, buffer_filled_out=0, buffer_read_in=2
> conn=156310432, query='BEGIN'
> conn=156310432, query='declare SQL_CUR156368960 cursor for SELECT
> "schedule"."sweek","schedule"."hteam","schedule"."vteam" FROM "schedule" '
> conn=156310432, query='fetch 100 in SQL_CUR156368960'
> [ fetched 90 rows ]
> conn=156310432, query='close SQL_CUR156368960'
> conn=156310432, query='END'
> conn=156310432, query='BEGIN'
> conn=156310432, query='declare SQL_CUR156439880 cursor for SELECT
> "sdate","sweek","hteam","vteam","stimes" FROM "schedule" WHERE "sweek" =
> 1 AND "hteam" = 'LINDENBORO' AND "vteam" = 'G.T.LIONS' OR "sweek" = 1 AND
> "hteam" = 'VOORHEES' AND "vteam" = 'STERLING' OR "sweek" = 1 AND "hteam" =
> 'MARLTON' AND "vteam" = 'PYAA PANTHERS' OR "sweek" = 1 AND "hteam" = 'WASH.
> TWP. PATRIOTS' AND "vteam" = '' OR "sweek" = 1 AND "hteam" = 'HADDONFIELD'
> AND "vteam" = 'WINSLOW' OR "sweek" = 1 AND "hteam" = 'INTERBORO' AND
> "vteam" = 'WASH. TWP. MINUTEMAN' OR "sweek" = 1 AND "hteam" = 'BELLMAWR'
> AND "vteam" = 'GLOUCESTER' OR "sweek" = 1 AND "hteam" = 'WILLIAMSTOWN' AND
> "vteam" = 'GLASSBORO' OR "sweek" = 1 AND "hteam" = 'DEPTFORD' AND "vteam" =
> 'OAKLYN' OR "sweek" = 1 AND "hteam" = 'WILLINGBORO' AND "vteam" = 'PYAA
> LIONS''
> ERROR from backend during send_query: 'FATAL 1: palloc failure: memory
> exhausted'
> STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
> executing the query'
> ------------------------------------------------------------
> hdbc=156310432, stmt=156439880, result=0
> manual_result=0, prepare=1, internal=0
> bindings=0, bindings_allocated=0
> parameters=156368960, parameters_allocated=30
> statement_type=0, statement='SELECT
> "sdate","sweek","hteam","vteam","stimes" FROM "schedule" WHERE "sweek" =
> ? AND "hteam" = ? AND "vteam" = ? OR "sweek" = ? AND "hteam" = ? AND
> "vteam" = ? OR "sweek" = ? AND "hteam" = ? AND "vteam" = ? OR "sweek" = ?
> AND "hteam" = ? AND "vteam" = ? OR "sweek" = ? AND "hteam" = ? AND "vteam"
> = ? OR "sweek" = ? AND "hteam" = ? AND "vteam" = ? OR "sweek" = ? AND
> "hteam" = ? AND "vteam" = ? OR "sweek" = ? AND "hteam" = ? AND "vteam" = ?
> OR "sweek" = ? AND "hteam" = ? AND "vteam" = ? OR "sweek" = ? AND "hteam" =
> ? AND "vteam" = ?'
> stmt_with_params='declare SQL_CUR156439880 cursor for
> SELECT "sdate","sweek","hteam","vteam","stimes" FROM "schedule" WHERE
> "sweek" = 1 AND "hteam" = 'LINDENBORO' AND "vteam" = 'G.T.LIONS' OR "sweek"
> = 1 AND "hteam" = 'VOORHEES' AND "vteam" = 'STERLING' OR "sweek" = 1 AND
> "hteam" = 'MARLTON' AND "vteam" = 'PYAA PANTHERS' OR "sweek" = 1 AND
> "hteam" = 'WASH. TWP. PATRIOTS' AND "vteam" = '' OR "sweek" = 1 AND "hteam"
> = 'HADDONFIELD' AND "vteam" = 'WINSLOW' OR "sweek" = 1 AND "hteam" =
> 'INTERBORO' AND "vteam" = 'WASH. TWP. MINUTEMAN' OR "sweek" = 1 AND "hteam"
> = 'BELLMAWR' AND "vteam" = 'GLOUCESTER' OR "sweek" = 1 AND "hteam" =
> 'WILLIAMSTOWN' AND "vteam" = 'GLASSBORO' OR "sweek" = 1 AND "hteam" =
> 'DEPTFORD' AND "vteam" = 'OAKLYN' OR "sweek" = 1 AND "hteam" =
> 'WILLINGBORO' AND "vteam" = 'PYAA LIONS''
> 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_CUR156439880'
> ----------------QResult Info -------------------------------
> CONN ERROR: func=SC_execute, desc='', errnum=8, errmsg='FATAL 1: palloc
> failure: memory exhausted'
> ------------------------------------------------------------
> henv=156304960, conn=156310432, status=1, num_stmts=16
> sock=156304976, stmts=156305024, lobj_type=-999
> ---------------- Socket Info -------------------------------
> socket=352, reverse=0, errornumber=0, errormsg='(null)'
> buffer_in=156316448, buffer_out=156320552
> buffer_filled_in=45, buffer_filled_out=0, buffer_read_in=45
> conn=156310432, SQLDisconnect
>
> John J. Boris, Sr. Boris Computer Services/ONLine Services
> email:john(dot)boris(at)onlinesvc(dot)com(dot)com
> bbs: The Bleeding Edge 609-858-9221
> http:\\www.onlinesvc.com
> telnet:www.onlinesvc.com
> Busines Phone 609-869-9620