X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3406CD1E6A7 for ; Mon, 10 May 2004 11:51:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 25459-02 for ; Mon, 10 May 2004 11:51:01 -0300 (ADT) Received: from vscan02.westnet.com.au (vscan02.westnet.com.au [203.10.1.132]) by svr1.postgresql.org (Postfix) with ESMTP id 37467D1E761 for ; Mon, 10 May 2004 11:50:57 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by localhost (Postfix) with ESMTP id 6CB8E1014A7; Mon, 10 May 2004 22:51:01 +0800 (WST) Received: from [192.168.1.9] (dsl-202-72-133-22.wa.westnet.com.au [202.72.133.22]) by vscan02.westnet.com.au (Postfix) with ESMTP id 00EBD10120B; Mon, 10 May 2004 22:51:00 +0800 (WST) Message-ID: <409F96D8.30906@familyhealth.com.au> Date: Mon, 10 May 2004 22:51:04 +0800 From: Christopher Kings-Lynne User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Joe Nilson Zegarra Galvez Cc: Lista PG-PHP Subject: Re: field md5 References: <1084199317.2679.3.camel@dune.kolareal.net> In-Reply-To: <1084199317.2679.3.camel@dune.kolareal.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/12 X-Sequence-Number: 2731 > Hi, i'm working with a table that must have the password field crypted > in md5 with php, i'm using a 7.3.4-RH Postgresql version, how i can set > the type of the field?, if the password must have 12 how max length but > is stored in md5?. All MD5's are 32 characters in length. You need to have a field of type VARCHAR(32) to store your encrypted password. > And is stable the 7.4.2? o r i must wait to the RHDB next release to > upgrade my postgres?. 7.4.2 is the latest, most stable release. Chris