Re: New system OIDS inside include/catalog/pg_proc.h

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: New system OIDS inside include/catalog/pg_proc.h
Date: 2002-01-25 16:11:34
Message-ID: Pine.LNX.4.30.0201251108150.690-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-01-25 16:32:37 Re: RTREE Index on primary key generated by a sequence
Previous Message Tom Lane 2002-01-25 16:04:12 Re: New system OIDS inside include/catalog/pg_proc.h