Re: Request for Official Technical Clarification on PostgreSQL statement_timeout Error

Поиск
Список
Период
Сортировка
Искать

Re: Request for Official Technical Clarification on PostgreSQL statement_timeout Error

От:
"David G. Johnston" <david.g.johnston@gmail.com>
Дата:
On Mon, Nov 9, 2026 at 5:47 AM 이정호 <curly2620@nate.com> wrote:

Hello,

I am an automation system engineer in South Korea.

Our application executes SQL INSERT statements on a PostgreSQL database using VBScript.

During execution, we encountered the following error:

canceling statement due to statement timeout

Error while executing the query

We would like to obtain a technical clarification regarding the exact meaning of this error.

According to the PostgreSQL documentation, statement_timeout is measured from the time a command arrives at the server until it is completed.

Could you please confirm the following?

  1. Does this error indicate that PostgreSQL received the SQL command and canceled it because the configured statement_timeout limit was exceeded?
Trivial to find out what error message that error triggers:
 
postgres=# set statement_timeout = '1s';
SET
postgres=# select pg_sleep(3000);
ERROR:  canceling statement due to statement timeout
postgres=# 

You second message is likely from your client/application, not PostgreSQL

  1. Are SQL syntax errors, data type errors, and constraint violations reported separately from statement_timeout errors?
Yes. The first one encountered is reported.  As is typical with nearly all software.
  1. Does this error confirm that the SQL statement was not completed within the configured time limit after reaching the PostgreSQL server?
"The timeout is measured from the time a command arrives at the server" = "after reaching the PostgreSQL server"

David J.

FAQ