Re: [HACKERS] Cannot insert into temp tables

> Bruce Momjian wrote:
> ...
>   >OK, you have good points.  usecatupd should not be set by default. 
>   >Making changes to the system tables can mess things up for everyone. 
>   >Initdb will give the postgres superuser permissions, but now createuser
>   >and the SQL command CREATE USER will not give this permission.  Also, I
>   >have fixed the code so temp tables, which are acutally named pg_temp,
>   >can be updated by normal users without usecatupd permissions.
>   >
>   >Attached is a patch.  I will apply it to the current tree.
> 
> Bruce, this change has some other implications.  I tested
> the effect of the patch by altering the rights of my own account (setting
> usecatupd to false).  I cannot now create other users: although usesuper is
> true, the attempt to update pg_shadow with the new user's row fails:


OK, I have committed a fix for this.  I now give update catalog rights
to anyone who has createdb or super-user rights.  This is in the current
tree only.  Let me know if you see any additional problems.


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026