SEO

#1 (**permalink**) 04-19-2008, 10:43 AM

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

#2 (**permalink**) 04-19-2008, 10:43 AM

On Dec 14, 2007 10:11 PM, Campbell, Lance <lance@uiuc.edu> 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Large Objects and Toast