X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3A70F3A6693 for ; Fri, 10 Dec 2004 19:05:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00205-03 for ; Fri, 10 Dec 2004 19:04:59 +0000 (GMT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by svr1.postgresql.org (Postfix) with ESMTP id 7930B3A678A for ; Fri, 10 Dec 2004 18:26:57 +0000 (GMT) Received: from mail2.atl.registeredsite.com (mail2.atl.registeredsite.com [64.224.219.76]) by svr4.postgresql.org (Postfix) with ESMTP id 036135B4CE9 for ; Fri, 10 Dec 2004 10:06:00 +0000 (GMT) Received: from pixelart.es (pixelart.es [216.122.189.118] (may be forged)) by mail2.atl.registeredsite.com (8.12.11/8.12.8) with ESMTP id iBAA4wZP017475 for ; Fri, 10 Dec 2004 10:04:58 GMT Received: from mj (224.Red-80-32-232.pooles.rima-tde.net [80.32.232.224]) by pixelart.es (8.8.7/8.8.5) with ESMTP id CAA09614 for ; Fri, 10 Dec 2004 02:04:56 -0800 (PST) From: =?iso-8859-1?Q?M=AA_Jos=E9_Sempere?= To: Subject: pgcrypto module for WINDOWS Date: Fri, 10 Dec 2004 11:04:49 +0100 Organization: Pixelart S.L. Message-ID: <000501c4de9f$b3c90ac0$0900a8c0@mj> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0006_01C4DEA8.158D72C0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4510 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-MS-TNEF-Correlator: 000000007424DBF3DB951549BF4CDF1566A6AF6844FA2400 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.026 tagged_above=0 required=5 tests=RCVD_IN_NJABL_PROXY X-Spam-Level: * X-Archive-Number: 200412/77 X-Sequence-Number: 15663 This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C4DEA8.158D72C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, We are interested in installing the pgcrypto module of PostgreSQL for Windows, In order to use the function digest() for creating index on bytea type fields: create unique index my_index on my_table (digest(my_bytea_field, = 'md5')); HOW CAN WE INSTALL THE PGCRYPTO MODULE FOR WINDOWS? DO WE HAVE JUST TO INSTALL, OR DO WE NEED TO RECOMPILE SOMETHING? In the first case (just install), what do we have to install and where = do we have to download it from? In the second case (recompile), what and how do we have to recompile and where do we have to download it from?=20 We have found the library pgcrypto.dell in our hard disk, and also the = files pgcrypto.sql and pgcrypto.readme. We have read the pgcrypto.readme, but we are made a mistake. Who needs to know the digest() function, the server or the client? Bye and thanks for your help. ------=_NextPart_000_0006_01C4DEA8.158D72C0 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IjkKAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANQHDAAKAAsABAAAAAUABQEB A5AGAJgNAAAoAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB AAAAHAAAAHBnY3J5cHRvIG1vZHVsZSBmb3IgV0lORE9XUwACAXEAAQAAABYAAAABxN6fryVCsEzp EVFNLIJXMmDpumyiAAACAR0MAQAAABcAAABTTVRQOk1KT1NFQFBJWEVMQVJULkVTAAALAAEOAAAA AEAABg4AKMWRn97EAQIBCg4BAAAAGAAAAAAAAAB0JNvz25UVSb9M3xVmpq9owoAAAAMAFA4AAAAA CwAfDgEAAAACAQkQAQAAAKYJAACiCQAAlBoAAExaRnXpFd6XAwAKAHJjcGcxMjUaMgxgYwBQAQRz dHPiaAVwYmNoDvUJAA+HZmgN4A+WYmkBQwtgbjBnMzA4DlARtWZlfxIiAfcCpANjAgAPgArAc0Rl dALRcHJxEzEqyQqhbm8U4CAwAdAB0MQ2MBIgNTA0FrEB0PkSIDR9B20Cgw5QBFUUjeoxFYw3FpE5 FjMXAhbgzxdgCFUHsgKDMzUUHxUvQxY/F0woVzEpAoM5owBQHY0yMzgehCAHbfggQ0UhxBjBIl0g MCNvOSR1eXIhxCaBHZwxNtciISa/A4JHCdFrIcQdb28poBjBKf8DglQIcCHENhksDzc3LT8kdChI ZfpiCXB3IbUwYS9uI18xdr8HEAGgDeAhtTPxKM04LzFrNC8DgkIHQHQN4CHEOVk2bzYzN58xhVYI kHTUbmEHgWUhtDE9gBjf/SM2MSTAHGgkxj2AGM8mV/8/TSgVPYAmgRj9KaY/TCtI/z2AK/FEDy0k P0wupj2ALzH/R04wVT9MMes9gDBhSm8+7/8hUjWKPYAz8UdON3U/TDkJ/z2AOcFHTzr0S908iwKR COaqOwlvMFh/ZQ4wNVmq/1rBWn9biVmUW7JaH13vXa3XXS9bX1mvZQ4gOGN6ZJH/ZE9lWVmUZYJj 72e/Z31m//9lL2j0JUFsRCVBZcMlQAKCqQ8QeWwHkGgJ4HQAAHpxAyFsEYEFEAFAA/Bk2GN0bAqx AGBzCrBw4CMeEHEibnVtAgBhYYh1dG8AYGRqdQ8Q8QUQZ2h0cEEKAXAQCgHyaQGQcDADMR1SC/AO UD8R5xKoCNAJwHCgdPNucId1SXbkAzBzbmV4HmAfB7AFsADAAnMfAGNzMct0QXKgZHQAaXYfcA8A OR5AbWkQwHnQCfAgRKcBEHJQOSAgUArAYQnA8XQgaCBGAiF5BA8gPZE7DyADYHcLMHLwAYBzV/Fw oHRoQjrwcvAKsHnQ7mx5gDPwfnRyfugQAH5WawGAgFdigFdyflEE8GX8bGxwkX4gfcEBQA8geiD/ ACA5EXzRMhB/cIPWCVCD9M8MsYQDcRCD9GRnhNaGUPWF1miD5XYDMG/fcO9x/99zD3QVC/IR4nmA MiaAEqT/jXN2So15jxR4FT2Aekx4pO87YAGgb0B5BzV5qntgCND7GLB4EWKJoAmAAiB5gm8RJx4w iRAvIDU5I0AzIHhIeXAEkHOxK4N5Qzb/kx8OIJQ/lUp8QIKQfWAJgP+WDzBAeaoYsgvxmG16eQ8A PZYhcwIgkfEPAAWgbXDbH1KVDkUPEAMQbwhQhcC8ZW8wQFejHwBYkHYCUdgge1WWcB9AdxhhogSv lVGigqOjlZA3pJA0OcBflUmjo3mAIDCNkDOlpjXWOEPAJUB9ALFyhmAwQL4wAFCncn+Ap9YpkDRN kf2ncmKpAgMwAWV+8YkBfWDHiTCEwQGAbmJqAGAJ8BN50BAgXGiawGhob9x0eqYwK/AfQHgLYAJA 1G95CfBceFBwDzAAIP8LkB9Ae2GEwImwAOECMAJgfQCAYg9grNGJsYJwAhBy25PRsAFtDzCLEGWs EAWwdnqr4oZQaK+zN2ABQWf+drG5sQGLgAuAp8OyQbM1bzZAJoCxgqxgd7IktQNqf62hAHALMKvh byCWIA5QdukIkHdrC4BkK/C28gTw3wdAjhEBQA4Ah1NlixC4Vf8CEKxwrNGvIIugixEJM5VRfwNg rHCkhQMxHlIeQIkwZO+IYnhBu9V7NGMJULvypQo+c6tDorAe8gCABZBsdv9+0L9RDnB4wL9SAZAA IL/i+7dBCfB0AcG/UR4QEgC/EeeKUAzQAZAgLqH0v2YOUP/AAq5hwG/Bf8KPv8A68IpQfwWBxE/F X8Zvv8AmgIpQbPfED8jfyeYpwtwr8Me/zK/9ydViIXACkc3fv5MvMMt//9BP0V/Sb7+xMGDTwsBP 1S//1j/OTTPw08/ZX9pv23+/sf85wNhf3f/fD+AVCvmIL4k1/4qli990f3WPdp93phiUC/L/lADo IQCAlUsYhezPlaSCgfZv7k/taywKhfBv7WsKhf/yX/NjEeIbsTBg6dnq5Paz7+1MCNAeEZVKVx9w CsAfcP0LgHQEkAeQ+uC8MOWR7UH/g6Hn8cmwfiAfcA4ABQCawJ2K4CAEYXtgH3BvZnuQhR9QdAnB U1FMILAB9/pAt0F9YHP1j/af96/xr/wgSeWgBbAZEfxA/QCLQKMfcPxSZnVuiTBpE3DKIHngZ/sR KCn+Y+GQb7jQOTDJoeKCeP2A5aBiPnn64MpAtpL+YDyQbGT8czr0rPUWCvPlv+bP59r/CVIeIZVo /z8ATwFf+M+VhucGEx9wBMBpcVlwBpX/L48O/xAPER+Vd215XwajvxP/FQ8WHxcvlXcG8m0ZT/ca XxtvlWh5Hm8ffyCPHH/1lXdfqjFsIk8jXyRvJX+/75gnbyh/KY8qnx2IKAVFXx5fLU8uXy9vIZlf BzNfPwfjMb8yzzPfNO8CaCAnAm23YCcpKVwnMz5iN184bzl/9A8JNUhPUldPUEFO+kBFA2BO8FNU QUz+UDz/Pg8/H32VaFRC30PvRP+VaUIwUABHQ1JZUFRPICBNT0RVTEIwRk+WUvpAQlBEQbBTP0a/ H0fPSN9AL0wgQhJIQVb5QjBKVUJwkhBLIEJVPCD/S8FMf02PTp+VaFCxUq9Tv4dUz/m5QjBORUVE UaKAUkVDT01QSUuBIlNbUEVUSEJQRz97AwgEc2mlwHuAt+Cf0SjrizL7lik8IHeKAHuAmND/XuCc cIoAeiH88ful+nCrwN9e4frxXz2qwdzgb4sQ+rD+dFavV79Yzx15ghCfkGLf/2PvZP+VaFxdv4F8 ULwwXaT3beCfgqEwZV7GYKK1AV89/2yHYJ9fovUfZ59or2m/Yfz9ZqM/9Jb6UYoAcU9yX3Nv/ZVo dncveD95T++J/mEEwF+8MPxSCmCFEAlwefyHLv+qAGBx5ZGuQP6Q+WG8MJdw/HNrPCBvkrfwnwBc 9ZJQenOACHMKIYISgBcGIWT4bWUucT98D30f+axwn++Fz4bfh++VwnKKH4svjD/f74ligfxahNU8 IGILsF9if/qCqVCqAPpw/RCBwLoQa3+FMImvjp+Pr5C/dmasYCD/vICdcIMg/PGi8vxDBUgExfs8 IGt0cmHA/pD+gfxSvYDvtwDkcFxWCTVCrWBvg/xQbbYga4Mg/nJ5gSMIAHD/lOagf5Uvlj+XTzpP +YsJP/8KTwtf6BeiT6NfpG+lf6aPP6efqK8L7wz/82+vWX0AAbYwAAADAN4/r28AAAMAAlkAABYA AwAJWQMAAAADAEBlAAAAAAsAAIAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwACgAggBgAA AAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAAWACCAGAAAAAADAAAAAAAAARgAAAABShQAACJkBAB4A JYAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABQAAADEwLjAAAAAAAwAmgAggBgAAAAAAwAAA AAAAAEYAAAAAAYUAAAAAAABAACiACCAGAAAAAADAAAAAAAAARgAAAABghQAAAKRqnff//x8LAC+A CCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAMoAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAA AAAACwDVgAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAALANmACCAGAAAAAADAAAAAAAAARgAA AACChQAAAQAAAAIB+A8BAAAAEAAAAHQk2/PblRVJv0zfFWamr2gCAfoPAQAAABAAAAB0JNvz25UV Sb9M3xVmpq9oAgH7DwEAAABKAAAAAAAAADihuxAF5RAaobsIACsqVsIAAG1zcHN0LmRsbAAAAAAA TklUQfm/uAEAqgA32W4AAABDOlxXSU5OVFxvdXRsb29rLnBzdAAAAAMA/g8FAAAAAwANNP03AgAC ARQ0AQAAABAAAABOSVRB+b+4AQCqADfZbgAAAgF/AAEAAAAxAAAAMDAwMDAwMDA3NDI0REJGM0RC OTUxNTQ5QkY0Q0RGMTU2NkE2QUY2ODQ0RkEyNDAwAAAAAAMABhBRdSkaAwAHEKkCAAADABAQAAAA AAMAERABAAAAHgAIEAEAAABlAAAASEVMTE8sV0VBUkVJTlRFUkVTVEVESU5JTlNUQUxMSU5HVEhF UEdDUllQVE9NT0RVTEVPRlBPU1RHUkVTUUxGT1JXSU5ET1dTLElOT1JERVJUT1VTRVRIRUZVTkNU SU9ORElHRQAAAADxwg== ------=_NextPart_000_0006_01C4DEA8.158D72C0--