Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: "cristi" <cristi@dmhi.ct.ro>, <pgsql-sql@postgresql.org>
Subject: Re: owner of type 'mmm' apperars to be invalid
Date: Tue, 5 Nov 2002 13:21:31 +0000
User-Agent: KMail/1.4.3
References: <003d01c28490$310d2fa0$7201a8c0@aaa>
	<200211051222.18585.dev@archonet.com>
	<015301c284cb$aba15620$7201a8c0@aaa>
In-Reply-To: <015301c284cb$aba15620$7201a8c0@aaa>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200211051321.31846.dev@archonet.com>

On Tuesday 05 Nov 2002 1:03 pm, cristi wrote:
> It shouldn't be this the solution of the problem?
>
> salt=3D# delete from pg_type where typname=3D'refcursor';
> DELETE 1
> salt=3D# delete from pg_type where typname=3D'eee';
> DELETE 1
> salt=3D# delete from pg_type where typname=3D'mmm';
> DELETE 1
>
> Now, I don't have the error message!
>
> Mr.Richard Huxton, thank you very much!

But - you have deleted the "refcursor" type which is not a good idea! If yo=
u=20
don't use cursors you might get away with it, but I'd be nervous about it.

If you create a new database does it contain the refcursor type? If so, dro=
p=20
and recreate the database, restoring the data to it. If not, I think you'll=
=20
need to restore the template1 db - there's an article on=20
techdocs.postgresql.org about this (byJosh IIRC).
--=20
  Richard Huxton