Re: locks and variable substitution

From: Eric Clark <eclark(at)zerohp(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: locks and variable substitution
Date: 2003-07-25 19:57:12
Message-ID: 1059163033.27029.7.camel@eric
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 2003-07-25 at 11:49, gack(at)verizon(dot)net 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Elielson Fontanezi 2003-07-25 20:20:15 RES: ERROR: DefineIndex: index function must be marked iscachable
Previous Message Stephan Szabo 2003-07-25 19:47:24 Re: ERROR: DefineIndex: index function must be marked