Andreas Burkhardt <rootshell(at)web(dot)de> writes:
> 1. adding the new columns to pg_authid?
> 2. CREATE TABLE users (
> email VARCHAR ) INHERITS (pg_authid);
> 3. CREATE TABLE users (
> rolname VARCHAR REFERENCES pg_authid ( rolname ),
> email VARCHAR );
Actually, none of those will work. You can't modify system catalogs (at
least not without a lot of internals work). You can make a users table
OK, you just can't set up a foreign-key linkage to pg_authid ...
regards, tom lane