hello, i found this ERROR msg at our postgresql log file at one of my client.
what i did is i
1) kill -9 (postmaster process id).
2) remove the postmaster.pid file under /usr/local/pgsql/data/
3) restart the postmaster process.
then no more error msg in the postgresql log file.
problem come back few day later cause when i check the log file this morning, i saw the msg again.
the error msg will come out when we try to read record from the temporary table that created before.
so, i suspect the relid is refer to temporary table.(relation id), right?
what i did just restart the postmaster process should not be enough to solve the problem.. can someone give some advise on how to solve this problem?
Client Server Configuration
Postgresql 7.4.5 version.
Red Hat enterprise server 3.0 version
RAM 512MB
Dell PowerEdge 1800.
Regards
Beh