Delphi Error - Mailing list pgsql-interfaces
From | Fabrizio Giammatteo |
---|---|
Subject | Delphi Error |
Date | |
Msg-id | 37D4B05E.A9DA7A8D@fgiamma.org Whole thread Raw |
List | pgsql-interfaces |
Hi, I'm using PsqlODBC (v06-40-0007) on a win 98 machine to access data on a Linux Suse 6.1 Server. I've PostgreSQL version 6.5 on my server machine and all seems to work fine. But if I've a Memo Box, and I press more than one time the button "refresh", the program crash. I've tried to modify ODBC settings and the system works only if I uncheck "Text as a long varchar", but this limit my memo fields to 254 chars. If I uncheck "Text as a long varchar" and increase "Max varchar" over 254 the system crash too. Can you help me ? Thanks Here the logs and in attach the ODBC SQL.LOG This is the win98 error: ------------------------------------------------------------------------------------ TESTPG ha provocato un errore di pagina non valida nel modulo KERNEL32.DLL in 0167:bff87eb5. Registri: EAX=c00300f0 CS=0167 EIP=bff87eb5 EFLGS=00010212 EBX=006df748 SS=016f ESP=005dff98 EBP=005e0004 ECX=006e0000 DS=016f ESI=816122c4 FS=1887 EDX=388b5708 ES=016f EDI=4be50802 GS=0000 Byte all'indirizzo CS:EIP: 53 56 57 8b 30 83 7d 10 01 8b 4e 38 89 4d f8 75 Immagine dello stack: This is the psqlODBC log --------------------------------------------------------------------------------------------- DSN info: DSN='PostgreSQL',server='www.allnet.it',port='5432',dbase='testpg',user='',passwd='' readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0' conn_settings='' translation_dll='',translation_option='' conn = 55052412, SQLConnect(DSN='PostgreSQL', UID='fgiamma', PWD='skywalker') Global Options: Version='06.40.0007', fetch=100, socket=4096, unknown_sizes=2, 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=0, bools_as_char=1 extra_systable_prefixes='dd_;', conn_settings='' conn=55052412, query=' ' conn=55052412, query='set DateStyle to 'ISO'' conn=55052412, query='set geqo to 'OFF'' conn=55052412, query='set ksqo to 'ON'' conn=55052412, query='select oid from pg_type where typname='lo'' [ fetched 0 rows ] conn=55052412, query='select relname, usename, relhasrules from pg_class, pg_user where relkind = 'r' and relname like 'testpg' and relname !~ '^pg_|^dd_' and relname !~ '^xinv[0-9]+' and int4out(usesysid) = int4out(relowner)order by relname' [ fetched 1 rows ] conn=55052412, query='select u.usename, c.relname, a.attname, a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules from pg_user u, pg_class c, pg_attribute a, pg_type t where int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'testpg' order by attnum' [ fetched 3 rows ] conn=55052412, query='select u.usename, c.relname, a.attname, a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules from pg_user u, pg_class c, pg_attribute a, pg_type t where int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'testpg' order by attnum' [ fetched 3 rows ] conn=55052412, query='select c.relname, i.indkey, i.indisunique, i.indisclustered, c.relhasrules from pg_index i, pg_class c, pg_class d where c.oid = i.indexrelid and d.relname = 'testpg' and d.oid = i.indrelid' [ fetched 1 rows ] conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg" ORDER BY "codice" ASC ' [ fetched 9 rows ] conn=55052412, query='SELECT COUNT(*) FROM "testpg" WHERE "codice"=3 AND "nome"='dddddd'' [ fetched 1 rows ] conn=55052412, query='BEGIN' conn=55052412, query='UPDATE "testpg" SET "note"='bòa ba dddddd dddddd' WHERE "codice"=3 AND "nome"='dddddd'' conn=55052412, query='COMMIT' conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg" WHERE "codice"=3' [ fetched 1 rows ] conn=55052412, query='SELECT COUNT(*) FROM "testpg" WHERE "codice"=6 AND "nome"='aadsfdsafadsfa'' [ fetched 1 rows ] conn=55052412, query='BEGIN' conn=55052412, query='UPDATE "testpg" SET "note"='pkpkmsmssdddddssssd d dsaf dsa fsddsjjksijdu' WHERE "codice"=6 AND "nome"='aadsfdsafadsfa'' conn=55052412, query='COMMIT' conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg" WHERE "codice"=6' [ fetched 1 rows ] conn=55052412, query='BEGIN' conn=55052412, query='DELETE FROM "testpg" WHERE "codice"=5 AND "nome"='ddddd'' conn=55052412, query='COMMIT' conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg" WHERE (("codice" IS NULL OR "codice"> 6)) ORDER BY "codice" ASC ' [ fetched 3 rows ] conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg" WHERE "codice"=6' [ fetched 1 rows ] conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg" WHERE ("codice"< 6) ORDER BY "codice" DESC ' [ fetched 4 rows ] conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg" WHERE "codice"=4' [ fetched 1 rows ]
Attachment
pgsql-interfaces by date: