X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 12C8811F6931 for ; Wed, 12 Apr 2006 11:22:11 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.001 X-Spam-Level: X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id HVjAd4r3ZNRm for ; Wed, 12 Apr 2006 11:21:57 -0300 (ADT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id B2C1211F6928 for ; Wed, 12 Apr 2006 11:22:01 -0300 (ADT) Received: from smtp10.wanadoo.fr (smtp10.wanadoo.fr [193.252.22.21]) by svr4.postgresql.org (Postfix) with ESMTP id DABF45AF84C for ; Wed, 12 Apr 2006 14:22:02 +0000 (GMT) Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf1009.wanadoo.fr (SMTP Server) with ESMTP id 4E81E2800122 for ; Wed, 12 Apr 2006 16:21:59 +0200 (CEST) Received: from EMC3 (AToulouse-152-1-44-40.w82-125.abo.wanadoo.fr [82.125.154.40]) by mwinf1009.wanadoo.fr (SMTP Server) with SMTP id 1D6FA280012B for ; Wed, 12 Apr 2006 16:21:59 +0200 (CEST) X-ME-UUID: 20060412142159120.1D6FA280012B@mwinf1009.wanadoo.fr Message-ID: <020401c65e3c$70721050$0200a8c0@EMC3> From: =?iso-8859-1?Q?Eric_Mauvi=E8re?= To: Subject: binary cursor returning truncated data Date: Wed, 12 Apr 2006 16:21:49 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0201_01C65E4D.33A9DA20" 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/8 X-Sequence-Number: 3478 This is a multi-part message in MIME format. ------=_NextPart_000_0201_01C65E4D.33A9DA20 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. Does someone know if it is a current PHP restriction ? Thanks by advance, Eric ------=_NextPart_000_0201_01C65E4D.33A9DA20 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_0201_01C65E4D.33A9DA20--