Re: 7.3 RMPS bugs ( pgdb.py and postgresql launch script )

[Removing cross post to pgsql-admin@postgresql.org]

* Gaetano Mendola <mendola@bigfoot.com> [2002-12-08 17:45 +0100]:
> 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

Yeah, looks familiar.

> 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 ).

As this value cannot be determined anymore, it's IMO better to set it to
-1 instead. This is what I've done in our alternative PostgreSQL
interface, pyPgSQL (http://pypgsql.sf.net/) and what I've also suggested
to D'Arcy. If I interpreted D'Arcy's response correctly, he's already
fixed this bug in PostgreSQL CVS.

Cheers,

-- Gerhard