Hi,
Here is a new version of the patch for the hidden column feature with
the following changes:
- Rename the HIDDEN into UNEXPANDED and replace all references to
hidden column into unexpanded column
- Remove changes in the information_schema
- Limit use of the UNEXPANDED attribute to ALTER COLUMN SET/DROP
commands.
- Add a check into SET UNEXPANDED code to verify that there is at
least one column expanded.
- Verify that INSERT INTO table SELECT * FROM table respect the
unexpanded column feature.
- Verify that RETURNING * clause also respect the unexpanded column
feature.
I have kept the behavior on function using the wildcard * which does not
take care of the unexpanded column attribute.
I have not though of other gotcha for the moment, I will update the
patch if other cases come. In psql the Expended information is
displayed when using \d+, perhaps it could be better to see this
information directly with \d so that the information comes to the eyes
immediately.
--
Gilles Darold