Re: [HACKERS] current CVS snapshot of pgsql crash ...

> This happens, when I want do this:
> (4) $ sql
> Welcome to the POSTGRESQL interactive sql monitor:
> Please read the file COPYRIGHT for copyright terms of POSTGRESQL
> [PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc egcs-2.91.66]
>
> type \? for help on slash commands
> type \q to quit
> type \g or terminate with semicolon to execute query
> You are currently connected to the database: david
>
> david=> create table t (e oid);
> CREATE
> david=> insert into t values (lo_import('/tmp/1'));
> INSERT 19000 1
> david=> \d
> Database = david
> +------------------+----------------------------------+----------+
> | Owner | Relation | Type |
> +------------------+----------------------------------+----------+
> | david | t | table |
> | david | xinx18986 | index |
> +------------------+----------------------------------+----------+
>
> david=> select textout(byteaout(odata)) from xinv18986;
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> We have lost the connection to the backend, so further processing is impossible. Terminating.
>
>
> And in log is:
> Jun 2 22:56:27 chameleon PGSQL: FATAL 1: Memory exhausted in AllocSetAlloc()
>
> ================================
> File /tmp/1 contains:
> djdjd
> djdjdjd
> djdjdjdjdjdj
> ddjdjdjjd
> djdjdjjjdjdjdjdjd
> djdjdj
>
> This example doesn't have good meaning, but I dont like crash of my
> database ...

Yes, I see your point.

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