Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0272E475E45 for ; Thu, 24 Oct 2002 04:44:45 -0400 (EDT) Received: from virtual1.giganet.nl (tarantula.giganet.nl [212.125.143.1]) by postgresql.org (Postfix) with ESMTP id B4154475D84 for ; Thu, 24 Oct 2002 04:44:42 -0400 (EDT) Received: from artemis.cuci.nl (artemis.cuci.nl [212.125.128.9]) by virtual1.giganet.nl (BuGless_3.01) with ESMTP id g9O8ih921684 for ; Thu, 24 Oct 2002 10:44:43 +0200 Received: from adlsa ([10.1.12.174]) by artemis.cuci.nl (BuGless_3.01) with ESMTP id g9O8ifE2008368 for ; Thu, 24 Oct 2002 10:44:42 +0200 Message-Id: <200210240844.g9O8ifE2008368@artemis.cuci.nl> Received: from Spooler by adlsa (Mercury/32 v3.32) ID MO00011B; 24 Oct 02 10:45:15 +0200 Received: from spooler by arbodienst-limburg.nl (Mercury/32 v3.32); 24 Oct 02 10:42:44 +0200 From: "Jules Alberts" Organization: ARBOdienst Limburg BV To: pgsql-php@postgresql.org Date: Thu, 24 Oct 2002 10:42:25 +0200 MIME-Version: 1.0 Subject: Re: Problems with OIDs Reply-To: jules.alberts@arbodienst-limburg.nl In-reply-to: X-mailer: Pegasus Mail for Windows (v4.02a) Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: Quoted-printable Content-description: Mail message body X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/58 X-Sequence-Number: 1573 On 24 Oct 2002 at 8:39, Carlos Garc=EDa G=F3mez 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 sa= me > name, because I need it to be this way) and get the an error telling me t= hat > the view with OID 5330 cannot be found, How can I solve it?? OID's change when you do a dump / restore. Never use hardcoded OIDs in your app!