Обсуждение: 1)Can't compile with ODBC support. 2)FATAL 1: AllocSetAlloc() on Pentium computer.

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

Igor N. Avtaev writes:

> 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! :-(

You're gonna have to, after which you'll immediately encounter linking
problems because the ODBC driver only compiles with GCC.  Fixing that will
require some non-trivial programming work.  Sorry.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

* Peter Eisentraut <peter_e@gmx.net> [001205 11:22]:
> Igor N. Avtaev writes:
>
> > 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! :-(
>
> You're gonna have to, after which you'll immediately encounter linking
> problems because the ODBC driver only compiles with GCC.  Fixing that will
> require some non-trivial programming work.  Sorry.
The UDK FS 7.1.1b DOES accept // comments.

The other issue is more serious.

LER

>
> --
> Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

find . -name "*.[ch]" | xargs perl -i -p -e 's://(.*):/*\1 */:'

>>>>> "Peter" == Peter Eisentraut <peter_e@gmx.net> writes:

    Peter> Igor N. Avtaev writes:
    >> 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! :-(

    Peter> You're gonna have to, after which you'll immediately
    Peter> encounter linking problems because the ODBC driver only
    Peter> compiles with GCC.  Fixing that will require some
    Peter> non-trivial programming work.  Sorry.

    Peter> -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/

Those // comments have been removed from ODBC for 7.1.

> * Peter Eisentraut <peter_e@gmx.net> [001205 11:22]:
> > Igor N. Avtaev writes:
> >
> > > 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! :-(
> >
> > You're gonna have to, after which you'll immediately encounter linking
> > problems because the ODBC driver only compiles with GCC.  Fixing that will
> > require some non-trivial programming work.  Sorry.
> The UDK FS 7.1.1b DOES accept // comments.
>
> The other issue is more serious.
>
> LER
>
> >
> > --
> > Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/
>
> --
> Larry Rosenman                     http://www.lerctr.org/~ler
> Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026