On Aug 21, 2013, at 4:13 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> test=# create cast (source as oid) without function; >> ERROR: enum data types are not binary-compatible > > The reason for that is you'd get randomly different results on another > installation. In this particular application, I think David doesn't > really care about what values he gets as long as they're distinct, > so this might be an OK workaround for him. But that's the reasoning > for the general prohibition.
I’m okay with my function that casts to text, at least for now. An integer would be nicer, likely smaller for my index, but not a big deal. David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
