pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedANOTHER NEW ODBC DRIVER
2+ messages / 1 participants
[nested] [flat]
* ANOTHER NEW ODBC DRIVER
@ 1998-05-08 21:28 Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 0 replies; 2+ messages in thread
From: Byron Nikolaidis @ 1998-05-08 21:28 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: Benoit Foucher <bfoucher@pratique.fr>; Jose' Soares Da Silva <sferac@bo.nettuno.it>; Tom Ivar Helbekkmo <tih+mail@Hamartun.Priv.NO>; Dario Fumagalli <dfumagalli@art-media.it>; Paul Lisewski <paull@techone.com.au>; Stephen Davies <scldad@sdc.com.au>; Hannu Krosing <hannu@trust.ee>; Sbragion Denis <infotecn@tin.it>; Olaf Mittelstaedt <mstaedt@va-sigi.va.fh-ulm.de>; Christopher Luk <wluk@hkcccc.org>; Aleksey Demakov <avd@avd.garsib.ru>; Zsolt Varga <redax@agria.hu>; Tony Cowderoy <tony@nthfen.demon.co.uk>
Version .0238 is now at our website.
This version is essentially the same as .0237 but supports some odbc
scalar functions
of the form {fn func(args)}. Sorry, I didn't stick them in earlier but
I forgot.
The functions are CONCAT, LCASE, LENGTH, LOCATE, LTRIM
RTRIM, SUBSTRING, UCASE, and NOW.
Byron
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ANOTHER NEW ODBC DRIVER
@ 1998-05-13 15:09 Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 0 replies; 2+ messages in thread
From: Byron Nikolaidis @ 1998-05-13 15:09 UTC (permalink / raw)
To: Jose' Soares Da Silva <sferac@bo.nettuno.it>; +Cc: pgsql-interfaces
This is the backend "canonifier" problem that was previously discussed on the interfaces list under "New Driver and Unique Indexes".
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_attivita FROM 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' AND gruppo = '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'
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-05-13 15:09 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-05-08 21:28 ANOTHER NEW ODBC DRIVER Byron Nikolaidis <byronn@insightdist.com>
1998-05-13 15:09 Re: ANOTHER NEW ODBC DRIVER Byron Nikolaidis <byronn@insightdist.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox