Oh and could we please have the output from SELECT version(); too please. On Sun, Nov 21, 2010 at 7:56 PM, Matthew Walden <[email protected]>wrote:
> A few more information requests if you don't mind. > > Can you analyze the table ie "ANALYZE USERS" without error? > > Could you please paste the output from "\d+ users". > > And try SELECT COUNT(*) FROM users WHERE id_usr IS NULL; > > Is your database large? Can you shut down the instance cleanly and take a > backup of it before making any further changes? > > Could you also copy the mailing list into your reply please to ensure > others can see and possibly assist? >
