Re: "relation deleted while in use" encountered with Postgresql 8.0.8

On Thu, Nov 29, 2007 at 02:44:25PM -0800, Gautam Sampathkumar wrote:
> Hi,
>
> I'm using a python script w/ the PyGreSQL library to insert 1 billion rows
> into a database table for an experiment (performing a commit every 10K
> rows). My script failed at about 170M rows with the following exception:

You don't indicate your version so it could be XID wraparound, but
you'd have to be running a pretty old version to run into that still...

> After this error, my database table no longer exists and appeared to have
> been dropped, although my script was doing only INSERT statements. Any ideas
> on what might be causing this and/or if this a known issue and possible
> solutions would be greatly appreciated.

Do you run VACUUM regularly?

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy