| Lists: | pgsql-patches |
|---|
| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | lo_truncate |
| Date: | 2007-02-22 20:50:49 |
| Message-ID: | Pine.BSO.4.64.0702221544580.3311@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
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 | Content-Type | Size |
|---|---|---|
| lo_truncate.patch | text/plain | 20.0 KB |
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Kris Jurka <books(at)ejurka(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: lo_truncate |
| Date: | 2007-03-01 02:10:17 |
| Message-ID: | 200703010210.l212AHe02306@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: lo_truncate |
| Date: | 2007-03-01 04:01:53 |
| Message-ID: | Pine.BSO.4.64.0702282257340.16342@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
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 | Content-Type | Size |
|---|---|---|
| lo_truncate-2.patch | text/plain | 20.0 KB |
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Kris Jurka <books(at)ejurka(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: lo_truncate |
| Date: | 2007-03-01 13:35:21 |
| Message-ID: | 200703011335.l21DZLn18077@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Kris Jurka <books(at)ejurka(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: lo_truncate |
| Date: | 2007-03-03 19:52:48 |
| Message-ID: | 200703031952.l23JqmY10909@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +