X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 49D5C9FA5C8 for ; Mon, 12 Jun 2006 17:51:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 15886-05 for ; Mon, 12 Jun 2006 17:51:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp101.plus.mail.re2.yahoo.com (smtp101.plus.mail.re2.yahoo.com [206.190.53.26]) by postgresql.org (Postfix) with SMTP id 8C2849FA3CD for ; Mon, 12 Jun 2006 17:51:23 -0300 (ADT) Received: (qmail 90681 invoked from network); 12 Jun 2006 20:51:20 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding; b=qHP/5BSp1PLgfQFlQu8dHRmcDXDcqlGsbEnlo/dCXNmcdOLgQW3jE/oaFgpRxOAQh5h8HWLybJoed8zXxw1VqnvsCY7l1+gZrzGBKm2RSloyNpfZAHKRpEDiDYOkfYLh6XbVkU3tejjwhY7ezoaowC3Jxyqmu2ewYcg5HjrQSZ8= ; Received: from unknown (HELO ?192.168.20.100?) (renneyt@68.81.191.20 with plain) by smtp101.plus.mail.re2.yahoo.com with SMTP; 12 Jun 2006 20:51:19 -0000 Message-ID: <448DD3C6.8050801@yahoo.com> Date: Mon, 12 Jun 2006 16:51:18 -0400 From: "renneyt@yahoo.com" User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: postgres Subject: pg_dump/restore problem Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/109 X-Sequence-Number: 22071 I am trying to move some data from an 8.0.7 instance to a 7.4.8 instance. I did a pg_dump and then did a pg_restore. For the most part the data transferred through to the older instance but I had problems with the sequence updates. SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('nw_foo', 'foo_id'), 678, true); ERROR: function pg_catalog.pg_get_serial_sequence("unknown", "unknown") does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. I am looking for a an alternative to manually issuing alter sequence commands. Any help appreciated.