C.reltriggers does not exist issue

Asked By 1220 points N/A Posted on -
qa-featured

Hi folks,

I used PostgreSQL 8.4.1 on a Linux server for a long time and it was running great, but I noticed one day in one of the databases I use, the following problem exists:

An error occurred while performing the operation.

An error occurred while performing the operation.

Error: column c.reltriggers does not exist

Position: 190

Show more details about the problem.

More Details

After much analysis, I came to a point from searching the archives reltriggers was changed in 8.4. Now I cannot point out what to do about it. Is there a fix for SQL or I will just apply or run to fix this issue, or would it be possible to dump all data and re-import it? I hope there are guys who experienced the same scenario as me, and share their ideas on how to resolve this.

Thanks.

SHARE
Answered By 0 points N/A #123645

C.reltriggers does not exist issue

qa-featured

Hi there Dinacallway!

I have solved this problem by running a dbtool on the server database. I used this code: dbtool path-to database/databasename. Do this by either exporting to a file or export to SQL with an option to scan and fix by:

1. Number of threads (depending on the CPU).

2. Version padding.

3. All tables.

4. All areas.

5. Log-on level and output choice.

The DBtool code corrects the field width. The length of fields in SQL is indefinite by default. And since it is required to have a fixed parameter, you will encounter an error at initial stage. Running this DBtool requires scanning of the entire database for fields which exceeds the required parameter. Modify and update accordingly. I hope your problem will be okay after doing the steps stated here.

Best,
Lisa.

Login/Register to Answer

Related Questions