agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Robert Treat <xzilla@users.sourceforge.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Cc: Andrew Dunstan <andrew@dunslane.net>
Subject: Re: pg_dump restore time and Foreign Keys
Date: Sun, 08 Jun 2008 19:45:33 -0400
Message-ID: <200806081945.33732.xzilla@users.sourceforge.net> (raw)
In-Reply-To: <23219.1212870176@sss.pgh.pa.us>
References: <1212647003.19964.19.camel@ebony.site>
<1212860515.12046.78.camel@ebony.site>
<23219.1212870176@sss.pgh.pa.us>
On Saturday 07 June 2008 16:22:56 Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > Perhaps we need a GUC that says expert_mode = on. ... Another idea
> > might be to make such command options superuser only, to ensure the
> > power is available, yet only in the hands of, by-definition, the trusted
> > few.
>
> This all seems pretty useless, as the sort of user most likely to shoot
> himself in the foot will also always be running as superuser.
>
yeah, i'm not a big fan of "set enable_footgun=true" since the people likely
to get tripped up are going to blindly enable these modes.
otoh, if we do such a thing, i would be a big fan of calling
it "enable_footgun" :-)
> I'd much rather see us expend more effort on speeding up the checks
> than open holes in the system.
>
and i'm sure no one is against that idea, but you're never going to be able to
match the performance of just avoiding the check.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
view thread (40+ messages) latest in thread
Message-ID: <200806081945.33732.xzilla@users.sourceforge.net>
Permalink: ../../200806081945.33732.xzilla@users.sourceforge.net/
Also on: postgresql.org/message-id/200806081945.33732.xzilla@users.sourceforge.net
reply
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: xzilla@users.sourceforge.net, tgl@sss.pgh.pa.us, simon@2ndquadrant.com, andrew@dunslane.net
Subject: Re: pg_dump restore time and Foreign Keys
In-Reply-To: <200806081945.33732.xzilla@users.sourceforge.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox