Weird Database Encryption Bug

From: Joanne Formoso <joanneformoso(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Weird Database Encryption Bug
Date: 2003-06-08 10:47:52
Message-ID: 20030608104752.96059.qmail@web40609.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

We are currently migrating databases from MySQL to
Postgres SQL when we noticed this weird bug. In the
database we encrypted the ID numbers of the users.
Now whenever a transaction is requested by a certain
user we log the transaction by getting the encrypted
ID number, time, etc and put it in a history table.

For example the encrypted ID number is something like
12345abcdef in the users table. The input for the ID
number in the history table became something like
12345ghiklm. Now we found this strange since we just
copy the ID number from the users table to the history
table.

Any thoughts on why this happened? Can this kind of
bug happen in Postgres SQL as well?

Regards,
Joanne

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2003-06-08 11:22:36 Re: Question regarding keyword checkboxes in database design
Previous Message Antti Haapala 2003-06-08 09:05:06 Re: Return Record