Re: max relations in a single database

Hi Tom,


referring to your other mail: I did a "make distclean", reran "configure"
again, edited the pg_config.h and patched the pl_funcs.c again. I think
this is even more strict than doing "make clean all".

Checking the local machine with memtest and did a RAID check on the
volumes, no errors were found. I can't check the remote machine right now,
as I cannot safely reboot, as the machine has no serial console.

Concerning reindexing the system catalogue, I did this as describes in the
REINDEX manpage, which was very helpful. So I reindexed in "postgres
single user mode" (so to say) and it didn't complain about anything
unusual. I pg_dumpall'ed the database, did initdb just to be on the safe
side and recreated everything.

While importing the dump file I get the following message on my logfile:

RTERangeTablePosn: RTE not found (internal error)

I traced that back to a CREATE VIEW statement:

CREATE VIEW horse_exported_imported_by_year_country
AS
.
.
.

If I copy'n'paste this definition by hand it tells me that it truncates
the identifier:

NOTICE:  identifier "horse_exported_imported_by_year_country" will be
truncated to "horse_exported_imported_by_year"

Can this cause any error as listed above?


Kind regards
... Ralph ...