On Wed, Feb 20, 2008 at 10:20:55AM -0300, Alvaro Herrera wrote:
> Magnus Hagander escribió:
> > On Wed, Feb 20, 2008 at 09:36:43AM -0300, Alvaro Herrera wrote:
>
> > > IMO restart-only settings should not be changeable via the new SQL
> > > command. It's just too messy to deal with that.
> >
> > I respectfully disagree. It should be settable. You need a restart, sure,
> > and the GUI app should tell you that. But you shuld be able to change them.
> > (for example, pgadmin can restart the server just fine for you if you're on
> > Windows)
>
> What if the server doesn't come back up? Say, because you increased
> shared_buffers and now it doesn't fit on the kernel limits. If you
> haven't made arrangements to be able to edit the postgresql.conf file
> beforehand, you're hosed.
Right. So a warning in the GUI program is important, but that's no reason
to restrict the API.
Doing DROP TABLE can also be very dangerous. Or DROP TYPE CASCADE. Yet we
do support them, and rely on the user to think first, or the GUI pogram to
show warnings.
//Magnus