Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E690C475E7B for ; Tue, 5 Nov 2002 09:33:43 -0500 (EST) Received: from dmhi.ct.ro (dmhi.ct.ro [193.226.151.66]) by postgresql.org (Postfix) with ESMTP id 99522475E4D for ; Tue, 5 Nov 2002 09:33:40 -0500 (EST) Received: from [192.168.1.114] (helo=aaa) by dmhi.ct.ro with smtp (Exim 3.03 #1) id 1894mi-00018L-00 for pgsql-sql@postgresql.org; Tue, 05 Nov 2002 16:34:28 +0200 Message-ID: <019501c284d8$1f0c5720$7201a8c0@aaa> From: "cristi" To: References: <003d01c28490$310d2fa0$7201a8c0@aaa> <200211051222.18585.dev@archonet.com> <015301c284cb$aba15620$7201a8c0@aaa> <200211051321.31846.dev@archonet.com> Subject: Re: owner of type 'mmm' apperars to be invalid Date: Tue, 5 Nov 2002 16:32:07 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/61 X-Sequence-Number: 10203 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 >> 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? 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!