Re: Deleting records with text fields

Peter,

LargeObjects are s special feature of PostgreSQL, the behavior of
LargeObjects if very different from that of the regular datatypes. A
column of type 'text' will work as one would expect. There is a
difference between LargeObjects (a special datatype) and large objects
(large amounts of data in a particular column).

thanks,
--Barry

Kovács Péter wrote:

> Hi,
>
> I read in this new group a short thread about deleting large objects through
> jdbc. From this thread I learned that if I delete a record with a large
> object field in it (I am using here a simplified formulation), the large
> object will not be deleted automatically with the record, but has to be
> deleted in a seperate operation.
>
> Instinctively, I would think that this kind of design was applied to the
> "text" type, since it also can accomodate data of practically (from my
> perspective) unlimited size. So should I do some extra work, when I want to
> get rid of a record containing a text field, or will deleting only the
> record also delete the text object represented by the text field in the
> record? Is the design for the "text" type different from large objects?
>
> Thank you
>
> Peter
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>