Received: from icebox.venux.net (icebox.venux.net [216.120.166.10]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eASJnRt69982 for ; Tue, 28 Nov 2000 14:49:31 -0500 (EST) (envelope-from mitch@venux.net) Received: from windows (cx853045-b.phnx1.az.home.com [24.177.75.28]) by icebox.venux.net (Postfix) with SMTP id 64C5C26202; Tue, 28 Nov 2000 15:01:47 -0500 (EST) Message-ID: <014101c0597d$6d38ffd0$0200000a@windows> From: "Mitch Vincent" To: Cc: References: <3A23B26E.9056.2942B3@localhost> <20001128132923.B30495@bang.dhs.org> <011201c05976$c76df8e0$0200000a@windows> <20001128143410.A30737@bang.dhs.org> Subject: Re: Question re large objects Date: Tue, 28 Nov 2000 12:54:39 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200011/30 X-Sequence-Number: 38 > BLOBs are not dumped from pgsql. OK, that makes sense -- I do a file system backup though, in addition to pg_dump.. > This might be because there's no valid SQL to create BLOBs, and since > pgsql dumps are supposed to be SQL, it just doesn't work. > I don't think you understand large objects. When you create one, you > get an OID. When you want to retrieve it, you hand it the OID. > End of story. And, again, they are dumped by pg_dump. You're right, I didn't understand large objects (never had any reason to use them), I thought PG implemented BLOBs as a data type like *gulp* MySQL *gulp*. I shouldn't have opened my mouth until I educated myself on them... It seems that large objects are quite useless if you can't dump the data (since as you point out, it's not SQL) though I guess a filesystem backup would still work.. They sound like a disaster waiting to happen, glad I haven't needed them... An additional note (now that I read about Large Objects) it seems they're broken up into different tuples so I guess they're total size isn't limited by the BLCKSZ eh'? Oh well, I still like flat-file storage for Christopher's project, even more so now... Thanks for pointing out my ignorance on this subject, I learned something. -Mitch