29 Jul
2004
29 Jul
'04
11:26 a.m.
* Henry Combrinck
aah, crap, you're right! I had no idea pg7.4 ignored indexes if the types weren't *exactly* the same.
Charming, innit?
system_user.id is integer...
Not to mention literal integers, which really bites...
crikey, will need to monitor this and see what other tables are buggered.
I've simply converted all bigint columns to int in my installations. No adverse effects so far. Arne.