From: cristi <cristi@dmhi.ct.ro>
To: pgsql-sql@postgresql.org
Subject: Re: owner of type 'mmm' apperars to be invalid
Date: Tue, 5 Nov 2002 15:03:00 +0200
Message-ID: <015301c284cb$aba15620$7201a8c0@aaa> (raw)
References: <003d01c28490$310d2fa0$7201a8c0@aaa>
<200211051057.56017.dev@archonet.com>
<005101c284c2$3fe836a0$7201a8c0@aaa>
<200211051222.18585.dev@archonet.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cristi@dmhi.ct.ro
Subject: Re: owner of type 'mmm' apperars to be invalid
In-Reply-To: <015301c284cb$aba15620$7201a8c0@aaa>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox