Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 471E1475FB5 for ; Thu, 24 Oct 2002 06:17:57 -0400 (EDT) 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 18491475E8A for ; Thu, 24 Oct 2002 06:17:56 -0400 (EDT) Received: from 127.0.0.1 (ident=unknown) by kant.catalyst.net.nz with esmtp (masqmail 0.2.11) id 184f3q-5SB-00; Thu, 24 Oct 2002 23:17:54 +1300 Subject: Re: Problems with OIDs From: Andrew McMillan To: Carlos =?ISO-8859-1?Q?Garc=EDa_G=F3mez?= Cc: Lista Postgresql In-Reply-To: References: Content-Type: text/plain; charset=ISO-8859-1 Organization: Message-Id: <1035454673.6372.755.camel@kant.mcmillan.net.nz> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.1.1 (Preview Release) Date: 24 Oct 2002 23:17:53 +1300 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/55 X-Sequence-Number: 1570 On Thu, 2002-10-24 at 19:39, 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 need to redefine the thing that you do not mention which refers to the view - possibly this may be another view. When you recreate that, it will be created referencing the correct OID. Regards, 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/ ---------------------------------------------------------------------