Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 286734761A3 for ; Mon, 28 Oct 2002 02:47:36 -0500 (EST) Received: from stargate.inta.es (stargate.inta.es [130.206.91.98]) by postgresql.org (Postfix) with SMTP id 0559B475E6F for ; Mon, 28 Oct 2002 02:47:35 -0500 (EST) Received: by stargate.inta.es; id IAA03344; Mon, 28 Oct 2002 08:52:40 +0100 Received: from unknown(130.206.84.14) by stargate.inta.es via smap (V5.5) id xma003323; Mon, 28 Oct 02 08:52:25 +0100 Received: from fargo.inta.es (fargo [130.206.92.25]) by polaris.inta.es (8.8.5/8.7.3) with ESMTP id IAA18718 for ; Mon, 28 Oct 2002 08:52:12 +0100 (MET) Received: from I000476993073 ([192.168.17.253]) by fargo.inta.es (Lotus Domino Release 5.0.6a) with SMTP id 2002102808491848:8267 ; Mon, 28 Oct 2002 08:49:18 +0100 From: =?iso-8859-1?Q?Carlos_Garc=EDa_G=F3mez?= To: "Lista Postgresql" Subject: Re: Problems with OIDs Date: Mon, 28 Oct 2002 08:43:46 +0100 Message-ID: MIME-Version: 1.0 X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 In-Reply-To: <1035707335.3698.1.camel@kant.mcmillan.net.nz> Importance: Normal X-MIMETrack: Itemize by SMTP Server on FARGO/Inta(Release 5.0.6a |January 17, 2001) at 28/10/2002 08.49.18, Serialize by Router on FARGO/Inta(Release 5.0.6a |January 17, 2001) at 28/10/2002 08.49.18, Serialize complete at 28/10/2002 08.49.18 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/67 X-Sequence-Number: 1582 > Hi all! > > I've got the following problem: I had a view with OID 5330 that had to be > removed from the database, afterwards I created again a view (with the same > name, because I need it to be this way) and get the an error telling me that > the view with OID 5330 cannot be found, How can I solve it?? >>You will have to recreate whatever referred to that view as well. >>If this isn't sufficient answer, you'll need to provide more detail, >>specifically what is it that you are doing when you get the error >>message? >>Cheers, >> Andrew. Ok, I will explain it better: first of all I had a view called datos_u_candidato, this view was working fine and there wasn't any problem with it; but I had to remove that view and, afterwards, I created it again, with the same name, and then when I tried to use it with: "SELECT * FROM datos_u_candidato;" I've got the error: "The view with OID5330 cannot be found" That's all, I don't know if this will be enough, anyway thank you all for your previous requests. Thanks!!