Skip site navigation (1) Skip section navigation (2)

Re: objects tied to missing extension

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Phil Sorber <phil(at)omniti(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: objects tied to missing extension
Date: 2011-11-28 21:10:11
Message-ID: 23211.1322514611@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Phil Sorber <phil(at)omniti(dot)com> writes:
> I am still able to reproduce the "ERROR:  cache lookup failed for extension
> xxxxx" if I use an explicit 'drop extension'. I am unsure how I can
> reverse the state it is now in. I assume there is some system catalog
> I can edit that will fix it?

I think you have some dangling entries in pg_depend --- manually
deleting any rows that reference the missing pg_extension OID should fix
it.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Phil SorberDate: 2011-11-28 21:14:41
Subject: Re: objects tied to missing extension
Previous:From: Phil SorberDate: 2011-11-28 21:05:41
Subject: Re: objects tied to missing extension

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group