Additional Grant/revoke problem

Started by Joshua D. Drakeabout 20 years ago1 messages
#1Joshua D. Drake
jd@commandprompt.com

Hello,

CREATE TABLE foo (id bigserial primary key, fname text);
GRANT INSERT ON foo to jd;
INSERT INTO foo(fname) VALUES ('Joshua');

This will fail, because I don't have permissions on the sequence
foo_id_seq which is a dependency created
by PostgreSQL. It seems that if bigserial is the datatype the grant
should automatically cascade.

This behavior would make sense if I did it the long way, where I used
bigint and then modified the column
with ALTER TABLE after the fact.

Joshua D. Drake