Can we Lock Table??

[rajasekhart]

HI,

Can a user lock a table in vertica?

As Oracle having the syntax as follows
Lock table <Table_Name> Exclusive Mode ;

Do Vertica have this kind of facility??

Thanks,
Raj!!

[JimKnicely]

Hi,

You can use the LOCK TABLE <<table_name>>; command to lock a table in Vertica.

This will issue a "X" exclusive lock on table. You can check this in the LOCKS system table.

[scutter]

The LOCK TABLE statement isn't in the documentation. Personally I wouldn't rely on anything that isn't documented.

You can get an X lock in a supported way using SELECT … FOR UPDATE.

[JimKnicely]

C'mon! Live a little. Using an undocumented feature is certainly more exciting than boring documented features Just kidding. I think Vertica included the LOCK TABLE command to be compatible with Oracle.