Received: from mail-ob01.one.net.au (mail-ob01.one.net.au [61.12.0.161]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eALDevs97441 for ; Tue, 21 Nov 2000 08:40:58 -0500 (EST) (envelope-from keith@e-magine.com.au) Received: Received: [from darthvader.e-magine.com.au (async222-syd-isp-242.nas.one.net.au [61.12.20.223]) by mail-ob01.one.net.au with ESMTP id eALDcYR23873; Wed, 22 Nov 2000 00:38:35 +1100 (EST)] Message-Id: <4.3.2.7.0.20001122004055.02970ed8@mail.e-magine.com.au> X-Sender: e-magine@mail.e-magine.com.au X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Wed, 22 Nov 2000 00:42:29 +1100 To: "Aristeu Gil Alves Junior" , From: Keith Wong Subject: Re: Blob Upload In-Reply-To: <00a801c053bc$033d9b20$aa14b0c8@caras> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1"; format=flowed Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by mail.postgresql.org id eALDf0s97456 X-Archive-Number: 200011/172 X-Sequence-Number: 203 Do you mean VARCHAR[30] or VARCHAR(30)?? I think you're creating an array of chars... but what you want is just a VARCHAR type with 30 characters... It may explain the array error you are getting. Keith At 11:07 AM 21/11/2000 -0200, Aristeu Gil Alves Junior wrote: >I´m trying to upload a gif image from a web interface (apache/php) without >success. >I´m using the input type ="file". >Have someone already made this work? > >And even when I try to upload from the SQL interface of Tkl PgAccess... : >The table: >CREATE TABLE images (name VARCHAR[30] , img OID); > >SQL Command >INSERT INTO images (name, img) VALUES (´img01.gif´ , >lo_import(´/images/test.gif´) ); > >....it brings up the error: >ERROR: array_in: Need to specify dimension > >Any help will be of great value. >Thanks to all. > >Best Regards >**************************************************** >Aristeu Gil Alves Junior >IT Analyst >Porto Alegre/RS - Brasil >**************************************************** >"Communications without intelligence is noise; >Intelligence without communications is irrelevant." >Gen. Alfred. M. Gray, USMC