Hello all! Help me, please.
---------------------------------------------------------------
*** First trouble:
I execute:
$ psql mydb
mydb=> \i myrequest
mydb=> \g
If results have > N rows,
the psql-command output to display the message:
"FATAL 1: Memory exhausted in AllocSetAlloc()
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormaly
before or while processing the request.
psql: connection to server was lost"
and fine execute if results have < N rows.
N ~ 40.000 rows.
What can I do?
Thank you.
---
My configuration:
HP Netserver E30 (Pentium 166MHz/ 128Mb RAM/ 4Gb and 9Gb Wide-SCSI HDD)
SCO UnixWare 2.1.3
Perl 5.004_04
DBI 1.14
DBD::Pg 0.95
PostgreSQL 7.0.3
On Pentium Pro server my SQL-request work fine if result have any N
rows!
--------------------------------------------------------------
*** Second trouble:
I can't compile PostgreSQL 7.0.3 (and 7.0.2) with ODBC support.
UnixWare C compiler not understand comment: "//"
Compiler understand only brackets of comment "/*" and "*/".
I can't change all comments! :-(
Best regards,
Igor Avtaev