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