Re: [psycopg] OT? plpython2u

On 10/20/2016 04:51 PM, Nahum Castro wrote:
> Hello Adrian.
>
> The result image to replace the big one.

So if you are replacing the data in a bytea column with a function that
returns bytea, why encode it?

Unless I am missing something why not just UPDATE with the raw(bytea)
return value?

>
> I have a table with images @ 12K but, went on vacation an when returned
> someone replaced the pictures with high resolution images @6M. The app
> then become very slow and halted.
>
> I have already made the script in python to resize all the images from a
> folder before to upload to the database, so it occurred to me do the
> same but on the database.
>
> Thanks again.
>
> 2016-10-20 18:32 GMT-05:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>:
>
> On 10/20/2016 02:42 PM, Nahum Castro wrote:
>
> Hello,
>
> The script always returns.
> select encode(ajustar(foto), 'escape') from personal where id=193;
> encode
> -----------------------------------------------------------------
> <PIL.Image.Image image mode=RGB size=300x347 at 0x7F08A11B1650>
>
>
>
> So what do you want it to return a where do you want to return?
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
>
>
> --
> *Nahum Castro González*
> Blvd. Perdigón 214, Brisas del Lago.
> CP 37207
> León, Guanajuato, México
> Tel (477)1950304
> Cel (477)1274694

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

-
Enviado a la lista de correo pgsql-es-ayuda (pgsql-es-ayuda(at)postgresql(dot)org)
Para cambiar tu suscripcin:
http://www.postgresql.org/mailpref/pgsql-es-ayuda