Re: about truncate

On Wed, Jan 07, 2009 at 11:17:46AM -0500, Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > [ good summary ]
>
> +1 for making TRUNCATE and LOCK support ONLY. I don't care much
> about ALTER TABLE SET SCHEMA, but perhaps there's a use-case for
> recursion on that. We should stay away from recursive CREATE INDEX
> for the moment --- for one thing, you'd have to invent names for the
> additional indexes.
>
> I wonder whether GRANT/REVOKE shouldn't be made to support recursion
> too. We have a standard warning "don't forget to grant rights on
> the child tables" ...

+1 for adding recursion to GRANT/REVOKE :)

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate