X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B960852BB7 for ; Fri, 12 Aug 2005 12:42:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43483-04 for ; Fri, 12 Aug 2005 15:42:40 +0000 (GMT) Received: from web33910.mail.mud.yahoo.com (web33910.mail.mud.yahoo.com [66.163.178.74]) by svr1.postgresql.org (Postfix) with SMTP id 1C38352C57 for ; Fri, 12 Aug 2005 12:42:39 -0300 (ADT) Received: (qmail 7886 invoked by uid 60001); 12 Aug 2005 15:42:38 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=pEF3iDns+wBUbiXNRrgxmKOiBvYKR2ps05qr/vNdleXtSvBZW2vX0I26r9tGJdjOD8LHRqj9cMpKXlK48z5AyXcgwTTa8DecodoTo7T4UX0ib1OEyGnwr+Otk89t0KL2d54Nou6PmUlzrCAdG1xMD/oA2CGCB/iW06TUCLrG6UU= ; Message-ID: <20050812154238.7884.qmail@web33910.mail.mud.yahoo.com> Received: from [68.209.250.7] by web33910.mail.mud.yahoo.com via HTTP; Fri, 12 Aug 2005 08:42:38 PDT Date: Fri, 12 Aug 2005 08:42:38 -0700 (PDT) From: The One Subject: Encrypting in Postgresql-8.0 To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-864603459-1123861358=:6704" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.395 tagged_above=0 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374, FROM_ENDS_IN_NUMS=0.516, HTML_20_30=0.504, HTML_MESSAGE=0.001] X-Spam-Level: * X-Archive-Number: 200508/71 X-Sequence-Number: 22299 --0-864603459-1123861358=:6704 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, I'm running Postgresql-8.0 for the database, using cygwin and PostgreSQL 7.4.5 compiled lib. When I tried to encrypt some data by calling encrypt() function, I'm getting blank returns to me from the encrypt function. I'm not sure I'm using the encrypt() function incorrectly or is it PostgreSql 7.4.5 lib not compatible with Postgresql-8.0. I tried to compile Postgresql-8.0.3 in cygwin, but it failed. The error I was getting is: dlltool --dllname postgres.exe --def postgres.def --output-lib libpostgres.a dlltool: bfd_open failed open stub file: dakes03194.o make[2]: *** [libpostgres.a] Error 1 make[2]: *** Deleting file `libpostgres.a' make[2]: Leaving directory `/usr/local/src/postgresql-8.0.3/src/backend' make[1]: *** [all] Error 2 make[1]: Leaving directory `/usr/local/src/postgresql-8.0.3/src' make: *** [all] Error 2 I really think I'm not using the encrypt function correctly. Can some one some me an example on how to encrypt data before insert it into the database and decrypt it when retreive from the database? Thank you --------------------------------- Start your day with Yahoo! - make it your home page --0-864603459-1123861358=:6704 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Hi,
 
I'm running Postgresql-8.0 for the database, using cygwin and PostgreSQL 7.4.5 compiled lib.
 
When I tried to encrypt some data by calling encrypt() function, I'm getting blank returns to me from the encrypt function.  I'm not sure I'm using the encrypt() function incorrectly or is it PostgreSql 7.4.5 lib not compatible with Postgresql-8.0.
 
I tried to compile Postgresql-8.0.3 in cygwin, but it failed.  The error I was getting is:
dlltool --dllname postgres.exe --def postgres.def --output-lib libpostgres.a
dlltool: bfd_open failed open stub file: dakes03194.o
make[2]: *** [libpostgres.a] Error 1
make[2]: *** Deleting file `libpostgres.a'
make[2]: Leaving directory `/usr/local/src/postgresql-8.0.3/src/backend'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/usr/local/src/postgresql-8.0.3/src'
make: *** [all] Error 2
 
I really think I'm not using the encrypt function correctly.  Can some one some me an example on how to encrypt data before insert it into the database and decrypt it when retreive from the database?
 
Thank you
 

Start your day with Yahoo! - make it your home page --0-864603459-1123861358=:6704--