Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum error - Mailing list pgsql-admin

From Tom Lane
Subject Re: vacuum error
Date
Msg-id 21089.1015617905@sss.pgh.pa.us
Whole thread Raw
In response to vacuum error  ("Zhang, Anna" <azhang@verisign.com>)
List pgsql-admin
Tree view 
"Zhang, Anna" <azhang@verisign.com> writes:
> ERROR: RelationBuildTriggers: 2 record(s) not found for rel domain.

> I deleted triggers that referenced domain before vacuum, is this the cause?

If you deleted them via "delete from pg_trigger" and not by DROP
TRIGGER, then yes.

You'll need to manually fix the value of pg_class.reltriggers for that
table.

            regards, tom lane

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: vacuum error
Next
From: Felipe Nascimento
Date:
Subject: column name length