I have been thinking about how to implement nested transactions /
savepoints. As you may remember, Vadim wants to add UNDO to WAL and
thus enable this feature.
Some objected because of the added WAL complexity and the problem with
long running transactions requiring lots of WAL segments.
I have
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> Offhand this seems like it would be doable for a column-value that
>> was actually moved out-of-line by TOAST, since the open_toast_object
>> function could see and return the TOAST pointer, and then the read/
>> write operations just hack on rows in pg
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I keep bugging Jan about it, since pre-7.1 and no one has come up with
> > an idea.
>
> Well, if you want an idea:
>
> BEGIN;
>
> SELECT open_toast_object(toastable_column) FROM tab WHERE ...;
>
> -- app checks that it got exact
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I keep bugging Jan about it, since pre-7.1 and no one has come up with
> an idea.
Well, if you want an idea:
BEGIN;
SELECT open_toast_object(toastable_column) FROM tab WHERE ...;
-- app checks that it got exactly one result ba
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I agree we should have it, but I thought the problem was that we
> > couldn't come up with an API that worked.
>
> AFAIR, no one's really tried yet. I do not recall any proposals
> getting shot down ...
I keep bugging Jan about it, since pre-7.1 a
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I agree we should have it, but I thought the problem was that we
> couldn't come up with an API that worked.
AFAIR, no one's really tried yet. I do not recall any proposals
getting shot down ...
regards, tom lane
-
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> By 'in/out interface for TOAST columns' I thought this item dealt with
> >> adding large object like functions to read/write/append to TOAST column
> >> data. I know that has been talked about in the past on hackers. But I
> >> don't see it on
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> By 'in/out interface for TOAST columns' I thought this item dealt with
>> adding large object like functions to read/write/append to TOAST column
>> data. I know that has been talked about in the past on hackers. But I
>> don't see it on the todo l
> OK. Those functions are in the docs. I didn't relate those functions
> and this todo item together.
>
> By 'in/out interface for TOAST columns' I thought this item dealt with
> adding large object like functions to read/write/append to TOAST column
> data. I know that has been talked abou
OK. Those functions are in the docs. I didn't relate those functions
and this todo item together.
By 'in/out interface for TOAST columns' I thought this item dealt with
adding large object like functions to read/write/append to TOAST column
data. I know that has been talked about in the pas
> I was going through the Todo list looking at the items that are planned
> for 7.2 (i.e. those starting with a '-'). I was doing this to see if
> any might impact the jdbc driver. The only one that I thought might
> have an impact on the jdbc code is the item:
>
> * -Make binary/file in/ou
I was going through the Todo list looking at the items that are planned
for 7.2 (i.e. those starting with a '-'). I was doing this to see if
any might impact the jdbc driver. The only one that I thought might
have an impact on the jdbc code is the item:
* -Make binary/file in/out interface
Patch applied. Thanks.
> Tom,
>
> please apply attached patch to current CVS.
>
> 1. Fixed error with empty array ( '{}' ),
>test data changed to include such data
> 2. Test a dimension of an array ( we support only one-dimension)
>
> Regards,
> Oleg
> ___
Patch applied. Thanks.
> This patch is because Hurd does not support NOFILE. It is against current
> cvs.
>
> The Debian bug report says, "The upstream source makes use of NOFILE
> unconditionalized. As the Hurd doesn't have an arbitrary limit on the
> number of open files, this is not defin
Change made.
> Oleg Bartunov <[EMAIL PROTECTED]> writes:
> > please apply attached patch to current CVS.
> > 1. Fixed error with empty array ( '{}' ),
> >test data changed to include such data
> > 2. Test a dimension of an array ( we support only one-dimension)
>
> Looks okay in a quick gla
Hello all,
I've noted that the MOVE command won't send you an error message if
you try to position the cursor AFTER the actual end of the records. Is this
ok ??? I think it should return a proper error code and message, but
instead, it will return only an empty recordset.
The following c
16 matches
Mail list logo
