Thread: lo_truncate

lo_truncate

From
Kris Jurka
Date:
The attached patch implements lo_truncate for truncating large objects to
a given length.  This is required for implementing Blob.truncate in the
JDBC driver[1] and rounds out filesystem like functionality for large
objects.

Kris Jurka

[1] http://java.sun.com/javase/6/docs/api/java/sql/Blob.html#truncate(long)

Attachment

Re: lo_truncate

From
Bruce Momjian
Date:
Your patch has been added to the PostgreSQL unapplied patches list at:

    http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------


Kris Jurka wrote:
>
> The attached patch implements lo_truncate for truncating large objects to
> a given length.  This is required for implementing Blob.truncate in the
> JDBC driver[1] and rounds out filesystem like functionality for large
> objects.
>
> Kris Jurka
>
> [1] http://java.sun.com/javase/6/docs/api/java/sql/Blob.html#truncate(long)
Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

Re: lo_truncate

From
Kris Jurka
Date:

On Wed, 28 Feb 2007, Bruce Momjian wrote:

>
> Your patch has been added to the PostgreSQL unapplied patches list at:
>
>     http://momjian.postgresql.org/cgi-bin/pgpatches
>
> It will be applied as soon as one of the PostgreSQL committers reviews
> and approves it.
>

Here's a patch that works with the new varlena API.

Kris Jurka

Attachment

Re: lo_truncate

From
Bruce Momjian
Date:
Your patch has been added to the PostgreSQL unapplied patches list at:

    http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------


Kris Jurka wrote:
>
>
> On Wed, 28 Feb 2007, Bruce Momjian wrote:
>
> >
> > Your patch has been added to the PostgreSQL unapplied patches list at:
> >
> >     http://momjian.postgresql.org/cgi-bin/pgpatches
> >
> > It will be applied as soon as one of the PostgreSQL committers reviews
> > and approves it.
> >
>
> Here's a patch that works with the new varlena API.
>
> Kris Jurka
Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

Re: lo_truncate

From
Bruce Momjian
Date:
Patch applied.  Thanks.

---------------------------------------------------------------------------


Kris Jurka wrote:
>
>
> On Wed, 28 Feb 2007, Bruce Momjian wrote:
>
> >
> > Your patch has been added to the PostgreSQL unapplied patches list at:
> >
> >     http://momjian.postgresql.org/cgi-bin/pgpatches
> >
> > It will be applied as soon as one of the PostgreSQL committers reviews
> > and approves it.
> >
>
> Here's a patch that works with the new varlena API.
>
> Kris Jurka
Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +