Re: user meta (to the database, at least) information - Mailing list pgsql-general

From Tom Lane
Subject Re: user meta (to the database, at least) information
Date
Msg-id 6514.982703290@sss.pgh.pa.us
Whole thread Raw
In response to user meta (to the database, at least) information  (Adam Haberlach <adam@newsnipple.com>)
List pgsql-general
Adam Haberlach <adam@newsnipple.com> writes:
> got a QA guy here who says "every other database I've worked with
> lets people add their own fields to the user tables, why can't you
> just do that".

Oh?  News to me.  How does he expect the system to fill the extra
fields?

>     Is it safe to modify pg_shadow?

Strikes me as pretty risky, but you *might* get away with adding
more fields at the end with NULL defaults.  Don't try to add indexes,
constraints, rules or triggers, as they won't work.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: INSERT INTO problem
Next
From: Tom Lane
Date:
Subject: Re: Re: Printing PostgreSQL reports