Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C68E19FA102 for ; Fri, 29 Dec 2006 20:48:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 49916-05 for ; Fri, 29 Dec 2006 20:48:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from perth.mailnetwork.co.uk (perth.mailnetwork.co.uk [80.175.28.46]) by postgresql.org (Postfix) with ESMTP id 4E5C69F9CE3 for ; Fri, 29 Dec 2006 20:48:28 -0400 (AST) Received: from user-514f7b79.l4.c3.dsl.pol.co.uk ([81.79.123.121]:3514 helo=[192.168.1.2]) by perth.mailnetwork.co.uk with esmtpa (Exim 4.63) (envelope-from ) id 1H0SOl-0005sN-40; Sat, 30 Dec 2006 00:48:31 +0000 Message-ID: <4595B79A.2020304@mailnetwork.co.uk> Date: Sat, 30 Dec 2006 00:49:30 +0000 From: "Andy Shellam (Mailing Lists)" User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Sean Murphy , pgsql-admin@postgresql.org Subject: Re: Frustrating LO problem References: <4595B018.3090600@equipoint.com> In-Reply-To: <4595B018.3090600@equipoint.com> 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: 200612/361 X-Sequence-Number: 24153 Hi Sean, I'm certainly not a PostgreSQL expert when it comes to large objects etc, but there's one thing that jumps out at me here (perhaps someone else can see the same line of thought and into more depth as I can't think of much else to suggest?) > The logfile lines when it doesn't: > { > WARNING: nonstandard use of \\ in a string literal at character 94 > HINT: Use the escape string syntax for backslashes, e.g., E'\\'. > LOG: statement: insert into doc.templates (description, last_update, > template) values ('test', '12/29/2006', 'testfile\\056contents') > ERROR: invalid input syntax for type oid: "testfile\056contents" > ^^ here it seems to be thinking that column 'template' is of type 'oid', not 'lo' (if I'm reading the error right: "invalid input syntax for type oid"). Just double-check what data-type that column is in this database. Regards, Andy.