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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
