How to wait and obtain DDL lock on an object
From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: 1997/11/19
Message-ID: <Pine.OSF.3.95.971119084728.13882A-100000_at_gonzo.wolfenet.com>#1/1
Date: 1997/11/19
Message-ID: <Pine.OSF.3.95.971119084728.13882A-100000_at_gonzo.wolfenet.com>#1/1
If I want to obtain an exclusive DML lock on a table, I can say LOCK TABLE <table> IN EXCLUSIVE MODE;
Is there any way that I can obtain a DDL lock on an object in a similar way? I want to be able to regularly rename a table, but I don't want to have to write a loop that tries over and over again until it succeeds.
-- Jeremiah Wilton http://www.wolfenet.com/~jeremiahReceived on Wed Nov 19 1997 - 00:00:00 CET