woody <woody.1q2c4a@xxxxxxxxxxxxxxxxxx> 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
