X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DF78D5288E for ; Tue, 16 Aug 2005 13:28:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31244-01 for ; Tue, 16 Aug 2005 16:28:48 +0000 (GMT) Received: from alvh.no-ip.org (200-85-218-206.bk4-dsl.surnet.cl [200.85.218.206]) by svr1.postgresql.org (Postfix) with ESMTP id D58CE52A0E for ; Tue, 16 Aug 2005 13:28:47 -0300 (ADT) Received: by alvh.no-ip.org (Postfix, from userid 1000) id E693BC2DC09; Tue, 16 Aug 2005 12:29:24 -0400 (CLT) Date: Tue, 16 Aug 2005 12:29:24 -0400 From: Alvaro Herrera To: "Buorn, Yoway" Cc: pgsql-admin@postgresql.org Subject: Re: Restore from pg_dumpall Message-ID: <20050816162924.GD32695@alvh.no-ip.org> Mail-Followup-To: "Buorn, Yoway" , pgsql-admin@postgresql.org References: <21A801CCBAC79545878E3C1137912E410112D029@CAMV02-MAIL01.ad.gd-ais.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <21A801CCBAC79545878E3C1137912E410112D029@CAMV02-MAIL01.ad.gd-ais.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.724 required=5 tests=[AWL=0.300, DNS_FROM_RFC_ABUSE=0.374, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/194 X-Sequence-Number: 18513 On Tue, Aug 16, 2005 at 08:55:30AM -0700, Buorn, Yoway wrote: > No, I'm not trying to back-port a dump. I simply followed the > instructions in the section 2.3.4 of the gforge manual which tells me to > go into the db/ folder and apply the schema changes in order for all sql > files dated after the existing installation. So I started with > 20050312.sql and it gave me this parse error near "CASCADE". > > You mention there's nothing wrong with this. Does this mean the message > is not really an error and I can safely ignore it? Not at all. What server version are you using? You can find out by issuing SELECT version(); -- Alvaro Herrera () One man's impedance mismatch is another man's layer of abstraction. (Lincoln Yeoh)