Re: System vs non-system casts

From: Alvaro Herrera
Subject: Re: System vs non-system casts
Date: ,
Msg-id: 20050412171249.GD25114@dcc.uchile.cl
(view: Whole thread, Raw)
In response to: Re: System vs non-system casts  (Andrew - Supernews)
Responses: Re: System vs non-system casts  (Tom Lane)
List: pgsql-hackers

Tree view

System vs non-system casts  ("Jim C. Nasby", )
 Re: System vs non-system casts  (Robert Treat, )
 Re: System vs non-system casts  (Andrew - Supernews, )
  Re: System vs non-system casts  (Tom Lane, )
 Re: System vs non-system casts  ("Michael Paesold", )
  Re: System vs non-system casts  (Alvaro Herrera, )
   Re: System vs non-system casts  (Tom Lane, )
 Re: System vs non-system casts  ("Michael Paesold", )
  Re: System vs non-system casts  (Alvaro Herrera, )
   Re: System vs non-system casts  (Tom Lane, )
    Re: System vs non-system casts  ("Jim C. Nasby", )
 Re: System vs non-system casts  (Andrew - Supernews, )
  Re: System vs non-system casts  (Alvaro Herrera, )
   Re: System vs non-system casts  (Tom Lane, )

On Tue, Apr 12, 2005 at 05:04:03PM -0000, Andrew - Supernews wrote:
> On 2005-04-12, Alvaro Herrera <> wrote:
> >> Well perhaps there is an even better solution?
> >
> > What about the simple one of having a bool "pg_cast.castissystem"
> > column, or something similar?
> 
> Checking the OID might be sufficient if it were possible to make the OID
> counter restart at some value known to be greater than any datlastsysoid,
> rather than restarting at BootstrapOid.

In fact AFAICT it does start at BootstrapObjectIdData, which is 16384 by
default.

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
Management by consensus: I have decided; you concede.
(Leonard Liu)



pgsql-hackers by date:

From: Alvaro Herrera
Date:
Subject: Re: recovery from idiot delete error
From: Tom Lane
Date:
Subject: Simplifying bootstrap OID assignment