Thread

1. bugs

   Alexei E Korneyev <alexei@niva.sposad.ru> — 2000-08-31T19:46:03Z

   ============================================================================
                           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
   
   
   

2. Re: bugs

   Stephan Szabo <sszabo@megazone23.bigpanda.com> — 2000-09-06T16:35:42Z

   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:
   
   > ============================================================================
   >                         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
   >