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

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.

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

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=24

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

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 connect

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

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 ar

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

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 -lc

[SQL] Encrypting in Postgresql-8.0

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 Postgr