7.3 RMPS bugs ( pgdb.py and postgresql launch script )
7.3 RMPS bugs ( pgdb.py and postgresql launch script )
От:
"Gaetano Mendola" <mendola@bigfoot.com>
Дата:
Hi all,
the file pgdb.py distribuited with Postgresql 7.3 RPM ( RedHat 8.0)
is affectd by an error that not permit anymore to use the
pgdb interface for python.
In that file there is present the following query:
SELECT typname, typprtlen, typlen
FROM pg_type WHERE oid = %s" % oid
the column typptrlen do not exist anymore in the table pg_type!!!
So I replace the column with 4 but I don't know if is a good
fix ( BTW my regression tests now are working correctly ).
There is also in the script for launch postgres a couple of errors:
1) the wrong check for the version ( already known )
2) when postgres is launched the script do:
echo " [ OK ] "
or
echo " [ FAIL ] "
but should be more correctly:
echo_success
or
echo_failure
I attach both patch ( I added also the stop_immediate )
Regards
Gaetano Mendola
begin 666 pgdb.py.patch
M+2TM('!G9&(N<'D),C P,BTQ,BTP-R P,3HR-#HQ.2XP,# P,# P,# @+3 Q
M,# **RLK('!G9&(N<'DN=W)O;F<),C P,BTQ,BTP-R P,3HR,CHR,"XP,# P
M,# P,# @+3 Q,# *0$ @+3$T-RPW("LQ-#7!E7V-A8VAE6V]I9%T*( D)97AC97!T.@H@"0D)&5C=71E* HM"0D)"2)314Q%0U0@='EP;F%M92P@-"P@='EP;&5N
M("(**PD)"0DB4T5,14-4('1Y<&YA;64L('1Y<'!R=&QE;BP@='EP;&5N("(*
M( D)"0DB1E)/32!P9U]T>7!E(%=(15)%(&]I9" ]("5S(B E(&]I9 H@"0D)
F*0H@"0D)&ES=&EN9R!01T1!5$$A($EN:71D
M8B!I="X*0$ @+3$T."PX("LQ-30L."! 0 H@( EF:0H@"B )(R!#:&5C:R!F
M;W(@<&]S=&UA7,O)'M.04U%?0H@?0H@"BUS=&]P7VEM;65D:6%T92@I>PHM
M"65C:&\@+6X@)")3=&]P<&EN9R D>TY!345]('-EPH@(" @('-T;W *(" @("!S=&%R= I 0" M,C,X+#D@*S(R.2PV($! "B @
M('-T;W I"B )Re: [BUGS] 7.3 RMPS bugs ( pgdb.py and postgresql launch script )
От:
Lamar Owen <lamar.owen@wgcr.org>
Дата:
On Sunday 08 December 2002 11:45, Gaetano Mendola wrote: > the file pgdb.py distribuited with Postgresql 7.3 RPM ( RedHat 8.0) > is affectd by an error that not permit anymore to use the > pgdb interface for python. Then the official 7.3 tarball is also buggy. > There is also in the script for launch postgres a couple of errors: > 1) the wrong check for the version ( already known ) And fixed. > 2) when postgres is launched the script do: > echo " [ OK ] " > but should be more correctly: > echo_success Hmmm. I thought that used to work right.... let me check. > I attach both patch ( I added also the stop_immediate ) Many thanks. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
Re: [BUGS] 7.3 RMPS bugs ( pgdb.py and postgresql launch script
От:
Jean-Luc Lachance <jllachan@nsd.ca>
Дата:
Lamar Owen wrote: >[...] > > 2) when postgres is launched the script do: > > echo " [ OK ] " > > but should be more correctly: > > echo_success > > Hmmm. I thought that used to work right.... let me check. It will work the same (if the format did not change), but I can modify the echo_* script to email me so I know when a service has been started, stoped or failed to start. JLL