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

Re: [PERFORM] typoed column name, but postgres didn't grump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>, "<pgsql-bugs(at)postgresql(dot)org>" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: [PERFORM] typoed column name, but postgres didn't grump
Date: 2010-10-29 21:53:52
Message-ID: 9887.1288389232@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-performance
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> Yeah, I think we're going to have to live with it, at least for 8.4.  One could make an argument that 9.0 is new enough we could get away with a small behavior change to avoid a large amount of user confusion.  But that may be a self-serving argument based on wanting to tamp down the bug reports rather than a wisely considered policy decision...  so I'm not sure I quite buy it.

Well, tamping down the bug reports is good from the users' point of view
too.

The argument for not changing it in the back branches is that there
might be someone depending on the 8.4/9.0 behavior.  However, that seems
moderately unlikely.  Also, if we wait, that just increases the chances
that someone will come to depend on it, and then have a problem when
they migrate to 9.1.  I think the "risk of breakage" argument has a lot
more force when considering long-standing behaviors than things we just
recently introduced.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2010-10-29 21:54:49
Subject: Re: Slow Query- Bad Row Estimate
Previous:From: Tom LaneDate: 2010-10-29 21:50:07
Subject: Re: Slow Query- Bad Row Estimate

pgsql-bugs by date

Next:From: Robert HaasDate: 2010-10-30 00:24:54
Subject: Re: [PERFORM] typoed column name, but postgres didn't grump
Previous:From: Robert HaasDate: 2010-10-29 21:48:59
Subject: Re: [PERFORM] typoed column name, but postgres didn't grump

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