permission problems

I am having a problem adding a row to a postgresql table with a sequence
as a primary key using pg_query. I receive an error, "permission denied
for sequence mytable_tid_seq". I have set the permissions for the user
from all which did not work to insert, update and select which did not
work. Can you help. Thanks

Ron Ellingson
rellingson@satshot.com


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: permission problems

Did you grant the relevant permissions on just the table, or on both the
sequence and the table? You'll need to do both.

Heather Johnson
Senior Database Programmer
New York Post

Ron Ellingson wrote:
> I am having a problem adding a row to a postgresql table with a sequence
> as a primary key using pg_query. I receive an error, "permission denied
> for sequence mytable_tid_seq". I have set the permissions for the user
> from all which did not work to insert, update and select which did not
> work. Can you help. Thanks
>
> Ron Ellingson
> rellingson@satshot.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Re: permission problems

El Mi=E9 23 Feb 2005 17:24, Ron Ellingson escribi=F3:
> I am having a problem adding a row to a postgresql table with a sequence
> as a primary key using pg_query. I receive an error, "permission denied
> for sequence mytable_tid_seq". I have set the permissions for the user
> from all which did not work to insert, update and select which did not
> work. Can you help. Thanks

Did you check the permissions of the sequence?

--=20
17:40:04 up 164 days, 7:34, 3 users, load average: 1.43, 1.36, 0.97
------------------------------------------------------------ -----
Mart=EDn Marqu=E9s | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
------------------------------------------------------------ -----

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: permission problems

> I am having a problem adding a row to a postgresql table with a sequence
> as a primary key using pg_query. I receive an error, "permission denied
> for sequence mytable_tid_seq". I have set the permissions for the user
> from all which did not work to insert, update and select which did not
> work. Can you help. Thanks

GRANT SELECT, UPDATE ON sequence mytable_tid_seq TO ...;

Chris

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match