<div>På fredag 05. juli 2013 kl. 11:47:22, skrev Tom Dunstan <<a href="mailto:pgsql@tomd.cc"
target="_blank">pgsql@tomd.cc</a>>:</div><blockquotestyle="border-left: 1px solid rgb(204, 204, 204); margin: 0pt
0pt0pt 0.8ex; padding-left: 1ex;"><div dir="ltr">Hi Andreas <div class="gmail_extra"> <div class="gmail_quote">On 5
July2013 18:51, Andreas Joseph Krogh <span dir="ltr"><<a href="mailto:andreak@officenet.no"
target="_blank">andreak@officenet.no</a>></span>wrote: <blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div>I'vebeen
usingHibernate for years with mapping Enums to varchar-columns which works fine. Remember to map them
with</div><div> </div></blockquote><div> </div><divstyle="">I'm not trying to map them to varchar columns - I'm trying
tomap them to columns with postgresql enum types as created by CREATE TYPE, see e.g. <a
href="http://www.postgresql.org/docs/9.2/static/datatype-enum.html"
target="_blank">http://www.postgresql.org/docs/9.2/static/datatype-enum.html</a>.The built-in enum types are designed
forthat purpose, and perform better and more safely than using varchars.</div><div style=""> </div><div
style="">Mappingjava enums to a typesafe and efficient version in the db was the main reason I did the work to add
nativeenums to postgresql in the first place - I haven't had a chance to use it recently, and I'm a bit disappointed
thatit doesn't work out of the box. So I want to fix up whatever parts of the stack are in the way of making that
work.</div></div></div></div></blockquote><div> </div><div>I'msorry, I missread your post.</div><div> </div><div
class="origo-email-signature">--<br/> Andreas Joseph Krogh <andreak@officenet.no> mob: +47 909 56 963<br />
SeniorSoftware Developer / CTO - OfficeNet AS - http://www.officenet.no<br /> Public key:
http://home.officenet.no/~andreak/public_key.asc</div><div> </div>