While I'm at it and before I forget the 76 places one needs to edit to
add/remove a system catalog column, what are people's feelings about the
usecatupd column?

The use of this field is that, if false, it disallows any direct
modification of system catalogs, even for superusers.  In the past there
were several opinions that this field was useless/confusing/stupid/not
worthwhile.

I'm also going to remove the usetrace column, since that's not used.

(post-7.1 material, btw.)

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Tue, 23 Jan 2001 21:23:30 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
pg_shadow.usecatupd attribute

Yes, I vote for removal.

> While I'm at it and before I forget the 76 places one needs to edit to
> add/remove a system catalog column, what are people's feelings about the
> usecatupd column?
> 
> The use of this field is that, if false, it disallows any direct
> modification of system catalogs, even for superusers.  In the past there
> were several opinions that this field was useless/confusing/stupid/not
> worthwhile.
> 
> I'm also going to remove the usetrace column, since that's not used.
> 
> (post-7.1 material, btw.)
> 
> -- 
> Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/
> 
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 23 Jan 2001 15:28:42 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: pg_shadow.usecatupd attribute
Peter Eisentraut <peter_e@gmx.net> writes:
> While I'm at it and before I forget the 76 places one needs to edit to
> add/remove a system catalog column, what are people's feelings about the
> usecatupd column?

Unless someone pops up and says that they're actually using it,
I'd agree with removing it.  It seems like the sort of thing that
might be a good idea but isn't actually getting used.

			regards, tom lane

Tue, 23 Jan 2001 17:08:47 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_shadow.usecatupd attribute 
Just to clarify for stupid me: you want to remove it and forbid catalog
updates or remove it and allow catalog updates? (I hope its latter :)

On Tue, 23 Jan 2001, Tom Lane wrote:

> Peter Eisentraut <peter_e@gmx.net> writes:
> > While I'm at it and before I forget the 76 places one needs to edit to
> > add/remove a system catalog column, what are people's feelings about the
> > usecatupd column?
> 
> Unless someone pops up and says that they're actually using it,
> I'd agree with removing it.  It seems like the sort of thing that
> might be a good idea but isn't actually getting used.
> 
> 			regards, tom lane
> 
> 


Tue, 23 Jan 2001 21:15:54 -0500 (EST)
Alex Pilosov <alex@pilosoft.com>
Re: pg_shadow.usecatupd attribute 
Alex Pilosov <alex@pilosoft.com> writes:
> Just to clarify for stupid me: you want to remove it and forbid catalog
> updates or remove it and allow catalog updates? (I hope its latter :)

Right, the latter.  If anyone is actually using usecatupd to prevent
themselves from shooting themselves in the foot, speak now or forever
hold your peace ...

			regards, tom lane

Tue, 23 Jan 2001 23:32:19 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_shadow.usecatupd attribute 