Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aKrGo-0003Gn-Nv for pgsql-sql@arkaria.postgresql.org; Sun, 17 Jan 2016 17:37:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aKrGn-0002um-JQ for pgsql-sql@arkaria.postgresql.org; Sun, 17 Jan 2016 17:37:41 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aKrGn-0002ug-4F for pgsql-sql@postgresql.org; Sun, 17 Jan 2016 17:37:41 +0000 Received: from nm21.bullet.mail.bf1.yahoo.com ([98.139.212.180]) by makus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aKrGj-0003UW-EN for pgsql-sql@postgresql.org; Sun, 17 Jan 2016 17:37:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s2048; t=1453052255; bh=CuyakrnSA802iHu+Sa56av/TsTdj/f9KcveaDqbLYPU=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=Lbvelvcw/xz9rzDgjfKvOXf208NjC5ZR8F92FMAhc0UuJ7/uo63acZiH2LJ89Ludg6mweYb9bKMHsHGP6prj98jpDHhZ1oiWAAXKzHvqlCI/MLDs1q16DkQNxRTG3Oi2aB1kTPX0LzqNWf1+DoKEfGrw1Vz+OeObXC3TgnnMdqkWfDauB7nDktSQOWamlz6bOZBINfNktPj0Lc1e0Oql4Bhb5c+Q2AeELIpHVWusZmxM80qgpGkFixxV9CiLXlLRro3FLyzN9sSK52KlLLGtA26eombDF3pWLNJGVKtmnyTm3g6pxAgj+8rwPG0+O/3Y/+uZzmQTS9eEJbl7siRICw== Received: from [98.139.214.32] by nm21.bullet.mail.bf1.yahoo.com with NNFMP; 17 Jan 2016 17:37:35 -0000 Received: from [98.139.212.194] by tm15.bullet.mail.bf1.yahoo.com with NNFMP; 17 Jan 2016 17:37:35 -0000 Received: from [127.0.0.1] by omp1003.mail.bf1.yahoo.com with NNFMP; 17 Jan 2016 17:37:35 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 799637.36933.bm@omp1003.mail.bf1.yahoo.com X-YMail-OSG: nWox0y0VM1l.sz0llgaTzz8PG2ua7tbRKUE8eYKd0ibvzlAykKRXLPsYzJzbmDu XYCtkKmOTVawohT3ShRJlIS._Nhpm_kZMPpKRSqkeypu.4YVD8gukVUnRoPuxtsZrzet6ghYEz8P l71VTzXeqZzVoxIxCDViBv81Hj5QEUinoyu28PMzSWBj_RInnsJpWj7Y_ho0rPRj5RAgDFBDeABj UEKFtxz_3xV4P4IEUmACVXSrOz8g1oTkjBn9aQAr2AHqhlIIp_89yppqQ_ImqHeYpOVZb5pi_aDr N9ACa.uqESbDHnLbTUVYjPMy1eGJhKkjN3S8_nsrYjN00aTHDSnZg5GpIrDOA_FtVs_6nmHXcMMw pih0if7vEG8EGALVu5xjAlfcxWH4B1707o0sW2_ujgJNL8lUqRiCtoyXIa1vXSz8FmZIgCDTgmOw Vw7DIiAl2qkdd3TiGoWCN6W.MuMG2Ta.1eJRyEUkclQwPWMZvN159ZgcjSAo4yOy_aFz63lf2V3u zyOj7Eq49MDdWSY9GwOqEu6mrRU2JtEOZeo5Nk0soHaAuXGoDmcYhUs1UX2Trn5sg0JAvRg-- Received: by 66.196.81.106; Sun, 17 Jan 2016 17:37:35 +0000 Date: Sun, 17 Jan 2016 17:37:34 +0000 (UTC) From: Eugene Yin Reply-To: Eugene Yin To: Andreas Joseph Krogh Cc: "pgsql-sql@postgresql.org" Message-ID: <987760761.1103405.1453052254731.JavaMail.yahoo@mail.yahoo.com> In-Reply-To: References: Subject: Re: BYTEA vs BLOB MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_1103404_781449054.1453052254730" Content-Length: 8888 X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org ------=_Part_1103404_781449054.1453052254730 Content-Type: multipart/alternative; boundary="----=_Part_1103403_1666170497.1453052254725" ------=_Part_1103403_1666170497.1453052254725 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable What does=C2=A0131072 mean? =C2=A0Why not use a bigger or smaller number? = =C2=A0 =C2=A0=C2=A0=20 On Sunday, January 17, 2016 9:02 AM, Andreas Joseph Krogh wrote: =20 P=C3=A5 s=C3=B8ndag 17. januar 2016 kl. 17:56:33, skrev Eugene Yin : lfd :=3D lo_open(loid,131072);=C2=A0Why use the file size 131072, instead o= f other number?Are there other options? I mean, under what circumstance, u= se 131072, or use other size?=C2=A0Thanks=C2=A0Eugene =C2=A0No particular reason.=C2=A0--Andreas Joseph KroghCTO / Partner - Vise= na ASMobile: +47 909 56 963andreas@visena.comwww.visena.com=C2=A0 =20=20= ------=_Part_1103403_1666170497.1453052254725 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
What does 131072 mean?  Why not use= a bigger or smaller number?     


On = Sunday, January 17, 2016 9:02 AM, Andreas Joseph Krogh <andreas@visena.c= om> wrote:


P=C3=A5 s=C3=B8ndag 17. januar 2016 kl. 17= :56:33, skrev Eugene Yin <eugeneymail@ymail.com>:
lfd =
:=3D lo_open(loid,131072);
 
Why use the file size 131072, instead of other number?
Are there other optio=
ns?  I mean, under what circumstance, use 131072, or use other size?
 
 
Eugene
 
No particular reason.
 
--
Andr= eas Joseph Krogh
CTO / Partne= r - Visena AS
Mobile: +47 = 909 56 963
3D""
 


= ------=_Part_1103403_1666170497.1453052254725-- ------=_Part_1103404_781449054.1453052254730 Content-Type: image/png Content-Transfer-Encoding: base64 Content-Disposition: inline Content-ID: iVBORw0KGgoAAAANSUhEUgAAAIUAAAAYCAYAAADUIj6hAAAABHNCSVQICAgI fAhkiAAABzBJREFUaEPtmNFxHDcMhmVP3i1VECpvnjzkVIHWFfhcgVcVRKrA UgWRK/C6Al8H3lTgy0PGbzFdQc4VJP/HADs43q6kROeJNbOYgQACIAgCWJKn g4MZ5gxUGXh0U0b+SIuF9G+EWXj2Q15vbrE/NPtk9uub7Gfdt5mBx1NhqSEo 8HshjbEUtlO2yIM9tsx5dZP9rPt2MzDZFAqZE4LGcFjdsg3saQaHt7fY70X9 49OnaS+OZidDBkavD33157L4xaw2os+Mp/DAC10l2XhOCeStj0W5ajrJL8Wf Ci80Xgf9vVlrhg9yRONe/f7xI2vNsIcM7JwU9o6oGyJrLT8JOA1aX9sKP4wl 94bAniukEbo/n7YPmuTETzIab4Y9ZWCrKexd8M58lxPCvvD6aihfvexbEQoP YO8NQRO0JnddGO6FJYaVsBde7cXj7KRk4LsqDxQzCYeGsJNgaXZe+JXkyGgW INq3Gp+bHNILz+wEYs5qH1eJrouNrpDXtk4O6x1IvtD40GWyJYYdkF0jIbYZ lN16xygIgl9smbMDsmFdfAKb23xGB8H/mv3tOJfArs1kukk79DEPdQ5u0g1v CvvqKXIW8mZYW+F3Tg4r8HvZkQCCLydK8EFMQCe5N8RgL9mRG0SqQFuNvdE6 beSs0qPDBuCdg0+gvClso8SbTO4ki7mQzQqBrcMHQPwReg2wW8umEe/+L8T/ LEzBGF9nXjzZ46s+ITHvhegW8LL39xm6App7KYL/GE+vcYnFbJiP/0aYhdiC nRC7jaj7eiK2ETInC5PRF6LYkSN0+HabF75WuT6syCyI0YkVGGMvUC33AmfZ TDUEj8u6IVhuEhRUJ2U2g6UlugyNb03Hl9obHwlxJbcRzcYjO4QPjVfGFTQa v4vrmp7cpMp2qbHnBxWJbisbho2QXI6C1sIHDUFhH4Hij4UbIev66eANeiwb kA+LBsO36zAHzoXU7AhbqLAXEiOYTXcSdO8VS9L4wN8UBIYhBd6oSUgYMijO kecRuTdQa/YiBXhbXFcnCnI2SrfeBG9NydrLYMhGHa5qB9pQIxlzAE6Okjzx JO5afGe6kmhBicWKQNKuTZ5EW+MjQY8v/9rQ0bhJSJyNGUe/JH1t8h1iMbdS PAvxHYin6YmN9YBXQmTYZZNh14vHhhhal5vtcIrJjmvszPRJdExH3MWHvyko BEc9CoCGWJisOLOGoCORs1FvIMbYA8z3kwM59oemy6LlWrLxFLmWgiQAfEGd 8S+NssbK+EhyGLxUkhhiy717waBqHOJYSEacwBejkFNhjJNjv/gANOdQxPfc iP/JVBCK2cOIcg3RRJ+CPrLPNVhhN6F38VKMF3XLlIJrjU5C8gMFxvKDvOcP c4rVNjCn7KM0BV+161V8viSCuJZ8SITGJGEh7IUUlxOFMYUH1kJOCN4Wh+I5 pqCuK01k40kSNtnKiKIlUfxAgW5sU5JlS05rtt5YFJF1SWoqHv6BRgQcA4/b db9WRjmMk3jyUMAbIoyJq9e4cVmgzKt9j5gNJ/aYDhk+hhjExwaPcz5PObA5 Zd9bvz5UzCTZuZDidu5AchpiKSwPR+TV1bCWqBQ9nCjJ5neivC82Nr4LeS2j 1gw5LUqwBuhGQQU5UwHeSslXkwIynz2U2A2yKDgG7OffwLA3TpGRpk0Tzpj3 ZEJXi/GRa6GN0e0NtppChePdcAz1FTS+FN8Kpxoiykk+J8fC5tenjbu9kSqp HLu9jBrhUuhNwVGbpyZrzrl0HPVD8SXj5EOOD/eDC64VjvYBZLuUbIVAfBN1 t/C/SU+cAGtdGo+fVnzycUX5wmn6eCKPmWYJG2E/ppTsuRCbvUD9fwquksG5 GqLVKhzDQ3GrEyLKSXhsiK3T5j9EyxffCFOYi2wUlPyFFDQAhehESDjQGoX0 ho0oj8RPou6TxHJdcT0NTcWkO0AnG7+uXsnHqcas/72wvWF+mSf7N/Watp9k TXoluzeS0fB99CcZ/hvhSZTfh99pispZOXL9KrGrARkNUMu9ITbScZWs7xOY Nt9pwxSZtYDsX/GE3xTkrXgwAsXmfud08FiTeC+m2/o7ppo+PTS/NBK5ARpD G5YHr++DpmVfreYdiX8mnp+DzPEG9WbqJON0JBenZofssxBA1gj5NXGvfJu/ Qh7HwQh/VDUEyUxCit5hH94QfKkEdu+GwK8BX0hvCF+D67xhjmXQCXMwJCZ+ olK0A1EKRCE4snsh42w8Mv/Zhxw9iD7Cjo7CyQC/KyF6oBfShL4PYgG+CHsY KyZxvxZSZBAgjhIzYDz+AbfD37GtbaoSKzgGt+lKfI/GZtay6vG4VXTpPsh+ IcQhOk9I7WYeP5AM3HZ9+DaSGIp9HIuuhuC4pCGGx+YD2fcc5tfIAA0h/Et4 /jX8zz4fWAasIf4UbR9Y6HO4d8jAnd4U0Y8ageuCB+c+H5R3CHU2mTMwZ+B/ y8DfSMBLLOYXVuEAAAAASUVORK5CYII= ------=_Part_1103404_781449054.1453052254730 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql ------=_Part_1103404_781449054.1453052254730--