Re: [COMMITTERS] pgsql: /contrib/cube improvements: Update

I'm not sure exactly what to do here. I tried simply doing

CREATE TYPE cube;

But I still get NOTICE's to the effect of "return type cube is only a
shell" or "argument type cube is only a shell".

I'm not sure how to do this to get zero NOTICES.

Advice appreciated.

Josh Reich

Tom Lane wrote:
> Joshua Reich <josh(at)root(dot)net> writes:
>>> The problem is that there are new functions in cube.sql, so the output
>>> is now different and breaks the diff (to state the obvious).
>
> Actually, the new theory on this is that you should explicitly create
> a shell type first:
>
> CREATE TYPE cube;
>
> and then create the functions, and then make the type "for real".
>
> This will still involve a change in the earthdistance expected
> output (down to zero expected NOTICEs) but if we're gonna fix it
> then let's fix it right.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

--
Joshua Reich
Finance and Corporate Development
ROOT Exchange, A Division of ROOT Markets
601 W. 26th St. / Suite 1500
New York, NY 10001
W - (212) 645 6320 x 7101
M / T - (646) 427 7959
E - josh(at)rootexchange(dot)com