Re: Sequences/defaults and pg_dump
От | Doug McNaught |
---|---|
Тема | Re: Sequences/defaults and pg_dump |
Дата | |
Msg-id | 87mzgztmsk.fsf@asmodeus.mcnaught.org обсуждение исходный текст |
Ответ на | Re: Sequences/defaults and pg_dump (Bruno Wolff III <bruno@wolff.to>) |
Ответы |
Re: Sequences/defaults and pg_dump
|
Список | pgsql-general |
Bruno Wolff III <bruno@wolff.to> writes: > On Tue, Feb 07, 2006 at 15:28:31 +0300, > Nikolay Samokhvalov <samokhvalov@gmail.com> wrote: >> The real situation would be as the following. >> I want to use some algorithm to hide real number of registered users >> in my table user. So, I don't want to use simple sequence, when every >> new registered user in my system can guess what is the number of >> registered users simply observing his ID. So, I use following > (N and M are said to be "relatively prime".) > > The above method isn't very secure. You might be better off using a block > cipher in counter mode, depending on how badly you want to keep the number > of users secret. Even that won't be foolproof as the users might cooperate > with each other to estimate how many of them there are. Or, just start your sequence counting at 1000000. Or use bigint and start it at a billion. -Doug
В списке pgsql-general по дате отправления: