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 E3C518B9E95 for ; Fri, 18 Feb 2005 15:57:49 +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 47800-10 for ; Fri, 18 Feb 2005 15:57:41 +0000 (GMT) Received: from COLSWEEPER.cranel.com (newmail.cranel.com [66.192.200.227]) by svr1.postgresql.org (Postfix) with ESMTP id 145A98B9E85 for ; Fri, 18 Feb 2005 15:57:43 +0000 (GMT) Received: from colmail01.cranel.local (colmail01.cranel.local) by COLSWEEPER.cranel.com (Content Technologies SMTPRS 4.3.14) with ESMTP id ; Fri, 18 Feb 2005 10:55:56 -0500 Received: from [192.168.11.134] (192.168.11.134 [192.168.11.134]) by colmail01.cranel.local with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id 18ST11L3; Fri, 18 Feb 2005 10:57:15 -0500 Message-ID: <42160FA7.8030607@cranel.com> Date: Fri, 18 Feb 2005 10:54:15 -0500 From: Greg Spiegelberg Organization: Cranel, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.3) Gecko/20040913 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: OID assistance References: <3482911A44F0C44EABC658E136A2E8073E974A@colmail01.cranel.local> <17940.1108738126@sss.pgh.pa.us> <42160081.5050205@cranel.com> <18094.1108738956@sss.pgh.pa.us> In-Reply-To: <18094.1108738956@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/166 X-Sequence-Number: 16334 Tom Lane wrote: > > Exactly how are you "using OIDs to store files"? Do you mean you're > using large objects? The table is Table "public.imgs" Column | Type | Modifiers ----------+--------+------------------------------------------------------ id | bigint | not null default nextval('public.imgs_id_seq'::text) file | text | contents | oid | Indexes: imgs_pkey primary key btree (id) Data is loaded using INSERT's. insert into imgs values (1,'/path/to/myfile',lo_import('/path/to/myfile')); Greg -- Greg Spiegelberg Product Development Manager Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: gspiegelberg@cranel.com Technology. Integrity. Focus.