X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 91874D8D31 for ; Wed, 9 Nov 2005 03:25:18 -0400 (AST) 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 30017-04 for ; Wed, 9 Nov 2005 07:25:15 +0000 (GMT) X-Greylist: delayed 00:06:40.19103 by SQLgrey- Received: from web33406.mail.mud.yahoo.com (web33406.mail.mud.yahoo.com [68.142.206.138]) by svr1.postgresql.org (Postfix) with SMTP id 684FCD8F0B for ; Wed, 9 Nov 2005 03:25:15 -0400 (AST) Received: (qmail 40377 invoked by uid 60001); 9 Nov 2005 07:18:35 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=EhKp9oHJeHTPIYjByC1m+ZpWzOAaviSGCB//BCmCly6JyeXhQd2GNRWB5ISoV+ortavcclfFm/db3nL39bA7oiWS359e3QiidOtRpHU6IjpQK3fc2latDrJvyV2UIuPPBpwQc6XvAlWAeNWrw/xV8e9cReGJGliBPc0k/yigCRg= ; Message-ID: <20051109071835.40375.qmail@web33406.mail.mud.yahoo.com> Received: from [222.124.237.27] by web33406.mail.mud.yahoo.com via HTTP; Tue, 08 Nov 2005 23:18:35 PST Date: Tue, 8 Nov 2005 23:18:35 -0800 (PST) From: Louise Catherine Subject: Migrating database from postgresql 7.4.6 to postgresql 8.0.3 To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.296 required=5 tests=[AWL=0.307, DNS_FROM_RFC_ABUSE=0.479, FROM_HAS_MIXED_NUMS=1.51] X-Spam-Score: 2.296 X-Spam-Level: ** X-Archive-Number: 200511/72 X-Sequence-Number: 23323 Hi, I would like to migrating my database from postgresql 7.4.6 to postgresql 8.0.3. Are there any problem during migrating database? a casting problem or sintax problem, or other problem? Can somebody help me answering this question? Or Does anyone ever try to migrating database from postgresql 7.4.6 to postgresql 8.0.3? Could you tell me which part that change from postgresql 7.4.6 to postgre 8.0.3? Thank's a lot, Louise C.S. __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com