X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8EE17D1BA93 for ; Tue, 9 Mar 2004 19:17:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 29741-05 for ; Tue, 9 Mar 2004 15:17:22 -0400 (AST) Received: from cougar.DIT.UMontreal.CA (chene.DIT.UMontreal.CA [132.204.246.20]) by svr1.postgresql.org (Postfix) with ESMTP id A878CD1B979 for ; Tue, 9 Mar 2004 15:17:16 -0400 (AST) Received: from chene.DIT.UMontreal.CA(132.204.246.20) by cougar.DIT.UMontreal.CA via csmap id 93d1a03c_71fe_11d8_87cb_0002b39fa8dc_5851; Tue, 09 Mar 2004 14:18:45 -0500 (EST) Received: from cougar.DIT.UMontreal.CA (ravenna.LEXUM.UMontreal.CA [132.204.136.56]) by chene.DIT.UMontreal.CA (8.12.10/8.12.10) with ESMTP id i29JHDsA031097 for ; Tue, 9 Mar 2004 14:17:13 -0500 Received: from ravenna.LEXUM.UMontreal.CA(132.204.136.56) by cougar.DIT.UMontreal.CA via csmap id 9137f722_71fe_11d8_8849_0002b39fa8dc_5819; Tue, 09 Mar 2004 14:18:38 -0500 (EST) Received: from lexum.umontreal.ca ([::ffff:192.168.4.171]) (AUTH: PLAIN mederyf, TLS: TLSv1/SSLv3,128bits,RC4-MD5) by mail.lexum.umontreal.ca with esmtp; Tue, 09 Mar 2004 14:10:23 -0500 Message-ID: <404E19D1.8070702@lexum.umontreal.ca> Date: Tue, 09 Mar 2004 14:24:01 -0500 From: "=?ISO-8859-1?Q?Fr=E9d=E9ric_M=E9dery?=" User-Agent: Mozilla Thunderbird 0.5 (X11/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: migration from postgresql-7.2. to 7.4.1 : invalid command \n Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-NAI-Spam-Score: 1.0 X-NAI-Spam-Level: * X-NAI-Spam-Rules: 1 Rules triggered INVALID_DATE=1.025 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/155 X-Sequence-Number: 12724 I did a pg_dump with the -d option during the extract. Inside the dump I have a lot of \012. i replace those with \n (carriage return). But when I try to import into a new DB I had : invalid command \n Is ther e a better way to add carriage return in the sql file ?