Re: Old problem needs solution - Mailing list pgsql-general

On Fri, Jun 03, 2005 at 06:48:06AM -0500, Gerald D. Anderson wrote:
> Yup, was just going to respond this morning.  It isn't enabled by
> default (at least in the ebuilds I've looked at).  I've built it with
> pg_hier and without pg_hier and get the same results either way : /
> Might there be some other cause for this?  Or even a dirty fix if this
> is what it is?

Hmm, maybe there's another problem then.  I don't know what can it be
though.  Please post the result of

select ev_action from pg_rewrite where ev_class = 'pg_user'::regclass;

Mine, for a vanilla 7.4 installation, is


ev_action | ({QUERY :commandType 1 :querySource 0 :canSetTag true :utilityStmt <> :resultRelation 0 :into <> :hasAggs
false:hasSubLinks 
false :rtable ({RTE :alias {ALIAS :aliasname *OLD* :colnames <>} :eref {ALIAS :aliasname *OLD* :colnames ("usename"
"usesysid""usecreatedb" 
"usesuper" "usecatupd" "passwd" "valuntil" "useconfig")} :rtekind 0 :relid 16683 :inh false :inFromCl false
:checkForReadfalse 
:checkForWrite false :checkAsUser 1} {RTE :alias {ALIAS :aliasname *NEW* :colnames <>} :eref {ALIAS :aliasname *NEW*
:colnames("usename" 
"usesysid" "usecreatedb" "usesuper" "usecatupd" "passwd" "valuntil" "useconfig")} :rtekind 0 :relid 16683 :inh false
:inFromClfalse 
:checkForRead false :checkForWrite false :checkAsUser 1} {RTE :alias <> :eref {ALIAS :aliasname pg_shadow :colnames
("usename""usesysid" 
"usecreatedb" "usesuper" "usecatupd" "passwd" "valuntil" "useconfig")} :rtekind 0 :relid 1260 :inh true :inFromCl true
:checkForReadtrue 
:checkForWrite false :checkAsUser 1}) :jointree {FROMEXPR :fromlist ({RANGETBLREF :rtindex 3}) :quals <>} :rowMarks ()
:targetList
({TARGETENTRY :resdom {RESDOM :resno 1 :restype 19 :restypmod -1 :resname usename :ressortgroupref 0 :resorigtbl 1260
:resorigcol1 :resjunk 
false} :expr {VAR :varno 3 :varattno 1 :vartype 19 :vartypmod -1 :varlevelsup 0 :varnoold 3 :varoattno 1}} {TARGETENTRY
:resdom{RESDOM 
:resno 2 :restype 23 :restypmod -1 :resname usesysid :ressortgroupref 0 :resorigtbl 1260 :resorigcol 2 :resjunk false}
:expr{VAR :varno 3 
:varattno 2 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold 3 :varoattno 2}} {TARGETENTRY :resdom {RESDOM :resno 3
:restype16 :restypmod 
-1 :resname usecreatedb :ressortgroupref 0 :resorigtbl 1260 :resorigcol 3 :resjunk false} :expr {VAR :varno 3 :varattno
3:vartype 16 
:vartypmod -1 :varlevelsup 0 :varnoold 3 :varoattno 3}} {TARGETENTRY :resdom {RESDOM :resno 4 :restype 16 :restypmod -1
:resnameusesuper 
:ressortgroupref 0 :resorigtbl 1260 :resorigcol 4 :resjunk false} :expr {VAR :varno 3 :varattno 4 :vartype 16
:vartypmod-1 :varlevelsup 0 
:varnoold 3 :varoattno 4}} {TARGETENTRY :resdom {RESDOM :resno 5 :restype 16 :restypmod -1 :resname usecatupd
:ressortgroupref0 :resorigtbl 
1260 :resorigcol 5 :resjunk false} :expr {VAR :varno 3 :varattno 5 :vartype 16 :vartypmod -1 :varlevelsup 0 :varnoold 3
:varoattno5}} 
{TARGETENTRY :resdom {RESDOM :resno 6 :restype 25 :restypmod -1 :resname passwd :ressortgroupref 0 :resorigtbl 0
:resorigcol0 :resjunk 
false} :expr {CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue 12 [ 12 0 0 0 42 42 42
4242 42 42 42 ]}} 
{TARGETENTRY :resdom {RESDOM :resno 7 :restype 702 :restypmod -1 :resname valuntil :ressortgroupref 0 :resorigtbl 1260
:resorigcol7 
:resjunk false} :expr {VAR :varno 3 :varattno 7 :vartype 702 :vartypmod -1 :varlevelsup 0 :varnoold 3 :varoattno 7}}
{TARGETENTRY:resdom 
{RESDOM :resno 8 :restype 1009 :restypmod -1 :resname useconfig :ressortgroupref 0 :resorigtbl 1260 :resorigcol 8
:resjunkfalse} :expr {VAR 
:varno 3 :varattno 8 :vartype 1009 :vartypmod -1 :varlevelsup 0 :varnoold 3 :varoattno 8}}) :groupClause <> :havingQual
<>:distinctClause 
<> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()})


--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Aprender sin pensar es inútil; pensar sin aprender, peligroso" (Confucio)