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