Re: owner of type 'mmm' apperars to be invalid

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