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

Ok, you're over my head now so I'm just going to post the results in the
hope that something clicks.  Here ya go:

 ({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 :checkForRead false
: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 :inFromCl false
: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 :checkForRead true
: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 :resorigcol 1
: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
:restype 16 :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 :resname usesuper :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
:ressortgroupref 0 :resorigtbl 1260 :resorigcol 5 :resjunk false} :expr
{VAR :varno 3 :varattno 5 :vartype 16 :vartypmod -1 :varlevelsup 0
:varnoold 3 :varoattno 5}} {TARGETENTRY :resdom {RESDOM :resno 6
:restype 25 :restypmod -1 :resname passwd :ressortgroupref 0 :resorigtbl
0 :resorigcol 0 :resjunk false} :expr {CONST :consttype 25 :constlen -1
:constbyval false :constisnull false :constvalue 12 [ 12 0 0 0 42 42 42
42 42 42 42 42 ]}} {TARGETENTRY :resdom {RESDOM :resno 7 :restype 702
:restypmod -1 :resname valuntil :ressortgroupref 0 :resorigtbl 1260
:resorigcol 7 :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 :resjunk false} :expr
{VAR :varno 3 :varattno 8 :vartype 1009 :vartypmod -1 :varlevelsup 0
:varnoold 3 :varoattno 8}}) :groupClause <> :havingQual <>
:distinctClause <> :sortClause <> :limitOffset <> :limitCount <>
:hierClause <> :setOperations <> :resultRelations ()})

That help?  *cringe*

Again, I REALLY appreciate your time!

Gerald



Alvaro Herrera wrote:

>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
:varattno3 :vartype 16 
>:vartypmod -1 :varlevelsup 0 :varnoold 3 :varoattno 3}} {TARGETENTRY :resdom {RESDOM :resno 4 :restype 16 :restypmod
-1:resname usesuper 
>: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:varoattno 5}} 
>{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 ()})
>
>
>
>