* 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.
You don't have a nice little alter...table(s) script you can paste herein, do you? ;-) I'm thinking the only way now is to dumpdb, vi:g/bigint/s//int/g, restore... and hope for the best :-( -------------------------------------------------------- This message was sent using MetroWEB's AirMail service. http://www.metroweb.co.za/ - full access for only R73. Free Web Accelerator, WebMail, Calendar, Anti-Virus, Anti-Spam, 10 emails, 100MB personal webspace, and more! Phone Now! 086 11 11 440