Deleting records with text fields - Mailing list pgsql-jdbc

From Kovács Péter
Subject Deleting records with text fields
Date
Msg-id 8A2DDD7ED7876A4698F6FF204F62CBFC014E5779@budg112a.sysdata.siemens.hu
Whole thread Raw
Responses Re: Deleting records with text fields  (Rene Pijlman <rene@lab.applinet.nl>)
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: "Thomas O'Dowd"
Date:
Subject: Re: MD5-based passwords
Next
From: Antonio Fiol Bonnín
Date:
Subject: Relation modified while in use