Michael Fuhr <mike(at)fuhr(dot)org> writes:
> In the following message, the OP says that CREATE TYPE works if he
> installs PostgreSQL as a service but it doesn't work if he installs
> PostgreSQL as a program (can anybody think of why this would make
> a difference?).
I found it just about impossible to believe ;-)
I have seen people make such reports because they mistakenly connected
to some other server entirely while trying to test one of the two
supposedly similar installations. If the other server is of an old
version then it might not have CREATE TYPE AS, for instance.
regards, tom lane