Yes, that was the ticket; the commands I needed to
execute are as follows:
GRANT UPDATE ON bla_bla_id_seq TO GROUP test_group_01;
GRANT SELECT ON bla_bla_id_seq TO GROUP test_group_01;
GRANT INSERT ON bla_bla_id_seq TO GROUP test_group_01;
Thanks!
--- On Sat, 1/2/10, Adrian Klaver wrote:
>
>
On Saturday 02 January 2010 3:57:40 pm Ivan K wrote:
> Yes, that was the ticket; the commands I needed to
> execute are as follows:
>
> GRANT UPDATE ON bla_bla_id_seq TO GROUP test_group_01;
> GRANT SELECT ON bla_bla_id_seq TO GROUP test_group_01;
> GRANT INSERT ON bla_bla_id_seq TO GROUP test_g
Ivan K writes:
> test=# GRANT USAGE ON SEQUENCE bla_bla_id_seq TO GROUP test_group_01;
> ERROR: syntax error at or near "bla_bla_id_seq" at character 25
> LINE 1: GRANT USAGE ON SEQUENCE bla_bla_id_seq TO GROUP
> test_group_0...
> Why is the "GRANT USAGE ON SEQUENCE" statement failing?
On Saturday 02 January 2010 2:44:34 pm Ivan K wrote:
> I need to have members of a particular user
> group insert rows into a table and then determine the
> recently inserted statement's primary key that was
> created from a sequence with the currval() function:
>
>select currval('bla_bla_id_se
