>
> >
> > >
> > > The command
> > > copy pg_user to stdout;
> > >
> > > will also show the cleartext password and I think it is hard to do a rewrite
> > > here,
> > > since this would also affect the pg_dump ?
> > >
> > > * Teardrops keep falling on my head ... * :-(
> >
> > It was brilliant, even if it doesn't fully solve the problem.
> >
> > --
> > Bruce Momjian
> > maillist@candle.pha.pa.us
> >
>
> Not only that it was brilliant - as stated in my last post it
> also showed that there is a bug in the rewrite system that
> must get fixed so we can use views in INSERT...SELECT!
> Please add this to the TODO.
>
> For the pg_user permission problem I can think about another
> solution. It's a feature still on my personal wishlist -
> setuid views.
Added to TODO:
* Allow INSERT INTO ... SELECT ... FROM view to work
We already had:
* Allow VIEW permissions to be set separately from the underlying tables
--
Bruce Momjian
maillist@candle.pha.pa.us