strk <[EMAIL PROTECTED]> writes:
> On Wed, Mar 23, 2005 at 01:48:11PM +, Richard Huxton wrote:
>> *What* is giving this error? Something seems to be holding onto a
>> reference to (at a guess) your temporary table. Can you identify what?
> Whatever is called from create temp table ..
"\set V
On Wed, Mar 23, 2005 at 02:49:53PM +, Richard Huxton wrote:
> strk wrote:
> >On Wed, Mar 23, 2005 at 01:48:11PM +, Richard Huxton wrote:
> >
> >>strk wrote:
> >>
> >>>Hello.
> >>>A memory fault in a trigger left my database
> >>>in a corrupted state:
> >>>
> >>
> >>> - I can't create temp
strk wrote:
On Wed, Mar 23, 2005 at 01:48:11PM +, Richard Huxton wrote:
strk wrote:
Hello.
A memory fault in a trigger left my database
in a corrupted state:
- I can't create temporary tables anymore
(restart/vacuum full don't help)
ERROR: cache lookup failed for r
On Wed, Mar 23, 2005 at 01:48:11PM +, Richard Huxton wrote:
> strk wrote:
> >Hello.
> >A memory fault in a trigger left my database
> >in a corrupted state:
> >
>
> > - I can't create temporary tables anymore
> > (restart/vacuum full don't help)
> > ERROR: cache lookup failed
strk wrote:
Hello.
A memory fault in a trigger left my database
in a corrupted state:
- I can't create temporary tables anymore
(restart/vacuum full don't help)
ERROR: cache lookup failed for relation 1250714
*What* is giving this error? Something seems to be holding o
Hello.
A memory fault in a trigger left my database
in a corrupted state:
- A temporary table listed in pg_class
was not accessible with a select
- I could not DROP it
- I deleted the record from pg_class
- I can't create temporary tables anymore
