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@toodarkpark.org> URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."