woody <woody(dot)1q2c4a(at)mail(dot)droptable(dot)com> writes:
> ... When I log in as
> 'asterisk', I can insert rows but I can't use the implied nextval(). It
> says the relation <seq_name> does not exist.
I'd bet this isn't a permissions problem at all, but a schema search
path problem. Do you have different search paths for asterisk and
asterisk_owner? (Hint: by default, a schema that has the same name as a
user is part of that user's search path, and only that user's search
path.)
regards, tom lane