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
FAQ