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@root.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@rootexchange.com