Skip site navigation (1) Skip section navigation (2)

Re: Deleting records with text fields

From: Barry Lind <barry(at)xythos(dot)com>
To: Kovács Péter <peter(dot)kovacs(at)sysdata(dot)siemens(dot)hu>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Deleting records with text fields
Date: 2001-11-07 18:36:29
Message-ID: 3BE97F2D.9060603@xythos.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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)
> 
> 



In response to

pgsql-jdbc by date

Next:From: Barry LindDate: 2001-11-07 18:39:39
Subject: Re: Memory exeception
Previous:From: Jeremy WohlDate: 2001-11-07 18:28:59
Subject: Re: MD5-based passwords

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group