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@xxxxxx>
To: "elmarkivp" <elmarkivo@xxxxxxxxxxx>
Cc: <pgsql-php@xxxxxxxxxxxxxx>
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@xxxxxx
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
--
Sent via pgsql-php mailing list (pgsql-php@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php
