Lock table in non-volatile functions - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Lock table in non-volatile functions
Date
Msg-id 45FA5B26.7040706@bigfoot.com
Whole thread Raw
Responses Re: Lock table in non-volatile functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,
I'm observing that is not allowed to LOCK a table in a
STABLE/IMMUTABLE function but at same time is allowed
a SELECT FOR UPDATE.

Is that normal?




-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFF+lsm7UpzwH2SGd4RAjloAJ4j/AOdJhGMRnvM/TKVpKHPwesAOACeO4mT
OQhSwR1of3xS7HSSvtjGiQc=
=nFFM
-----END PGP SIGNATURE-----


pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: pltcl vs. multilib machines
Next
From: Grzegorz Jaskiewicz
Date:
Subject: Re: [RFC] CLUSTER VERBOSE