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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Thu, 27 May 1999 14:29:36 -0400
  • Message-id: <01BEA84D.5A63F140.jt-kirkpatrick@mpsllc.com> <text/plain>

(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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group