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

Re: Re: [COMMITTERS] pgsql: Extract catalog info for error reporting before an error actually

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Michael Paesold <mpaesold(at)gmx(dot)at>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>
Subject: Re: Re: [COMMITTERS] pgsql: Extract catalog info for error reporting before an error actually
Date: 2007-10-25 19:37:09
Message-ID: 23881.1193341029@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackerspgsql-patches
Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> Michael Paesold wrote:
>> Shouldn't we rather support the regular usage pattern instead of the 
>> uncommon one? Users doing a lot of schema changes are the ones who 
>> should have to work around issues, not those using a DBMS sanely. No?

> Unfortunately, doing lots of schema changes is a very common phenomenon. 
> It makes me uncomfortable too, but saying that those who do it have to 
> work around issues isn't acceptable IMNSHO - it's far too widely done.

Well, there's going to be pain *somewhere* here, and we already know
that users will find the current 8.3 behavior unacceptable.  I'd rather
have autovacuum not make progress than have users turn it off because it
gets in their way too much.  Which I think is exactly what will happen
if we ship it with the current behavior.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2007-10-25 19:42:49
Subject: Re: [HACKERS] Re: pgsql: Extract catalog infofor error reporting before an error actually
Previous:From: Henry B. HotzDate: 2007-10-25 19:24:46
Subject: Re: 8.3 GSS Issues

pgsql-committers by date

Next:From: Simon RiggsDate: 2007-10-25 19:42:49
Subject: Re: [HACKERS] Re: pgsql: Extract catalog infofor error reporting before an error actually
Previous:From: Tom LaneDate: 2007-10-25 19:15:01
Subject: pgsql: Ugly patch to make ALTER SEQUENCE OWNED BY not affect the

pgsql-patches by date

Next:From: Simon RiggsDate: 2007-10-25 19:42:49
Subject: Re: [HACKERS] Re: pgsql: Extract catalog infofor error reporting before an error actually
Previous:From: Alvaro HerreraDate: 2007-10-25 18:45:49
Subject: Re: vacuum as flags in PGPROC

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