Large Objects and Toast

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



PostgreSQL: 8.2

 

My understanding is that when one creates a large object there is no way to link the large object to a field in a table so that cascading delete can occur.  Is this correct?  My understanding is that you have to manually delete the large object.

 

I also read something about the OID ID being limited in size.  What is the size limit of this OID type?  I am sure that it is bigger than the number of files that I would be uploaded into my db; but I just want to get an idea of the range.

 

When putting a reference to a large object in a table, should the type of the reference object be OID?

 

Thanks,

 

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

 


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux