Re: Columns in pg_shadow? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Columns in pg_shadow?
Date
Msg-id Pine.LNX.4.21.0005201920070.423-100000@localhost.localdomain
Whole thread Raw
In response to Re: Columns in pg_shadow?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Columns in pg_shadow?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane writes:

> > usetrace:
> Searching through the sources shows that this flag is not used anywhere.
> The catalogs.sgml doc file defines it as "can user set trace flags?"
> but whatever code it controlled must be long dead...

Remnants of a three-quarters baked pg_options implementation I suppose.


> > usecatupd:
> >     Ability to change system tables?

> Since there's no really convenient interface for twiddling this flag,
> I doubt anyone actually bothers to change it.  It starts out the same
> as one's usesuper flag, and probably stays that way...

Also note that once you unset this flag you can't set it again because you
no longer have write access to pg_shadow.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-general by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: crash on \copy
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Postgresql OO Patch