Re: Storing a file hash as primary key

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: Storing a file hash as primary key
Дата
Msg-id 409BEF36.5010200@joeconway.com
обсуждение исходный текст
Ответ на Re: Storing a file hash as primary key  (Greg Stark <gsstark@mit.edu>)
Список pgsql-general
Greg Stark wrote:
> Personally I would have preferred bytea(16) but for some reason the php
> drivers seem to jut drop NULL there when I try to store raw binary md5 hashes.
> So for now I just declared it bytea with no length specification and store the
> hex encoded hash.
>
> If anyone knows how to get Pear::DB to store binary data in a bytea column, by
> all means.

Did you try using pg_escape_bytea()?

Joe


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Interpreting vacuum verbosity
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Strengthing mail restriction rules in Postfix