Re: [GENERAL] BLOB and OID

2005-11-04 Thread vishal saberwal
yes, there is one, but i dont know how would you modify the PostgreSQL code. You can implement a GUID datatype and can use it as indexing which guarantees uniqueness and can be stored in double format. thanks, vishOn 11/4/05, Lolke B. Dijkstra <[EMAIL PROTECTED]> wrote: Hi,OID being a 4 byte int

[GENERAL] BLOB and OID

2005-11-04 Thread Lolke B. Dijkstra
Hi, OID being a 4 byte int seems limited to indexing for binary objects. More precisely I use BLOB to store images in the database and link these objects to another table using the OID as FK. If I run out of OID there will be no way to index new images. Of course when not automatically creatin