Re: [HACKERS] SPI procedure for removing large objects - Mailing list pgsql-hackers

From Sergey E. Levov
Subject Re: [HACKERS] SPI procedure for removing large objects
Date
Msg-id VBwmgoru4e@gate.informika.ru
Whole thread Raw
In response to Re: [HACKERS] SPI procedure for removing large objects  (Peter T Mount <peter@retep.org.uk>)
Responses Re: [HACKERS] SPI procedure for removing large objects  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Hello Peter,

In message
    <Pine.LNX.3.96.980805185640.13326R-100000@maidast.retep.org.uk>
    Peter T Mount writes:

>On Wed, 5 Aug 1998, Sergey E. Levov wrote:
>>
>> I've written the SPI procedure which allows to delete large
>> objects referenced by currently deleted or updated tuples.
>> I tested it with PostgreSQL v6.3.2 and seem it works.
>> If PostgreSQL developers team is interested in it, I'll send
>> the sources to this mailing list or to somebody personally.

>I'll be interested (I wrote the copy in contrib/lo - post 6.3.2 source
>tree).

Below is an uuencoded .tgz archive with sources.

Best regards,
Sergey Levov (serg@informika.ru)

------------------------- cut --------------------------
begin 644 spi.tgz
M'XL(`.BJRC4``^T9:5/CR)6OZE_QAF$*B<$G-J2XLL86K%,>F\@FNUM)RBM+
M;5M!2!X=,&0W_SVOU=TZ?,`FN[!;-711(+U^]]6O1;AP*ELOO*!1/6HV80O8
MJB[]%2]PV&PVCNJUHT8=WX^.CJI;T'QIQ=B*P\@,`+8"WX^>PGN84^J^AD*O
MNT*,O^N/`WKGW].R]2(R:M7J8:.Q,?Z']8.ZB'^MV:P=`=3J]?KA%E1?1)NE
M]97'O[)'8`]R&0"EDF)3ET847#.84?`G_Z)6!`&=TH!Z%K5A\@@<PP9&O';Y
M`<0+VV0X4;QPZ4;$(44ACZ"7H4?O_7M00P1\XWA3/[AS;LUR$&M(6R'DO>-9
M;FQ3.`TCV_'+\W-%42I[@(@0+@+'BZ8,+X^&P%D1+PHL,Z36W:*(2K]0*X[\
MH(+ED!`@?C1W0L"?A[D9P:,?@T>9,3X\^,$M/#C1'(;7W2(?R[^[,ST[K*#H
MV8P&R"MG*C(M;9<`$4#LAXEE)'I<4)M.`6UH8"R\V<3QS.#Q9'7#FIO!"2'?
M4G,Q8FY5TLBI][YC:R=DX-B*XEIC?%,E!6`@:[@GWQ7<'+N6BKARBY--4C*N
M09Z00SCI)$]*\OIP7\_->\I<%=`H#CQ(MQE,%[YFIF?::^0GPGPTXHYAR2)\
M=,)9(N6,1A((GGE'&0=&8U#7C!S?P\>`NA*?(V+(`KDMT#-M>&K"&?1O>KT3
M3B;5%*JOTOBNG2`MX4]H6A2YW%\E]^A#CAS?!`N!F6!U:&@ERMGX(.U)L!@@
M<!9Y<S`W%)%@J//),LSA$!9V48&85,Q[&5Q@?HYI\/CW6OU/_UQAXF(3&#OV
M"AQK:LRMQC3@&=XV79?W"!DJK`B3_?USDNP)ARFH[]IQ@/TD$@'OF)&I$5DI
MU/5GJFX8`V,?MM,D.<[*Q@PH>'Z$NCB18[K.OZF]K7$=F!+#N1^[-HN)Q=5A
MQ6\,ODMURFLR,KI75[HQONP:>F=\.3#&PU%KI'_2^R-U5<G2>30;TWL$:AI1
M-BEJF=YN!(O`MV@80LH/$L(PKRJS(ERG;K<_U(V1"/0&92]^&'.TYQ1]SK%%
M?3G/O+()`YGY6#`;Q#'W\NQ."&2N;R9(JX&A)S0R0D_*8&V!\(QW-V/*PN>H
MHIP0'>&E\\`>FY$LEW6.[>@]?:3_$L?^E+HWJP<44SM)X=(+:>](=OZ#X0CI
M4RRJJRQ2CW$6,H\X'F8^C2(\]=:XA#4IUN<PRCRP8#L!.]E9SH5L5WA6LIK&
MGL7<AZ>@ES0'AX9EZ..YC`2/^VFD,CS9]M-$EJS6=`/+QP/3]]S'LD`22;Y&
M<=&?LR)0L=$A%(_?L>5['AJA:AJ<0O6)BLPAB]Z.=?;!WMYG;[(>6=VI3A([
M<.#T3"9-Z=S#9`D1^/'C<LRQAJTYM6X38G9@\[/)GP*2!,XDCFAJ7*[]HI!$
M)SS4&)$J).V#HV5!3XQ]ETTMJB!.3.-G^39:_O//L!9K.SNW$2WK`IGR;(GF
MC@J9D>^H0JE[TXVI*A-V'W+ZY11D2PQ?:G)^H&8A9B\Z&7T?>Z[CW:H?'`W=
M+,1H)[+2\T9F6:\5]HJ:LL748^.:%%=+&*:K@)\KL,T,F7CI@G?K?"`KKN@#
M[==I1HI/_#?C,,4C+9RKFNQOR12B)@H@#.L=)R^R=KX3$Y0D03PMV<BHUH]W
M3]))$61Y9%RBDGA+I%P.61X:UQ!SS!SY[WTS^CH6N_]_,F_IU''I2\EXYOY?
M:]1J_/Y?.ZK7:PV$U)JUQMO]_S76>_(>9/R3$RP],M-SO8PH`?T<X[00PE7_
M!H_P6_H.+^37?AC-`CK\:P]"/PYP=!0CA8\E3X9&N],USJ`2AT%EX0=16,$[
MD3G!,RK$]X0T_.Q6V'4Z]UXZ+!^4ZY4PL`B1]^H=E3/3TE0MS[!EFRXJ`1'[
M2A'E)+<'?1SF+ICP';67/&CL8D](^[+7NAI^/$.&_'$\[&E0ZF;\A404/67W
M;D._[/9'X[_IQL5@J&?TI<[2#O5L9TK(J&5<Z:/A6>;%';73&]Y<7G:_UW)?
M6=!.U*:GM_J7W9[.-1*T&B$X.AT?%R".AUF:0/$WTSXU42/OE1T5!_91J\=L
ML5#G5N>37D2J<"!16(39YP38*],OYEUR\63:P%Y.T1.P?2@RW=F9+G%$",/S
MT%>%C6.BW-UB,*"T6%*4?&"2C@'_)-E"E.`.2LCWFQ/X!U':9S\N'NP?D^<0
M9[,2Q5'B>#RX^,MWG?%Q4<9LFV&QYB&PI.X,,;6#H9W"SBF<HPQ"+)>:WC&D
M8E/_H@O\K_6X*7[_Y8'YK64\T_\/JHVF_/Y[=-"L8_\_.*C6W_K_:ZS>H-6!
M75%E629D!;6+5Z..,;B&RYM^>]0=]',G!)M2E_;X8.HO3!R"5W<G3^V*"?.I
MW4FV2]K8TT;Z>K6(8NBC&Z,_!(Y/E-;P:2N)TFOUKVY:5SKL6KM$&CWZX5K/
M?7@MPN176JE*`1G4[!;G133PV(78FT7SL\9^]CGF2V&G5MW/$2WBZ(Q]^'6\
M#.K'D03C8P;'P\J,W>AL=S>#+<P0^^CD,;G%$&V-GN(6\,?5="FO<M<,29O&
MV;$EZ-E0"[SE@*_(G&0RQ>WD%:3R*@"5?<U?%I=>QEY"YF2S3'&+^W525^M5
M,B[(?4)P(EE\71#M8*>FI?)R`G'.V&3HNG"NBV=>F.A;_Z,P&:W-YN5CN6*<
M]?\:5ZB/9TVS?H%IO_<A];9>;!7G/W$G^(UE/#/_0:UYE,Q_!XU&K5IG]_^#
M1O7@;?Y[C25'`O[?CVR((LJ%?CDP=.#_!H&!`3?7'8:*G>84K_$N/2<*8H#>
J:G^;_&^-*/KW>OL&4:Z-05OOW!CZTJSX]E'O;;VM/]3Z+SAEY:H`*```
`
end
size 2157

pgsql-hackers by date:

Previous
From: dg@informix.com (David Gould)
Date:
Subject: Re: [HACKERS] indexes and floats
Next
From: "Justin Hickey"
Date:
Subject: Re: [HACKERS] Re: Default 'now'