Suppose that I have created a LOB, written a bunch of data to it, and
Is it now possible to rewrite the LOB to contain a lesser amount of data?
In other words can I do the equivalent of UNIX open(..., O_WRONLY | O_TRUNC)
or ftruncate(...) on a LOB?
Or am I forced to delete the existing LOB and create a new one if I want
to shrink the size of the stored data?
pgsql-interfaces by date
|Next:||From: Peter Mount||Date: 2000-06-06 07:20:46|
|Subject: RE: Long atributes|
|Previous:||From: Tom Lane||Date: 2000-06-06 00:17:06|
|Subject: CVS location (was Re: Postgres 7.0 JDBC - update count for DELETE is always 1)|
pgsql-sql by date
|Next:||From: Christopher Sawtell||Date: 2000-06-06 07:33:43|
|Subject: Re: [SQL] moving DB|
|Previous:||From: Tom Lane||Date: 2000-06-06 00:08:33|
|Subject: Re: Vacuum problem in my system ? |