Re: ANOTHER NEW ODBC DRIVER
От | Byron Nikolaidis |
---|---|
Тема | Re: ANOTHER NEW ODBC DRIVER |
Дата | |
Msg-id | 3559B791.7C926DDE@insightdist.com обсуждение исходный текст |
Ответ на | ANOTHER NEW ODBC DRIVER (Byron Nikolaidis <byronn@insightdist.com>) |
Список | pgsql-interfaces |
This is the backend "canonifier" problem that was previously discussed on the interfaces list under "New Driver and UniqueIndexes". I'll forward it to you. Byron Jose' Soares Da Silva wrote: > On Fri, 8 May 1998, Byron Nikolaidis wrote: > > > Version .0238 is now at our website. > > > Hello Byron, > I have a 'palloc failure: memory exahusted' message using PSQLODBC > with M$-Access97 as following: > --------------------------------------------------------------------------- > conn=69337208, SQLDriverConnect( in)='DSN=PostgreSQL;DATABASE=java;SERVER=verde;PORT=5432;READONLY=0;PROTOCOL=;CONNSETTINGS=;' > DSN info(DSN='PostgreSQL',server='verde',dbase='java',user='postgres',passwd='',port='5432',readonly='0',protocol='', conn_settings='') > conn=69337208, SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=java;SERVER=verde;PORT=5432;UID=postgres;READONLY=0;PWD=;PROTOCOL=;CONNSETTINGS=' > conn=69337208, query=' ' > conn=69337208, query='BEGIN' > conn=69337208, query='set DateStyle to 'ISO'; set geqo to 'OFF'' > Command response: 'SET VARIABLE' > conn=69337208, query='declare C69350472 cursor for select oid from pg_type where typname='lo'' > conn=69337208, query='fetch 100 in C69350472' > [ fetched 0 rows ] > conn=69337208, query='close C69350472' > conn=69337208, query='END' > conn=69337208, query='BEGIN' > conn=69337208, query='declare C69350472 cursor for SELECT Config, nValue FROM MSysConf' > ERROR from backend during send_query: 'ERROR: msysconf: Table does not exist.' > conn=69337208, query='ABORT' > conn=69337208, query='BEGIN' > conn=69337208, query='declare C69350472 cursor for SELECT figure.azienda,figure.tipo,figure.gruppo,figure.inizio_attivitaFROM figure ' > conn=69337208, query='fetch 100 in C69350472' > [ fetched 3 rows ] > conn=69337208, query='close C69350472' > conn=69337208, query='END' > conn=69337208, query='BEGIN' > conn=69337208, query='declare C69350472 cursor for SELECT azienda,tipo,gruppo,inizio_attivita,fine_attivita,codice_figura FROM figure WHERE azienda = '001BO001 ' AND tipo = '1'AND gruppo = '1 ' AND inizio_attivita = '1998-01-12'' > conn=69337208, query='fetch 100 in C69350472' > [ fetched 1 rows ] > conn=69337208, query='close C69350472' > conn=69337208, query='END' > conn=69337208, query='BEGIN' > conn=69337208, query='declare C69422552 cursor for SELECT azienda,tipo,gruppo,inizio_attivita,fine_attivita,codice_figura FROM figure WHERE azienda = '00212 ' AND tipo = '1'AND gruppo = '1 ' AND inizio_attivita = '1997-01-01' OR azienda = '1233 > ' AND tipo = '1' AND gruppo = '11' AND inizio_attivita = '1998-02-12' OR azienda = '1233 ' AND tipo = '1' ANDgruppo = '11' AND inizio_attivita = '1998-02-12' OR azienda = '1233 ' AND tipo = '1' AND gruppo = '11' AND inizio_attivita= '199 > 8-02-12' OR azienda = '1233 ' AND tipo = '1' AND gruppo = '11' AND inizio_attivita = '1998-02-12' OR azienda = '1233 ' AND tipo = '1' AND gruppo = '11' AND inizio_attivita = '1998-02-12' OR azienda = '1233 ' AND tipo = '1'AND gruppo = ' > 11' AND inizio_attivita = '1998-02-12' OR azienda = '1233 ' AND tipo = '1' AND gruppo = '11' AND inizio_attivita= '1998-02-12' OR azienda = '1233 ' AND tipo = '1' AND gruppo = '11' AND inizio_attivita = '1998-02-12'OR azienda = '1233 ' > AND tipo = '1' AND gruppo = '11' AND inizio_attivita = '1998-02-12'' > ERROR from backend during send_query: 'FATAL 1: palloc failure: memory exhausted' > --------------------------------------------------------------------------- > I linked the below table on Access97, It's primary key is: > composed by (azienda,tipo,inizio_attivita)... > > CREATE TABLE figure ( > azienda CHAR(11) NOT NULL, > tipo CHAR, > gruppo CHAR(02), > inizio_attivita DATE, > fine_attivita DATE, > codice_figura CHAR(11) NOT NULL, > PRIMARY KEY (azienda,tipo,inizio_attivita) > ); > > java=> select * from figure; > azienda |tipo|gruppo|inizio_attivita|fine_attivita|codice_figura > -----------+----+------+---------------+-------------+------------- > 001BO001 | 1| 1 | 1998-01-12| | 01 > 00212 | 1| 1 | 1997-01-01| | 12 > 1233 | 1| 11| 1998-02-12| | 23 > (3 rows) > > When I try to read next record (by clik on right arrow), > I have the above message. > Thanks for help, Jose'
В списке pgsql-interfaces по дате отправления:
Предыдущее
От: Peter MountДата:
Сообщение: RE: [INTERFACES] Accessing PgSql-Database from NT (ODBCD)