The following bug has been logged online:
Bug reference: 5998
Logged by: Mark Reid
Email address: m...@markreid.org
PostgreSQL version: 8.3.5
Operating system: Debian Etch
Description:CLUSTER and "ERROR: missing chunk number 0 for toast
value"
Detail
We've run our real-life test cases and they've all worked properly using
this patch too. Thanks again.
-Mark.
On Jan 1, 2008 8:07 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Mark Reid" <[EMAIL PROTECTED]> writes:
> > The trigger function does not recog
Works perfectly on my test case. Thanks!
On Jan 1, 2008 8:07 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Mark Reid" <[EMAIL PROTECTED]> writes:
> > The trigger function does not recognize the "test4" column the second
> time
> > it is adde
The trigger function does not recognize the "test4" column the second time
it is added - the update throws an error.
On Jan 1, 2008 11:17 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Mark Reid" <[EMAIL PROTECTED]> writes:
> > If a column is added, dropped
The following bug has been logged online:
Bug reference: 3847
Logged by: Mark Reid
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: Debian Linux
Description:plpython trigger caches table structure - doesn't see
new / changed co
I'm not proposing it for 8.1 though ...
Well, why not? Arguably Mark's problem is a bug, and it's not too late
to address bugs.
FWIW, I'd be satisfied with a warning in the autovacuum docs about this
corner case.
I'm not sure about the idea of not vacuuming the toas
Matthew T. O'Connor wrote:
Tom Lane wrote:
I think Mark is probably on to something. The activity in the toast
table will show as deletes *in the toast table* ... and that activity
fails to show at all in the pg_stat_activity view, because it shows
only plain relations! So unless autovacuum
Hi,
I've been using pg_autovacuum for a while, and for the most part it's
been great. There's one case in my system where it won't run on a
particular type of table, even though the table apparently needs it.
I have a table called "properties" that has key->value pairs. Usually
there are o
