From: | Keith Wong <keith(at)e-magine(dot)com(dot)au> |
---|---|
To: | "Aristeu Gil Alves Junior" <arisjr(at)terra(dot)com(dot)br>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Blob Upload |
Date: | 2000-11-21 13:42:29 |
Message-ID: | 4.3.2.7.0.20001122004055.02970ed8@mail.e-magine.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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<arisjr(at)terra(dot)com(dot)br>
>IT Analyst
>Porto Alegre/RS - Brasil
>****************************************************
>"Communications without intelligence is noise;
>Intelligence without communications is irrelevant."
>Gen. Alfred. M. Gray, USMC
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-11-21 16:29:33 | Re: Postgres 7.0.X and arrow keys |
Previous Message | Keith Wong | 2000-11-21 13:31:09 | Re: Persistent Connects (pg_pconnect) |