alter database without shutting down !?

From: Sergio A(dot) Kessler <sergio_kessler(at)yahoo(dot)com(dot)ar>
To: pgsql-hackers(at)postgresql(dot)org
Subject: alter database without shutting down !?
Date: 2001-04-14 20:21:30
Message-ID: 20010414202130.28191.qmail@web13104.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

first, congratulations to all for the 7.1 release, good work.

second, I've found (some years ago to be honest) that pgsql can ALTER
TABLE while the table is widely available for all users...

this strike me as pretty bad/dangerous/confusing/messy (even from the
POV of implementation)

should I supposed to do something like:
ALTER DATABASE CLOSE
or
ALTER DATABASE SHUTDOWN [options] (simil oracle)

before doing changes to the definition of tables ?

someone can say this is a feature, don't think so, even then I
think that ALTER TABLE DROP COLUMN could be implemented a *lot*
more easily with this method.

(and requiring this operation to enter DDL sound very logical)

regards,
sergio

_________________________________________________________
¿Lo probaste?
Correo gratis y para toda la vida en http://correo.yahoo.com.ar

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Ivar Helbekkmo 2001-04-14 21:24:55 Re: NetBSD "Bad address" failure (was Re: Third call for platform testing)
Previous Message The Hermit Hacker 2001-04-14 19:16:09 Re: Re: 7.1 RPMs