bugs
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Alexei E. Korneyev
Your email address : alexei@niva.sposad.ru
System Configuration
---------------------
Architecture : Intel Pentium II
Operating System : Linux RedHat 2.2.12
PostgreSQL version : PostgreSQL-7.0.2
Compiler used : uncnown Build Host: utility.wgcr.org
Please enter a FULL description of your problem:
------------------------------------------------
i create this:
------------------------
create table "users" (
name varchar(10) PRIMARY KEY
);
create table "stat" (
peername varchar(10) REFERENCES users(name)
);
revoke ALL on stat,users from PUBLIC;
grant INSERT, SELECT on stat to statist;
grant select on users to statist;
grant ALL on stat to basemaster;
insert into users values('niva');
insert into stat values ('niva',abstime('now'),timespan(0),8607272,1829436);
---------------------
After that I do(make) connection as the user statis and execute cmd:
-----------------------
insert into stat
values('niva',abstime('now'),timespan(abstime('now')-(select max(timewrite)
from stat)),50,50);";
--------------------------
server say:Access deny on users...
After I change the rights on:
grant select,update on users to statist;
,the query exec successfully
Alexei E. Korneyev
aek@tsinet.ru
Yes, right now references constraints require update
permissions on the table being referenced in order
to grab row level locks on it with SELECT FOR UPDATE.
Stephan Szabo
sszabo@bigpanda.com
On Thu, 31 Aug 2000, Alexei E. Korneyev wrote:
Show quoted text
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================Your name : Alexei E. Korneyev
Your email address : alexei@niva.sposad.ruSystem Configuration
---------------------
Architecture : Intel Pentium IIOperating System : Linux RedHat 2.2.12
PostgreSQL version : PostgreSQL-7.0.2
Compiler used : uncnown Build Host: utility.wgcr.org
Please enter a FULL description of your problem:
------------------------------------------------
i create this:------------------------
create table "users" (
name varchar(10) PRIMARY KEY
);
create table "stat" (
peername varchar(10) REFERENCES users(name)
);revoke ALL on stat,users from PUBLIC;
grant INSERT, SELECT on stat to statist;
grant select on users to statist;
grant ALL on stat to basemaster;
insert into users values('niva');
insert into stat values ('niva',abstime('now'),timespan(0),8607272,1829436);
---------------------
After that I do(make) connection as the user statis and execute cmd:
-----------------------
insert into stat
values('niva',abstime('now'),timespan(abstime('now')-(select max(timewrite)
from stat)),50,50);";
--------------------------
server say:Access deny on users...After I change the rights on:
grant select,update on users to statist;
,the query exec successfully
Alexei E. Korneyev
aek@tsinet.ru