Skip to content

In environments using PostgreSQL as the database, application errors occur and export is not possible (cases where "PostgresException: 54000" exception is recorded in Syslogs)

Answer

It is necessary to reduce the number of columns to export, reduce links, or split the output to keep the result within PostgreSQL's column limit of 32,767 for joined tables.

Overview

Pleasanter performs table JOIN processing according to link settings between tables when exporting (database queries).

When numerous links are configured in a table, the number of columns in the JOINed result may exceed PostgreSQL's column limit of 32,767 for joined tables, causing Pleasanter application errors. The column limit of 32,767 is a PostgreSQL specification and cannot be changed.

It is necessary to reduce the number of columns to export, reduce links, or split the output to keep the result within the limit.

Operation Steps

Follow the steps below to investigate whether this FAQ applies.

  1. Check and obtain the system log in Pleasanter.
  2. Check if the exception "PostgresException: 54000: joins can have at most 32767 columns" is recorded.