Oh and could we please have the output from SELECT version(); too please.
On Sun, Nov 21, 2010 at 7:56 PM, Matthew Walden
<matthew.walden@bcs.org> 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?