Blob question -(((

Hello ,

I have a question about BLOBs in PGSQL. I know some people getting
crazy about this question, but I need an answer to finish the
portability to Postgres for my content-system.

Here are my questions:

* Are they any limits to the OID Datatype? I need 50-100k per row.

* Can I do fulltext-search with OID fields (VERY IMPORTANT QUESTION!!!!)?

* How can I store 50-100k values? What datatype should I use?

The answer of this  questions is very important to me, hope someone
has time to give me an answer.





Now something for the archive:

Yes I did my homework and I was searching around for some stuff about
pg and blobs. Just for the archive, I will repeat some of them here.

SELECT lo_export(image.raster, "/tmp/myfile" from image
        WHERE name = 'somename';
(from
http://postgresql.adetti.iscte.pt/mhonarc/pgsql-sql/1999-03/msg00026.html )

and this:
create table images (imgname name,imgoid oid);
insert into images values (`test.gif`,lo_import(`/home/pmount/test.gif`));

from
http://postgresql.adetti.iscte.pt/mhonarc/pgsql-sql/1999-03/msg00026.html

--
Boris
http://www.x-itec.de