permissions problem

Поиск
Список
Период
Сортировка
От Michael Davis
Тема permissions problem
Дата
Msg-id 93C04F1F5173D211A27900105AA8FCFC145243@lambic.prevuenet.com
обсуждение исходный текст
Список pgsql-general
I create a group:

    INSERT INTO pg_group VALUES ('dba');

I create the following user:

CREATE USER admin IN GROUP dba;

Next:

grant all on table_name to GROUP dba;
select * from pg_class where relname = 'table_name';

Psql aborts with the following error:

    ERROR:  parser: parse error at or near ";"
    mp=> select *  From pg_class where relname = 'status';;
    pqReadData() -- backend closed the channel unexpectedly.
            This probably means the backend terminated abnormally before
or while processing the request.
    We have lost the connection to the backend, so further processing is
impossible.  Terminating.

Any ideas on what could be causing this and/or how to work around it?  I am
running 6.4.2 on linux Red Hat 5.1.

Thanks, Michael

В списке pgsql-general по дате отправления:

Предыдущее
От: Simon Drabble
Дата:
Сообщение: Foreign keys
Следующее
От: Michael Davis
Дата:
Сообщение: RE: [GENERAL] permissions problem