X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 1016411F6934 for ; Wed, 12 Apr 2006 11:53:28 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -0.049 X-Spam-Level: X-Spam-Status: No, score=-0.049 required=5 tests=[BAYES_40=-0.185, FORGED_RCVD_HELO=0.135, HTML_MESSAGE=0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id G81LaSnKi9Yq for ; Wed, 12 Apr 2006 11:53:17 -0300 (ADT) X-Greylist: delayed 00:32:28.634292 by SQLgrey- Received: from emc3.fr (unknown [62.23.182.143]) by postgresql.org (Postfix) with ESMTP id 34D7511F68FF for ; Wed, 12 Apr 2006 11:53:14 -0300 (ADT) Received: from EMC3 [82.125.154.40] by emc3.fr with ESMTP (SMTPD32-8.15) id ACB520002F8; Wed, 12 Apr 2006 16:20:37 +0200 Message-ID: <01e001c65e3c$3e9070e0$0200a8c0@EMC3> From: =?iso-8859-1?Q?Eric_Mauvi=E8re?= To: Subject: binary cursor returning truncated data Date: Wed, 12 Apr 2006 16:20:17 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01DD_01C65E4C.FCCC9830" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2670 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-Archive-Number: 200604/10 X-Sequence-Number: 3480 This is a multi-part message in MIME format. ------=_NextPart_000_01DD_01C65E4C.FCCC9830 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, i am trying to retrieve binary content of a bytea field (or postgis = geometry field) with a binary cursor with PHP : $sql=3D"BEGIN;DECLARE mycursor BINARY CURSOR FOR SELECT shape FROM = $layerName; fetch all in mycursor;" ....pg_query...=20 But my shape field shows only two bytes of data. =20 Does someone know if it is a current PHP restriction ? Thanks by advance, Eric ------=_NextPart_000_01DD_01C65E4C.FCCC9830 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
 
i am trying to retrieve binary content = of a bytea=20 field (or postgis geometry field) with a binary cursor with PHP = :
 
$sql=3D"BEGIN;DECLARE mycursor BINARY = CURSOR FOR=20 SELECT shape FROM $layerName; fetch all in mycursor;"
....pg_query...
 
But my shape field shows only two = bytes of=20 data.
 
Does someone know if it is a current = PHP=20 restriction ?
 
Thanks by advance,
 
Eric
------=_NextPart_000_01DD_01C65E4C.FCCC9830--