Two problems - Mailing list pgsql-general

From Sergei Chernev
Subject Two problems
Date
Msg-id 001701be2328$dba06ae0$59d17cc1@ser.cnit.nsu.ru
Whole thread Raw
List pgsql-general
Hello,
I'm running postgreSQL on BSDI-3.1
And I have two questions:
1. if i grant permissin to table to someone, then I can't do this that table
before I grant
permission to myself:

ser=> \z

Database    = ser
 +-----------------------+--------------------------+
 | Relation              | Grant/Revoke Permissions |
 +-----------------------+--------------------------+
 | userd_daily_stat      |                          |

ser=> select * from userd_daily_stat;
   uid|           money|work_time|  rec_date
------+----------------+---------+----------
(11 rows)

Then, I:

ser=> grant select on userd_daily_stat to someone; -- grant to existing user
CHANGE
ser=> select * from userd_daily_stat;
ERROR:  userd_daily_stat: Permission denied.
????????

2. Sometimes it happens then vacuuming return:
NOTICE:  BlowawayRelationBuffers(userd_bank, 2): block 3 is referenced
(private
0, last 0, global 1)
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally before or
while pr
ocessing the request.
We have lost the connection to the backend, so further processing is
impossible.
  Terminating.

What does it mean ? It seems to me that the reason is vacuuming then
somebody working
whith database but it impossible to find when no one connected.

Thank you,
---------------------------
Sergei Chernev
Internet: ser@nsu.ru
Phone: +7-3832-397354


pgsql-general by date:

Previous
From: Bob Dusek
Date:
Subject: Re: [GENERAL] How can I obtain tables' structure?
Next
From: Marcin Grondecki
Date:
Subject: AIX 4.1 & plpgsql