On Fri, 2003-07-25 at 11:49, [EMAIL PROTECTED] wrote:
>
> lock table excl_table in exclusive mode;
That probably wont work, but this will:
EXECUTE ''LOCK TABLE ''
|| quote_ident(excl_table) || '' IN EXCLUSIVE MODE'';
Eric
---(end of broadcast)--
Is it possible to do variable substitution with explicit locks in plpgsql?
Something along the lines of
...
declare
big_string alias for $1;
excl_table text;
begin
--assuming big_string starts with something like table=table1!
excl_table := substr(big_string,7,(position(''!'' in big_string)-7))
