Re: Must be owner to truncate?

* Christopher Kings-Lynne (chriskl@familyhealth.com.au) wrote:
> I'm strongly in favour of this patch.  I am currently in this situation:
> 
> 1. Web db user runs as non-superuser, non-owner.
> 2. I have a table of a tens of thousands of rows that I must delete 
> entirely and rebuild every day at least (pg_trgm word list)
> 3. It just gets slow over time, even with autovac.
> 4. I can't vacuum it as i'm not the owner, and I cannot truncate it either.
> 5. Table has no triggers or FK's whatsoever.
> 
> So, stephen frost's suggestion would be fantastic.

This is a very similar situation to what I'm in, which is why I was
asking for the change. :)

	Thanks,

		Stephen