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 :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 <> :setOperations <> :resultRelations ()})
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
