Message-ID: <015301c284cb$aba15620$7201a8c0@aaa>
From: "cristi" <cristi@dmhi.ct.ro>
To: <pgsql-sql@postgresql.org>
References: <003d01c28490$310d2fa0$7201a8c0@aaa>
	<200211051057.56017.dev@archonet.com>
	<005101c284c2$3fe836a0$7201a8c0@aaa>
	<200211051222.18585.dev@archonet.com>
Subject: Re: owner of type 'mmm' apperars to be invalid
Date: Tue, 5 Nov 2002 15:03:00 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

It shouldn't be this the solution of the problem?

salt=# delete from pg_type where typname='refcursor';
DELETE 1
salt=# delete from pg_type where typname='eee';
DELETE 1
salt=# delete from pg_type where typname='mmm';
DELETE 1

Now, I don't have the error message!

Mr.Richard Huxton, thank you very much!

Cristi


On Tuesday 05 Nov 2002 11:55 am, cristi wrote:
> I'm in this situation:
>
> salt=# select oid,typname,typowner from pg_type where typname='refcursor';
>    oid    |  typname  | typowner
> ----------+-----------+----------
>  13701973 | refcursor |        0
> (1 row)
>
> salt=# select * from pg_user where usesysid=0;
>  usename | usesysid | usecreatedb | usetrace | usesuper | usecatupd |
> passwd

> (0 rows)

Hmm - try the following (it should show the 5 users with lowest number - the
first should be 'postgres').

SELECT * FROM pg_user ORDER BY usesysid limit 5;

> 1)Which is the user with the required id in my case?
> 2)How can I  add a user with the required id?(the command)

Hmm - assuming the query above is good, I'd change "typowner" in "pg_type"
instead. Also the following should all display the same typowner (but we
know
there is a problem with refcursor). That typowner should be the postgres
user.

SELECT typname,typowner FROM pg_type WHERE typname LIKE 'r%';


--
  Richard Huxton