select * from pg_rewrite where ev_class = 'pg_user'::regc lass gives

(extended display):

rulename | _RETURN

ev_class | 16681

ev_attr | -1

ev_type | 1

is_instead | t

ev_qual | <>

ev_action | ({ QUERY :command 1 :source 0 :utility <> :resultRelation 0

:into <> :isPortal false :isBinary false :hasAggs false :hasSubLinks false

:rtable ({ RTE :alias { ALIAS :aliasname *OLD* :colnames <>} :eref { ALIAS

:aliasname *OLD* :colnames ( "usename" "usesysid" "usecreated b"

"usesuper" "usecatupd" "passwd" "valuntil" "useconfig" )} :rtekind

0 :relid 16681 :inh false :inFromCl false :checkForRead false

:checkForWrite false :checkAsUser 1} { RTE :alias { ALIAS :aliasname *NEW*

:colnames <>} :eref { ALIAS :aliasname *NEW* :colnames ( "usename"

"usesysid" "usecreated b" "usesuper" "usecatupd" "passwd"

"valuntil" "useconfig" )} :rtekind 0 :relid 16681 :inh false :inFromCl

false :checkForRead false :checkForWrite false :checkAsUser 1} { RTE

:alias <> :eref { ALIAS :aliasname pg_shadow :colnames ( "usename"

"usesysid" "usecreated b" "usesuper" "usecatupd" "passwd"

"valuntil" "useconfig" )} :rtekind 0 :relid 1260 :inh true :inFromCl

true :checkForRead true :checkForWrite false :checkAsUser 1}) :jointree {

FROMEXPR :fromlist ({ RANGETBLREF 3 }) :quals <>} :rowMarks () :targetList

({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 19 :restypmod -1

:resname usename :reskey 0 :reskeyop 0 :ressortgroupre f 0 :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 :reskey 0 :reskeyop 0

:ressortgroupre f 0 :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 :reskey 0 :reskeyop 0 :ressortgroupre f 0 :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 :reskey 0 :reskeyop 0

:ressortgroupre f 0 :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 :reskey 0 :reskeyop 0 :ressortgroupre f 0 :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 :reskey 0 :reskeyop 0

:ressortgroupre f 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 :reskey 0 :reskeyop 0 :ressortgroupre f

0 :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

:reskey 0 :reskeyop 0 :ressortgroupre f 0 :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 <>

:resultRelation s ()})

The second query indeed fails...

On Thu, 20 Nov 2003, Tom Lane wrote:

Andrei Ivanov <an***********@ ines.ro> writes: I've reinstalled postgres, but the same errors happen.

I've tried connection to more databases, but the error show everytime.

Hm, that's very odd. Could we see the results of

select * from pg_rewrite where ev_class = 'pg_user'::regc lass;

and

select pg_get_viewdef( 'pg_user'::regc lass);

You'll probably need to do a "rollback" to get psql out of its

transaction-aborted state after startup, but then I'd expect the

first of these to work. The second will likely fail, but we should

confirm that ...

regards, tom lane

---------------------------(end of broadcast)---------------------------

TIP 6: Have you searched our list archives?

http://archives.postgresql.org