From: | William Drury <bild(at)mail(dot)xao(dot)com> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Large Object questions... |
Date: | 1999-07-30 04:42:34 |
Message-ID: | Pine.LNX.3.96.990729214157.7898C-100000@mail.xao.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have never understood why people would store binary data in an SQL
database. Am I missing something?
On Fri, 30 Jul 1999, Howie wrote:
>
> im in the process of converting a client from mysql to postgres. this
> client has been storing images ( jpegs, gifs ) in their mysql database in
> a BLOB field. the image is then shown to their staff via the web. oddly
> enough, no, its not porn.
>
> so, in the process of doing all these massive imports and exports, i think
> i stumbled across a bug ( or what i think is a bug ) in postgres 6.5. as
> i said, there are a bunch of these images imported via lo_import(). when
> doing a 'delete from <table 'holding' the images>', all the rows are
> wiped... but the images imported via lo_import() are still in the
> database's directory ( xinv* ). they're also still in the pg_type table.
>
> shouldnt the oid's ( and their corresponding xinv* files ) have been
> removed when i deleted the rows from the table? how does one remove these
> large objects from both the pg_type table and the disk ( removing the
> xinv* files ) ?
>
> ---
> Howie <caffeine(at)toodarkpark(dot)org> URL: http://www.toodarkpark.org
> "The distance between insanity and genius is measured only by success."
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | John Huttley | 1999-07-30 05:31:46 | Re: [GENERAL] Large Object questions... |
Previous Message | Manuel Lemos | 1999-07-30 02:16:33 | Build without generating shared libraries |