Search Postgresql Archives

Re: Re: Re: [GENERAL] Can not decompress a compressed string under plpy!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thursday 21 May 2009 3:26:22 pm Timmy wrote:

>
> Yes, most of your guess is correct.
> I'm using postgresql 8.3.x and ms windows 2000.
> The compressed string is saved to the table in binary
> format using the psycopg. I had set the table field to bytea data type.
> I want to use the plpythonu to decompress the stored
> string.
> Althout I imported the zlib module, it still failed.
> I can successfully get back the decompressed string if
> I use the psycopg either inside or outside the plpythonu.
> But if without psycopg, plpythonu itself can not decompress the string.
> I can use the psycopg inside the plpythonu but I must need to write
> security information (including user name,password,server ip,port
> number,...) to the connection string inside plpythonu too. This is a
> problem.
>
> Thanks!

Now you are getting outside my experience level. As a guess though I would say 
that psycopg is taking care of escaping the data on the way out, whereas your 
plpythonu function is not. 
See www.postgresql.org/docs/8.3/interactive/datatype-binary.html for more 
information.

-- 
Adrian Klaver
aklaver@xxxxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux