I get the following messages while vacuuming
is there anything alarming?
regds
mallah.
On Saturday 25 January 2003 07:11 am, you wrote:
> SET autocommit TO 'on';VACUUM ANALYZE
> WARNING: Rel site_search: Uninitialized page 1 - fixing
> WARNING: Rel site_search: Uninitialized page 2 - fixing
Robert Treat <[EMAIL PROTECTED]> writes:
> There is a "gamblers lunch", for those willing to risk total system
> failure and the lives of there first born child.
Aw, it's not that dangerous ;-). You can improve your odds considerably
if you issue BEGIN; before you start dorking with the system ta
On Fri, 2003-01-24 at 05:33, Ian Barwick wrote:
> On Friday 24 January 2003 09:26, Ian Barwick wrote:
> > On Friday 24 January 2003 07:37, Andre Schubert wrote:
> > > i have a little question on changing the length of a varchar field.
> > > Is there another way than dump and reload if i want to cha
Dear All,
We are considering moving our existing PostgreSQL installation from a single
server hosting both live and test DBs and backend processing, to a dual node
RedHat Advanced server cluster.
We envisage the live DB on one node and test DB and backend processing on
the other with external sha
On Friday 24 January 2003 09:26, Ian Barwick wrote:
> On Friday 24 January 2003 07:37, Andre Schubert wrote:
> > i have a little question on changing the length of a varchar field.
> > Is there another way than dump and reload if i want to change the length
> > of a varchar field ?
>
> in 7.3:
>
>
On Friday 24 January 2003 07:37, Andre Schubert wrote:
> i have a little question on changing the length of a varchar field.
> Is there another way than dump and reload if i want to change the length
> of a varchar field ?
in 7.3:
BEGIN;
ALTER TABLE foo RENAME your_field TO your_field_old;
ALTER
