Postgres trigger database connection release time

Question

Please accept my apologies for the basic question but I can't seem to find the answer to this basic question online.

I have a few triggers on my Postgres database that run on insert/update and I'm wondering if the database releases the connection to my server application after the triggering sql or after the trigger completes? Makes sense to me that the database would release the connection on completion of the triggering sql, am I right??

Craig Ringer · Accepted Answer · 2016-02-02 14:34:11Z

1

The statement returns success/failure only once all triggers have run to completion.

The database doesn't hold a connection to the server. It's the opposite. The server releases connection to the database (back to a pool, usually) once it's done with using it, usually after completion of a transaction. In the simplest case that's a single statement.

answered Feb 2, 2016 at 14:34

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres trigger database connection release time

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related