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?
- 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';
SETpostgres=# select pg_sleep(3000);
ERROR: canceling statement due to statement timeout
postgres=#
You second message is likely from your client/application, not PostgreSQL
- 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.
- 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.