Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 2BA0C6359C9
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 11 Mar 2010 07:48:43 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 65590-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 11 Mar 2010 11:48:31 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from relay.ptn-ipout02.plus.net (relay.ptn-ipout02.plus.net
	[212.159.7.36])
	by mail.postgresql.org (Postfix) with ESMTP id CDF296357D3
	for <pgsql-sql@postgresql.org>; Thu, 11 Mar 2010 07:48:31 -0400 (AST)
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: AvsEAD5nmEvUOFPl/2dsb2JhbACaWXO7aIR6BA
Received: from plesk-mail01.plus.net ([212.56.83.229])
	by relay.ptn-ipout02.plus.net with ESMTP; 11 Mar 2010 11:48:29 +0000
Received: (qmail 13484 invoked from network); 11 Mar 2010 11:46:58 +0000
Received: from host86-142-60-221.range86-142.btcentralplus.com (HELO
	osiris.mauzo.dyndns.org) (86.142.60.221)
	by plesk-mail01.plus.net with SMTP; 11 Mar 2010 11:46:53 +0000
Received: (qmail 50802 invoked by uid 1001); 11 Mar 2010 11:46:48 -0000
Date: Thu, 11 Mar 2010 11:46:48 +0000
From: Ben Morrow <ben@morrow.me.uk>
To: dennis@teltel.com, pgsql-sql@postgresql.org
Subject: Re: Help : insert a bytea data into new table
Message-ID: <20100311114648.GA50794@osiris.mauzo.dyndns.org>
References: <hn49e1$2eob$1@news.hub.org>
	<20100309034626.GA12083@osiris.mauzo.dyndns.org>
	<20100309111410.GA15752@osiris.mauzo.dyndns.org>
	<20100310152510.GA37991@osiris.mauzo.dyndns.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <hn9qd0$152v$1@news.hub.org>
X-Newsgroups: pgsql.sql
Organization: Who, me?
User-Agent: Mutt/1.5.20 (2009-06-14)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.185 tagged_above=-10 required=5
	tests=BAYES_40=-0.185
X-Spam-Level: 
X-Archive-Number: 201003/56
X-Sequence-Number: 33763

Quoth dennis <dennis@teltel.com>:
> Dear Ben
> 
>     thanks for you anwser.
> I try to add function quote_literal on my sql statement .
> 
> but it raise other error message (quote_literal not support bytea format):
>       function quote_literal(bytea) does not exist

Which Postgres version are you using?

Ben