Skip site navigation (1) Skip section navigation (2)

illegal page faults. . .

From: JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com>
To: "'pgsql-interfaces(at)hub(dot)org'" <pgsql-interfaces(at)hub(dot)org>
Subject: illegal page faults. . .
Date: 1999-05-27 18:29:36
Message-ID: 01BEA84D.5A63F140.jt-kirkpatrick@mpsllc.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
(msaccess97 / win98, 6.40.0005 odbc driver, postgres 6.4.2, linux mandrake 
5.3) i wrote earlier about getting illegal page faults every time i CLOSE a 
certain form (it lets me use it just fine!) that is used to ADD RECORDS 
only.  well, i have created an ultra-basic form linked to the same database 
as the crashing form -- no vba underlying it, no fancy formats, nothing 
except the fields of the tables dropped in with all default settings.  it 
crashes too!  gotta be in the table or ??.  i am not linking the form to a 
query, but directly to the table.  i have another form linked to the same 
table to edit records only -- it limits you to one record only -- works 
beautifully.  and yet another form showing only limited info from the same 
table, but multiple records (never all), works fine too.  i do have 
declare/fetch on.  the table is huge (>45k records, 14,983,168 bytes).  if 
i try to open the table directly in datasheet view, the odbc driver fails 
-- no explanation, but at least no illegal page fault and i get clammed out 
of access!  i figure that is because of the size of the table.  i have 
cache set to 100, maxvarchar = 550, maxlongvarchar=15000.  in the table i 
have one field varchar(300) and another varchar(550).  a few "checks" 
(state char(2) not null check (state<>' ')). -- ok that's all i know that 
would be suspicious.  but the edit forms work fine.  any ideas???

jt


pgsql-interfaces by date

Next:From: Tom LaneDate: 1999-05-27 20:44:47
Subject: Re: [INTERFACES] Re: [GENERAL] JDBC and insert - stack overflow
Previous:From: Alex TurnerDate: 1999-05-27 17:49:06
Subject: Wierd error when creating a table...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group