Re: New system OIDS inside include/catalog/pg_proc.h - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: New system OIDS inside include/catalog/pg_proc.h
Date
Msg-id Pine.LNX.4.30.0201251108150.690-100000@peter.localdomain
Whole thread Raw
In response to New system OIDS inside include/catalog/pg_proc.h  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-hackers
Greg Sabino Mullane writes:

> What are the guidelines for choosing a
> new number when creating (for example) a pg_tempname() function?

Just pick the first one that's available.

~/pgsql/src/include/catalog$ ./unused_oids
3 - 11
90
99
109 - 111
143
652
1076 - 1077
2019
2071 - 9999

Maybe the single-digits should stay reserved for some truly important
objects or magic use, but for any old functionI'd start at 90, or if you
make a group of three functions use 109-111, or if you make a group of 25
objects, start at 2071.  In short, it doesn't matter, but try to make a
little sense.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Jean-Paul ARGUDO
Date:
Subject: Fwd: Re: RTREE Index on primary key generated by a sequence
Next
From: Tom Lane
Date:
Subject: Re: New system OIDS inside include/catalog/pg_proc.h