Skip site navigation (1) Skip section navigation (2)

pgsql: Remove unnecessary UPDATE commands to assign explicit ACLs to

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Remove unnecessary UPDATE commands to assign explicit ACLs to
Date: 2005-04-12 19:29:24
Message-ID: 20050412192924.86BA953417@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Remove unnecessary UPDATE commands to assign explicit ACLs to functions
and PL languages during initdb.  The default permissions for these objects
are the same as what we were assigning anyway, so there is no need to
expend space in the catalogs on them.  The space cost is particularly
significant in pg_proc's indexes, which are bloated by about a factor of 2
by the full-table update, and can never really recover the space.
initdb not forced, since the change has no actual impact on behavior.

Modified Files:
--------------
    pgsql/src/bin/initdb:
        initdb.c (r1.80 -> r1.81)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/initdb/initdb.c.diff?r1=1.80&r2=1.81)

pgsql-committers by date

Next:From: Tom LaneDate: 2005-04-12 19:45:44
Subject: pgsql: Adjust pg_cast.h so that the OIDs assigned to built-in casts come
Previous:From: Peter EisentrautDate: 2005-04-12 14:19:43
Subject: pgsql: Revert mistaken renaming of UTF-8.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group