From: elmarkivp <elmarkivo@hotmail.com>
To: rod@iol.ie
Cc: pgsql-php@postgresql.org
Subject: Re: store data files encryptypted in database.
Date: Fri, 10 Oct 2008 13:10:29 -0300
Message-ID: <BAY108-DAV8D4136F45234D04D6D0FBA3350@phx.gbl> (raw)
References: <BAY108-DAV74F0B81BD22FF982A3641A3350@phx.gbl>
<48EF7744.2010108@iol.ie>
i have quoted $file and now thi is what happend...
$sql = "INSERT INTO SOME_TABLE (bytea_file) VALUES
(pgp_sym_decrypt_bytea('$file','somepass','cipher-algo=aes256'))";
ERROR: function pgp_sym_encrypt_bytea("unknown", "unknown", "unknown") does
not exist HINT: No function matches the given name and argument types. You
may need to add explicit type casts
so... with
$sql = "INSERT INTO SOME_TABLE (bytea_file) VALUES
(pgp_sym_decrypt_bytea('$file'::bytea,'somepass'::text,'cipher-algo=aes256'::text))";
ERROR: function pgp_sym_encrypt_bytea(bytea, text, text) does not exist
HINT: No function matches the given name and argument types. You may need to
add explicit type casts.
any idea?
----- Original Message -----
From: "Raymond O'Donnell" <rod@iol.ie>
To: "elmarkivp" <elmarkivo@hotmail.com>
Cc: <pgsql-php@postgresql.org>
Sent: Friday, October 10, 2008 12:39 PM
Subject: Re: [PHP] store data files encryptypted in database.
> On 10/10/2008 16:32, elmarkivp wrote:
>> $sql = "INSERT INTO SOME_TABLE (bytea_file) VALUES
>> (pgp_sym_decrypt_bytea($file,somepass,cipher-algo=aes256))";
>> pg_query($link, $sql) or die(pg_last_error($link));
>>
>> this error appear...
>>
>> ERROR: column "content_of_bytea_file" does not exist (
>> "content_of_bytea_file" is $file)
>
> At a guess, you need to quote the contents of $file in order to get PG
> to treat it as a string. If you don't, PG sees it as a column name,
> hence the error you're seeing.
>
> Ray.
>
> ------------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod@iol.ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>
> --
> Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-php
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: elmarkivo@hotmail.com, rod@iol.ie
Subject: Re: store data files encryptypted in database.
In-Reply-To: <BAY108-DAV8D4136F45234D04D6D0FBA3350@phx.gbl>
References: <BAY108-DAV74F0B81BD22FF982A3641A3350@phx.gbl> <48EF7744.2010108@iol.ie> <BAY108-DAV8D4136F45234D04D6D0FBA3350@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox