'CREATE OR REPLACE FUNCTION' behavior whenever a transaction is running

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: joao(at)e3c(dot)com(dot)br
Subject: 'CREATE OR REPLACE FUNCTION' behavior whenever a transaction is running
Date: 2022-04-20 18:02:49
Message-ID: 165047776965.683.11067605937815363802@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/sql-createfunction.html
Description:

The page does not mention what is the default behavior whenever a function
is replaced while the same function is being used in another
query/transaction.

Does the query fail? Does the 'CREATE OR REPLACE' operation fail? Does the
query finish before the function is replaced?

As a side note, my interest in this came from our need to use 'C-Language
Functions', aka binary functions, so it would be neat to also add what is
the behavior on those as well, if there's any difference.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2022-04-20 18:46:30 What is a "simple expression"?
Previous Message Erikjan Rijkers 2022-04-13 18:11:43 Re: Add further details to ROW SHARE table level lock modes section