Inheritance and changing record types - Mailing list pgsql-general

From Greg Stark
Subject Inheritance and changing record types
Date
Msg-id 8765xmpvlh.fsf@stark.dyndns.tv
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: parameterized views?
Next
From: Greg Stark
Date:
Subject: Re: parameterized views?