From: Gregory Stark <stark@enterprisedb.com>
To: Andreas Pflug <pgadmin@pse-consulting.de>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Overhauling GUCS
Date: Fri, 06 Jun 2008 12:19:33 +0100
Message-ID: <877id2erp6.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <4849137C.3040008@pse-consulting.de>
References: <Pine.GSO.4.64.0806041045520.2258@westnet.com>
<29525.1212613052@sss.pgh.pa.us>
<48472E47.7030701@dunslane.net>
<Pine.GSO.4.64.0806042033120.3874@westnet.com>
<20080605162400.GF16502@alvh.no-ip.org>
<48481CBF.6040602@enterprisedb.com>
<48481E3A.4010306@hagander.net>
<Pine.GSO.4.64.0806051321360.27711@westnet.com>
<20080605174209.GL16502@alvh.no-ip.org>
<Pine.GSO.4.64.0806051452480.27254@westnet.com>
<20080605212129.GI14498@yugib.highrise.ca>
<Pine.GSO.4.64.0806051725550.10475@westnet.com>
<3F927D52-A0FD-4575-8D24-F0F70C459235@kineticode.com>
<4848FAA6.8000903@pse-consulting.de>
<87ej7aeuqx.fsf@oxford.xeocode.com>
<4849137C.3040008@pse-consulting.de>
"Andreas Pflug" <pgadmin@pse-consulting.de> writes:
> Gregory Stark wrote:
>> "Andreas Pflug" <pgadmin@pse-consulting.de> writes:
>>
>>> Why do so many people here insist on editing postgresql.conf as primary means
>>> of changing config params?
>>> Isn't a psql -c "SET foo=bar; MAKE PERSISTENT" just as good as sed'ing
>>> postgresql.conf or doing it manually?
>>
>> no, it's awful.
>
> So I wonder why you accept it when configuring schemas. What's the big
> difference between setting a config param, and creating a table?
Yes, this is a big impedence mismatch between the old-school DBMS (with
emphasis on the MS part of the acronym) architecture and more modern
approaches. You don't configure your web site with "ALTER PAGE home.html SET
FORM contactus INPUT TYPE SUBMIT" either...
This is partly out of necessity though as those database objects contain
*data*. So merely replacing them with new data objects doesn't give the system
enough information to understand what to do with that data. The DDL commands
which modify the schema give that kind of data mutating instruction.
And I'll note that DBAs go to *great* lengths to do exactly the same kind of
thing I described the CISCO DBAs doing. Usually that means doing an ALTER
command and separately editing a creation script and trying to keep the two in
sync. It's a huge burden.
> And ultimately, the config param file format may well look like an SQL command
> file, restricted to SET only.
So all you have is our existing file except with an additional layer of
quoting to deal with, a useless SET keyword to annoy users, and a file that
you need a bison parser to deal instead of a simple keyword-value syntax that
sed can manipulate.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: stark@enterprisedb.com, pgadmin@pse-consulting.de
Subject: Re: Overhauling GUCS
In-Reply-To: <877id2erp6.fsf@oxford.xeocode.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox