From: The One <i51359@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Encrypting in Postgresql-8.0
Date: Fri, 12 Aug 2005 08:42:38 -0700 (PDT)
Message-ID: <20050812154238.7884.qmail@web33910.mail.mud.yahoo.com> (raw)
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
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: i51359@yahoo.com
Subject: Re: Encrypting in Postgresql-8.0
In-Reply-To: <20050812154238.7884.qmail@web33910.mail.mud.yahoo.com>
* 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