On Dec 14, 2007 10:11 PM, Campbell, Lance <[EMAIL PROTECTED]> wrote: > 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. >
Yes, but you can setup a trigger to do that for you i think. > > > 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. > Oid is an unsigned integer in postgres IIRC. -- Usama Munir Dar http://linkedin.com/in/usamadar Consultant Architect Cell:+92 321 5020666 Skype: usamadar
