> Something like
> DO $$ begin ...; end $$;
>
> gives 90% of the usability with 10% of the trouble.
I'd be a big fan of this. Especially if we could at an \e for it in
psql. \ec?
I'm not agreeing, though, that we don't need a GRANT ALL/ALTER DEFAULT.We still need that for the simplest cases so
thatnovice-level users
will use *some* access control. But it would mean that we wouldn't need
GRANT ALL/ALTER DEFAULT to support anything other than the simplest cases.
--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com