Thanks to both you and Jim--this was the missing piece that made things
work.
On 11/29/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Dan Tenenbaum <dandante(at)gmail(dot)com> writes:
> > ERROR: permission denied for schema myschema
> > What do I need to do to get the correct permissions?
>
> GRANT USAGE ON SCHEMA myschema TO whoever
>
> Schema access is comparable to directory access in a filesystem: if you
> can't look into the directory, it doesn't matter what privileges you
> might have for the individual files in it.
>
> regards, tom lane
>