[INTERFACES] Postgres 6.5.1 Error

Morning,

Our Crossover project seems to have presented another test production error.

Last I wrote was how does one get data from one database to another from
within Postgres.

This time I have data that is actually causing postgres to go into a
cascade failure that actually takes down the server.

What we did was take data from an Access97 application. We exported the
tables to a postgres database. We have done this for another Access97
application and have had no probles with it. 

During testing and development of a web application everything worked ok.

When we went into beta test we had one agency that when ever they accessed
their data it would cause postgres to go into a cascade failure and take
the server down. IF I can catch it in time I can kill the process. 


Tech Specs:

Hardware- PII 300 with 128 mg ram         6 gig ide hard drive         2 gig ide hard drive

Software- Apache 1.3.6 Web server         PostgreSQL 6.5.1          Linux 2.2.6         FPK Pascal 0.99.12

FPK pascal uses the libpq library created by the PostgreSQL distribution. I
can also achieve the same results with perl.

Unfortunately, since this is a state agency, I cannot release the full
records. I can say there appears to be control characters in the data.
Specifically 5, 8, and 9. These appear to be unicode characters.

I need to do one of the following:

a> filter the data
b> determine if this was a malicious act or an accident
c> prevent the server from crashing
d> find out if this only affects one agency or if there are    others we
haven't encountered yet. 

Thanks,

-Rob




************