Re: Restoring a pg_dump fails with

Hello Tom!

I would like to contact you again with two phenomenas which are
important
in my opinion:

1. The error "Memory exhausted in AllocSetAlloc(32)" is there on the
"delete from table" command, also.

2. There are some warnings during compilation which seems to be strange.

to 1.:
The following protocol will show the effect of "Memory exhausted":

sh-2.04$ psql wetter

Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms

\h for help with SQL commands

\? for help on internal slash commands

\g or terminate with semicolon to execute query

\q to quit

wetter=# vacuum analyze wetter;

VACUUM

wetter=# delete from wetter;

ERROR: Memory exhausted in AllocSetAlloc(32) <-----------
!!!!!!!!!

wetter=# select count(*) from wetter;

count

---------

4457236

(1 row)

wetter=# \quit

To 2:
During compilation there are the following warnings:

cc -std -O4 -Olimit 2000 -I../../../../src/include -c -o regproc.o
regproc.c

cc: Info: regproc.c, line 140: In this statement, an array subscript
expression is either less than zero or greater than the largest value
that can be represented by the size_t type. (badsubscript)

result = (RegProcedure) heap_getattr(proctup,

cc -std -O4 -Olimit 2000 -I../../../../src/include -c -o inval.o
inval.c

cc: Info: inval.c, line 180: In this statement, an array subscript
expression is either less than zero or greater than the largest value
that can be represented by the size_t type. (badsubscript)

((InvalidationUserData *) entry)->dataP[-1] =

------------------------------------------------^

cc: Info: inval.c, line 202: In this statement, an array subscript
expression is either less than zero or greater than the largest value
that can be represented by the size_t type. (badsubscript)

&((InvalidationUserData *) invalid)->dataP[-1];

-------------------------------------------------------------------^

There are some more warnings regarding the imcompatability between
'char' and 'unsigned char'
which I do not regard as serious.

Hoping to help in a way!
--
Mit freundlichen Gruessen / With best regards
Reiner Dassing