Hi Josh,
I think that any special "features" common to all on system tables would
go nicely near the top of 44.1 "System Catalogs Overview". That plus a
specific error message, not just a "PERMISSION DENIED", so that someone
like me can put the error message in the PostgreSQL.org search box to
fi
Greg,
this despite PostgreSQL happily accepting:
GRANT REFERENCES ON pg_namespace TO greg;
We should probably error out on this.
I found the change in tablecmds.c and a mention of it in PostgreSQL
Weekly News - May 17 2009, yet I don't understand why referencing
a system table in this m
"J. Greg Davidson" writes:
> from my code which has a column
> schema_name name NOT NULL REFERENCES pg_namespace ON DELETE CASCADE
You can't do that; it never has worked and is not likely to work in the
foreseeable future, because we don't support triggers on system catalogs.
Perhaps the syst
