Skip site navigation (1) Skip section navigation (2)

Re: Open items

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Open items
Date: 2003-10-28 04:32:45
Message-ID: 19369.1067315565@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> We only have a few open items left.  Can we finish them so we can move
> toward final release?

Okay, here's my two cents:

> Allow superuser (dba?) the ability to turn off foreign key checks/all
>   constraints/triggers, not settable from postgresql.conf?

We have seen a wide variety of proposals and opinions on this, ranging
from "you can turn off the C in ACID anytime you want" to "you can
suppress ALTER TABLE ADD FOREIGN KEY's cross-check ... and nothing else
... but only if you are superuser, mutter the right secret password, and
spin three times widdershins".  I am in the "three times widdershins"
camp myself.  But given the lack of consensus, I think the right
short-term answer is to do nothing further.  We can improve this more
in future releases.

> Move ANALYZE before foreign key creation?

"Move"?  pg_dump scripts don't issue ANALYZE at all.  Again, I think
this is not something to be introducing at the last minute.

> Rename dump GUC variable to be more generic

Sure, if we can agree on a name.

> Document new --describe-config postgres option

Go to it.

> Have gcc use -g, add --disable-debug, rename?

Personally I don't like the idea of this behavior defaulting differently
depending on which compiler you use.  I can see the practical arguments
for doing so, but it still rubs me the wrong way.  Can anyone offer new
arguments pro or con here?

			regards, tom lane

In response to

  • Open items at 2003-10-28 02:38:45 from Bruce Momjian

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-10-28 04:52:50
Subject: Re: Horology failures
Previous:From: Marc G. FournierDate: 2003-10-28 04:28:00
Subject: Re: Open items

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group