Hello,
I'm trying to create a custom inetrange type. This works:
CREATE TYPE inetrange AS RANGE (
subtype = inet,
subtype_diff = inet_diff
);
But since inet is discrete, not continuous, I'd like to define a
canonical function too:
CREATE TYPE inetrange AS RANGE (
subtype = inet,
subtype_diff = inet_diff,
canonical = inetrange_canonical
);
But of course I can't define the function until I have the type, and I
can't define the type until I have the function.
Now the docs address this
(https://www.postgresql.org/docs/9.5/static/sql-createtype.html), and
recommend:
> Creating a canonical function is a bit tricky, since it must be
defined before the range type can be declared. To do this, you must
first create a shell type, which is a placeholder type that has no
properties except a name and an owner. This is done by issuing the
command CREATE TYPE name, with no additional parameters. Then the
function can be declared using the shell type as argument and result,
and finally the range type can be declared using the same name. This
automatically replaces the shell type entry with a valid range type.
The problem is this (tried on 9.3 and 9.5):
db=> create type inetrange;
ERROR: must be superuser to create a base type
So I'm wondering whether there is any way around this circle without
being a superuser?
Thanks!
Paul
