Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 576D3475E20 for ; Sun, 27 Oct 2002 03:29:20 -0500 (EST) Received: from kant.catalyst.net.nz (203-79-74-78.adsl.paradise.net.nz [203.79.74.78]) by postgresql.org (Postfix) with ESMTP id 376C7475AEC for ; Sun, 27 Oct 2002 03:28:59 -0500 (EST) Received: from 127.0.0.1 (ident=unknown) by kant.catalyst.net.nz with esmtp (masqmail 0.2.11) id 185in1-18J-00; Sun, 27 Oct 2002 21:28:55 +1300 Subject: Re: Problems with OIDs From: Andrew McMillan To: Carlos =?ISO-8859-1?Q?Garc=ECa_G=F2mez?= Cc: Lista Postgresql In-Reply-To: References: Content-Type: text/plain; charset=ISO-8859-1 Organization: Message-Id: <1035707335.3698.1.camel@kant.mcmillan.net.nz> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.1.2 (Preview Release) Date: 27 Oct 2002 21:28:55 +1300 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/65 X-Sequence-Number: 1580 On Thu, 2002-10-24 at 19:33, Carlos Garcìa Gòmez wrote: > 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. -- --------------------------------------------------------------------- Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267 Survey for free with http://survey.net.nz/ ---------------------------------------------------------------------