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 4984BD1B459 for ; Wed, 7 Apr 2004 04:43:35 -0300 (ADT) 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 59691-02 for ; Wed, 7 Apr 2004 04:43:35 -0300 (ADT) Received: from mta04-svc.ntlworld.com (mta04-svc.ntlworld.com [62.253.162.44]) by svr1.postgresql.org (Postfix) with ESMTP id 2D1A2D1B515 for ; Wed, 7 Apr 2004 04:43:33 -0300 (ADT) Received: from evesham ([80.1.245.211]) by mta04-svc.ntlworld.com (InterMail vM.4.01.03.37 201-229-121-137-20020806) with SMTP id <20040407074311.CQVG1202.mta04-svc.ntlworld.com@evesham> for ; Wed, 7 Apr 2004 08:43:11 +0100 From: "Marion McKelvie" To: Subject: Re: restoring large objects Date: Wed, 7 Apr 2004 08:43:50 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 In-Reply-To: <6115.1081318077@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/103 X-Sequence-Number: 13076 Good idea but I'm not sure if the application will then handle the changed column type correctly. I'll give it a go and let you know... -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Tom Lane Sent: 07 April 2004 07:08 To: Marion McKelvie Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] restoring large objects "Marion McKelvie" writes: > Many thanks - you're right, the references are stored (by the application > using the database) in a column of type text. Yuck :-(. A possible solution is to dump the schema and data separately (schema in a plain text dump, data in an -Fc or -Ft dump since plain text doesn't support dumping LOs). Then manually edit the schema file to change the column data type to "oid". Then load. I honestly am not sure that this will work cleanly, but it's worth trying --- and if it doesn't work, please let me know where it goes wrong. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org