"Tomeh, Husam" <HTomeh(at)facorelogic(dot)com> writes:
> Thanks Tom. As a temporarily solution though, would reorging the table
> (pgdump,drop/truncate, reload) resolve the OID collision issue and buy
> us some time until we get the upgrade going?
Probably. I wouldn't bother with pg_dump, just INSERT ... SELECT
the data into a new table and then rename that one into place.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2007-11-15 16:52:05|
|Subject: Re: any way to make query use index? |
|Previous:||From: Chris Hoover||Date: 2007-11-15 16:37:49|
|Subject: Re: any way to make query use index?|