I had been using Slony-I together with another database on a server on a different machine. I had been testing my replication constantly dropping and creating my Slony-I tables. This is not out of the ordinary though. I had been doing this for many days now.
The query, I had been doing is just an update or insert into any table in this database. There are about 40 tables. Any change to the tables in the database results in this error. Like I said, I had restarted the PostgreSQL service several times as well as restarted my Server several times to no avail. I am pretty stumped and am not sure what to do short of a complete uninstall and reinstall of PostgreSQL. Although I am not sure that would work at this point. Probably because I'm still not sure what this error means. Once again, like I said, it is just a simple update or insert into my tables. I had been doing this function just a couple minutes earlier to this message and did not do anything out of the ordinary in the time between.
> Date: Tue, 14 Jul 2009 09:16:05 -0400
> Subject: Re: [GENERAL] cache lookup failed for function 72629
> From: mmoncure@gmail.com
> To: lawrencew00@hotmail.com
> CC: pgsql-general@postgresql.org
>
> On Tue, Jul 14, 2009 at 9:12 AM, Lawrence Wong<lawrencew00@hotmail.com> wrote:
> > I'm sorry. What does 're-applying the function source' mean? and how would
> > I do it?
> >
> > For the 'change to the table' I was talking about, I just tried to do a
> > regular update on the table using pgAdmin III.
> >
> > LW . . . Lawrence
> >
>
> well, the idea is to find the function that is causing the problem,
> make a change, and save it back with pgadmin. still, this shouldn't
> be happening, and a database restart should certainly have fixed it.
> do we have any context for this error? do you know the query that is
> causing it?
>
> merlin
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
We are your photos. Share us now with
Windows Live Photos.
