[SQL] Encrypting in Postgresql-8.0

[The One]

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.adlltool: bfd_open failed open stub file: dakes03194.omake[2]: *** [libpostgres.a] Error 1make[2]: *** Deleting file `libpostgres.a'make[2]: Leaving directory `/usr/local/src/postgresql-8.0.3/src/backend'make[1]: *** [all] Error 2make[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 

[SQL] What libraries need to be included in C program for encrypt and decrypt functions?

[The One]

Hi,
 
Can some body tell me what I need to include in the makefile for my C program so it will call the correct encrypt/decrypt functions.
 
This is what I have in the makefile
testcrypto:  ${CC} -o ${BIN}/testcrypto.exe testcrypto.c -I/usr/include/postgresql/server/libpq -L/lib/postgresql -lpq -lcrypt
 
I'm calling the function like this 
printf("test encryption: %s", encrypt("hello", "", "aes");
 
But I'm getting too many arguments in function encrypt.
 
Thank you
 
 
		 Start your day with Yahoo! - make it your home page 

[SQL] how to do a select * and decrypt a column at the same time?

[The One]

Hello,
 
I have a table with one encrypted column.
How can I do a select statement such that it will select all columns from the table and at the same time will decrypt it too?__Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com 

[SQL] Panic: Page Add Item: Corrupted page pointers

[The One]

Hi,
 
I'm getting this error when try to create a table in Postgresql 7.3, windows2000:
 
Panic: Page Add Item: Corrupted page pointers: lower=24258, upper=39318, special=65421
 
LOG: statement = create table data(key unique, status text, info text)
LOG: pg_recvby : unexpected EOF on client connection
LOG: server process  was terminated by signal 6
LOG: all server processes terminated; reinitializing shared memory and semaphores
.
 
Thank you
 
 
 
		Yahoo! for Good 
Watch the Hurricane Katrina Shelter From The Storm concert

Re: [SQL] Panic: PageAddItem: Corrupted page pointers

[The One]

Actually, I'm getting this error everytime I try to create a table.
 
Can someone please help?The One <[EMAIL PROTECTED]> wrote:

Hi,
 
I'm getting this error when try to create a table in Postgresql 7.3, windows2000:
 
Panic: Page Add Item: Corrupted page pointers: lower=24258, upper=39318, special=65421
 
LOG: statement = create table data(key unique, status text, info text)
LOG: pg_recvby : unexpected EOF on client connection
LOG: server process  was terminated by signal 6
LOG: all server processes terminated; reinitializing shared memory and semaphores
.
 
Thank you
 
 
 


Yahoo! for GoodWatch the Hurricane Katrina Shelter From The Storm concert 
		Yahoo! for Good 
Watch the Hurricane Katrina Shelter From The Storm concert

[SQL] How to install Postgresql 8 on different drive letter?

[The One]

Hi,
 
I downloaded postgresql 8.0 MSI.  How can I tell postgresql to install on a different drive letter?
 
Thank you
		Yahoo! for Good 
Click here to donate to the Hurricane Katrina relief effort.