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 14:51:03 +0000
User-Agent: KMail/1.4.3
References: <003d01c28490$310d2fa0$7201a8c0@aaa>
	<200211051321.31846.dev@archonet.com>
	<019501c284d8$1f0c5720$7201a8c0@aaa>
In-Reply-To: <019501c284d8$1f0c5720$7201a8c0@aaa>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200211051451.03482.dev@archonet.com>

On Tuesday 05 Nov 2002 2:32 pm, cristi wrote:
> On Tuesday 05 Nov 2002 1:03 pm, cristi wrote:
> >But - you have deleted the "refcursor" type which is not a good idea! If

> Ooo!!!!
> Yes, I see...
> You right.
>
> >If so, drop and recreate the database, restoring the data to it. If not,=
 I
> think you'll
> >need to restore the template1 db - there's an article on
> >techdocs.postgresql.org about this (byJosh IIRC).
>
> Would you give me the URL address for this article?
> Please!

It's "Adventures in PostgreSQL, Episode 1 by Josh Berkus"
at http://techdocs.postgresql.org/
Loads of other good stuff there too.

Might not be necessary though - if the template1 db contains the refcursor=
=20
type definition then you just need to drop and recreate the problem databas=
e.

--=20
  Richard Huxton