I haven't used that, yet. But this has me confused:

"An automatically updatable view may contain a mix of updatable and non-updatable columns. A column is updatable if it is a simple reference to an updatable column of the underlying base relation; otherwise the column is read-only, and an error will be raised if an INSERT or UPDATE statement attempts to assign a value to it."

Isn't splitting full_name into two columns a complex reference (for lack of a better word)?