Re: [HACKERS] SPI procedure for removing large objects

From: "Sergey E(dot) Levov" <serg(at)gate(dot)informika(dot)ru>
To: Peter T Mount <peter(at)retep(dot)org(dot)uk>
Cc: PostgreSQL Hackers List <hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] SPI procedure for removing large objects
Date: 1998-08-07 07:26:50
Message-ID: VBwmgoru4e@gate.informika.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello Peter,

In message
<Pine(dot)LNX(dot)3(dot)96(dot)980805185640(dot)13326R-100000(at)maidast(dot)retep(dot)org(dot)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(at)informika(dot)ru)

------------------------- cut --------------------------
begin 644 spi.tgz
M'XL(`.BJRC4``^T9:5/CR)6OZE_QAF$*B<$G-J2XLL86K%,>F\(at)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+(at)+'BZ8,+X^&P%D1+PHL,Z36W:*(2K]0*X[\
MH(+ED!`(at)?C1W0L"?A[D9P:,?(at)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`@:[(at)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%)%(at)J//),LSA$!9V48&85,Q[&5Q(at)?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(at)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(at)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(at)\[/)GP*2!,XDCFAJ7*[]HI!$
M)SS4&)$J).V#HV5!3XQ]ETTMJB!.3.-G^39:_O//L!9K.SNW$2WK`IGR;(GF
MC(at)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(at)G?K?"`KKN(at)#
M[==I1HI/_#?C,,4C+9RKFNQOR12B)@H(at)#(dot)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(at)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(dot)T1(dot)P?2(at)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(at)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(at)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(at)*_(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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter T Mount 1998-08-07 09:16:18 Re: [HACKERS] SPI procedure for removing large objects
Previous Message David Gould 1998-08-07 06:06:37 Re: [HACKERS] indexes and floats