C.reltriggers does not exist issue

Asked By dinacallway 1220 points N/A Posted on - 06/14/2011

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.

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.

• Status: Open
• Question Views: 2262
• Answer Count: 1
• Vote Up 20 Vote Down

• Answer Accepted: No
• Question Category: PostgreSQL

Answered By Lisa_drew 0 points N/A #123645

C.reltriggers does not exist issue

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.

About Lisa_drew

Questions
0

Answers
3

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 06/19/2011
• Question Category: PostgreSQL