Inheritance and changing record types

Started by Bruce Momjianover 23 years ago1 messagesgeneral
Jump to latest
#1Bruce Momjian
bruce@momjian.us

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