Thread: Inheritance and changing record types

Inheritance and changing record types

From
Greg Stark
Date:
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