Locking for function creation - Mailing list pgsql-general

From Mark Morgan Lloyd
Subject Locking for function creation
Date
Msg-id 4573036D.252190AD@telemetry.co.uk
Whole thread Raw
Responses Re: Locking for function creation  (Richard Huxton <dev@archonet.com>)
List pgsql-general
If there's a risk that multiple clients will try to execute a 'create or replace
function' simultaneously, what's the recommended practice for putting it in a
transaction and/or locking it? If a lock's incolved what should this be applied
to- the table that the function is most likely to be involved with, an arbitrary
table, or a dummy table specifically reserved for this purpose?

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

pgsql-general by date:

Previous
From: "tam wei"
Date:
Subject: Storing files in postgres db
Next
From: Tom Lane
Date:
Subject: Re: Concatenate performance question