> Is this telling me that I can't have an index of type int8? Why not?
> FreeBSD 2.2.8, PostgreSQL cvsup'd less than a week ago.
Because I added the int8 data type to the backend without knowing which
platforms would actually support it. (As an aside, I had tried to
solicit results of a small test program for various platforms on the
hackers list, but can't recall getting any responses.)
Without knowing that, it wasn't clear to me whether the int8 would be
able to stay, and I didn't want to embed these changes in the index
support system tables if they would need to be removed. These tables are
the most difficult to configure and support, and it isn't as easy to
trace which entries support which types.
Anyway, it seems int8 indices would be a good feature to have for v6.5,
eh? One could write some user-defined index operators as an interim
solution.
- Tom