Vertica Blog

Vertica Blog

identity

Quick Tip on a blue enter key on a keyboard

Using Fallthrough Authentication

Sruthi Anumula, Senior Database Support Engineer
July 21, 2023

Prior to Vertica 12.0.x, if a user failed to log in with a some authentication method, they could not attempt to log in again with some other method. For example, if a user used failed to log in with hash authentication, they could not attempt to log in with LDAP in the same connection attempt....
Quick Tip - blue button

Copy a Table with an Identity to a Table with an Identity on the Same Database Keeping the Identities in Sync

James Knicely, Vertica Field Chief Technologist
May 25, 2020

An IDENTITY associates a table column with a sequence. This sequence automatically increments the column value as new rows are added. There are some noteable restrictions on IDENTITY columns: You cannot INSERT values manually into an IDENTITY column You cannot UPDATE the values of an IDENTITY column once they has been populated via the sequence...