[postgis-users] postgis support for 7.4 betas
jeff at propertykey.com
Mon Sep 29 13:29:37 PDT 2003
David Blasby wrote:
> I looked a little deeper. It looks like they changed how binary is
> created/sent around in 7.4. There's not much documentation on it, but
> if you look at the 7.4 description of CREATE TYPE:::
Thanks again for your help. I think I'm learning more than I ever
wanted to know about PostgreSQL.
> So, it looks like we need to change the CREATE TYPE of WKB to (see
> CREATE TYPE wkb (
> internallength = variable,
> input = wkb_in,
> output = wkb_out,
> storage = extended,
> SEND = WKBtoBYTEA
> I havent tried this at all, but I think it should work.
Actually, it should be "send=bytea" instead of "send=WKBtoBYTEA", but
that does the trick when I revert back to the original asbinary function
definition. Besides adding that line, the only other change I made was
that I had to move the function definition of bytea to right before the
"CREATE TYPE" command so it was available for the command.
Now that these two problems have been fixed, everything else that I need
to do seems to be working fine (so far).
More information about the postgis-users