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(dot)walden(at)bcs(dot)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?
>