ERROR: fmgr_info: function 1296284: cache lookup failed

My PostgreSQL (7.1in Redhat Linux 7.2) database server running fine everyday until this morning when I did update for a table, I got ERROR: fmgr_info: function 1296284: cache lookup failed But I don't this message when I update a different table. I have no idea where I should look for and how t

[pgadmin-support] How to partial dump the log in SQL?

I am use Postgres 7.1 going to upgrade to 7.2 run in Redhat Linux 7.2. Each time user do update, insert and delete will save to the logfile, right? 1) Where is that log file? 2 ) How do I do partial dump the log file in SQL statements? For example, I want to dump all log from 6:00 to 9:00 , fr

[pgadmin-support] How to execute my trigger when update certain columns but not all?

Let say I have a table has column1 and column2 and I made a trigger for after INSERT OR UPDATE for each row to execute procedure my_function. What I want is the trigger execute my_function only when column1 is insert or update, but not going to execute my_function when column2 is insert or update

[pgadmin-support] Fast Deletion For Large Tables

I have some tables with huge data. The tables have column timestamp and float. I am try to keep up to 6 day of data values. What I do is execute SQL below from crontab (UNIX to schedule commands). BEGIN; DELETE FROM table_1 WHERE column_time < ('now'::timestamp - '6 days'::interval); . DELET

[pgadmin-support] Timestamp problem

7-15 13:20:00.421+00 Then I got SQLException Bad Timestamp Format at 23 in 2003-07-14 14:45:00.421+00 What is 23? How do I resolve this problem? Thank Q! -- Raymond Chui NWS at NOAA 301-713-0640 ext 168 ---(end of broadcast)--- TIP 3: if posti