Is it possible to "promote" a record from a base table to an inherited table?
For example, say I have a base table "visitor" and a table that inherits
called "member" that adds columns such as username, password, membership_type,
etc. Is there any way to take an existing visitor record and promote it to a
member without breaking foreign key relationships to the parent visitor
record?
--
greg