From: Richard Huxton <dev@archonet.com>
To: 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 13:21:31 +0000
Message-ID: <200211051321.31846.dev@archonet.com> (raw)
In-Reply-To: <015301c284cb$aba15620$7201a8c0@aaa>
References: <003d01c28490$310d2fa0$7201a8c0@aaa>
<200211051222.18585.dev@archonet.com>
<015301c284cb$aba15620$7201a8c0@aaa>
On Tuesday 05 Nov 2002 1:03 pm, cristi wrote:
> 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!
But - you have deleted the "refcursor" type which is not a good idea! If you
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, 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).
--
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: dev@archonet.com, cristi@dmhi.ct.ro
Subject: Re: owner of type 'mmm' apperars to be invalid
In-Reply-To: <200211051321.31846.dev@archonet.com>
* 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