Postgres Pro
Downloads
Home   >   mailing lists

Re: Zeroing single tuple in data file. - Mailing list pgsql-admin

From Matthew Walden
Subject Re: Zeroing single tuple in data file.
Date
Msg-id AANLkTikbmLb=UyVO+iLMeWu-+7uj2wQeFFJRzQ2B3HwJ@mail.gmail.com
Whole thread Raw
In response to Re: Zeroing single tuple in data file.  (Matthew Walden <matthew.walden@bcs.org>)
Responses Re: Zeroing single tuple in data file.
List pgsql-admin
Tree view
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?

pgsql-admin by date:

Previous
From: Matthew Walden
Date:
Subject: Re: Zeroing single tuple in data file.
Next
From: Lou Picciano
Date:
Subject: binary logs: a location other than pg_xlog??