Re: cache lookup failed for function 72629

I'm not exactly sure what was wrong. But I tried making a change on another database on the same server and it was ok. So I thought deleting the problem database and restoring it again would do the trick and it did. So problem solved I guess. Although I'm still not sure what happened . . .

LW . . . Lawrence

From: lawrencew00(at)hotmail(dot)com
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
CC: mmoncure(at)gmail(dot)com; pgsql-general(at)postgresql(dot)org
Subject: RE: [GENERAL] cache lookup failed for function 72629
Date: Tue, 14 Jul 2009 14:33:19 +0000

I guess I'll ask on the slony-i mailing list also. thanks for your hlep.

LW . . . Lawrence

> To: lawrencew00(at)hotmail(dot)com
> CC: mmoncure(at)gmail(dot)com; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] cache lookup failed for function 72629
> Date: Tue, 14 Jul 2009 10:18:10 -0400
> From: tgl(at)sss(dot)pgh(dot)pa(dot)us
>
> Lawrence Wong <lawrencew00(at)hotmail(dot)com> writes:
> > 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.
>
> Hmm, try asking about it on the Slony mailing lists. Slony is known to
> cause strange errors if you do something it's not expecting. I suspect
> that the missing function is actually a Slony trigger function, in which
> case you could probably clean up by dropping the trigger --- but get
> some help first, or you may mess up Slony even further.
>
> regards, tom lane

Internet Explorer 8 makes surfing easier. Get it now!
_________________________________________________________________
Attention all humans. We are your photos. Free us.
http://go.microsoft.com/?linkid=9666046