* allow configuration of maximum number of open files

* Remove pg_listener index

* Remove ANALYZE from VACUUM so it can be run separately without locks

* Gather more accurate statistics using indexes

* Gather more accuratedisbursionstatistics using indexes

* Improve statistics storage in pg_class [performance]

* Improve VACUUM speed with indexes [vacuum]

* -BSD/OS does not support locale because there is no LC_MESSAGES (Bruce)

Announce: Release of PyGreSQL version2.4

Announce: Release of PyGreSQL version3.0

===============================================

PyGreSQLv2.4 has been released.

PyGreSQLv3.0 has been released.

It is available at: ftp://ftp.druid.net/pub/distrib/PyGreSQL.tgz. If

you are on NetBSD, look in the packages directory under databases. If

it isn't there yet, it should be there shortly. You can also pick up the

package files from ftp://ftp.druid.net/pub/distrib/pygresql.pkg.tgz.

There is also a package in the FreeBSD ports collection but as I write

this it is at version 2.1. I will try to get that updated as well.

you are running NetBSD, look in the packages directory under databases.

There is also a package in the FreeBSD ports collection.

PostgreSQL is a database system derived from Postgres4.2. It conforms

to (most of) ANSI SQL and offers many interesting capabilities (C

embeds the PostgreSQL query library to allow easy use of the powerful

PostgreSQL features from a Python script.

I wanted to haveDB-SIG API support in the next release but there are

on that.The next version will be 3.0 and have the DB-SIG API support.

there were enough fixes that I didn't want to keep them from a release.

This release of PyGreSQL is the firstDB-SIG API. That's why we have

backwards compatibility.Previously when there was a NULL in a returned

problems with this.

PyGreSQL 2.3 was developed and tested on a NetBSD 1.3_BETA system. It

Due to the fact that the DB-API is brand new, it is expected that there

will be a 3.1 release shortly with corrections once many people have

had a chance to test it.

See the other changes below or in the Changelog file.

PyGreSQL 2.0 was developed and tested on a NetBSD 1.3_BETA system. It

is based on the PyGres95 code written by Pascal Andre,

andre@chimay.via.ecp.fr. I changed the version to 2.0 and updated the

code for Python 1.5 and PostgreSQL 6.2.1. While I was at it I upgraded

the code to use full ANSI style prototypes and changed the order of

arguments to connect. Later versions are fixes and enhancements to that.

The latest version of PyGreSQL works with Python 1.5.2 and PostgreSQL 6.5.

Important changes from PyGreSQL 2.4 to PyGreSQL 3.0:

- Remove strlen() call from pglarge_write() and get size from object.

(Richard@Bouska.cz)

- Add a little more error checking to the quote function in the wrapper

- Add extra checking in _quote function

- Wrap query in pg.py for debugging

- Add DB-API 2.0 support to pgmodule.c (andre@via.ecp.fr)

- Add DB-API 2.0 wrapper pgdb.py (andre@via.ecp.fr)

- Correct keyword clash (temp) in tutorial

- Clean up layout of tutorial

- Return NULL values as None (rlawrence@lastfoot.com) (WARNING: This

will cause backwards compatibility issues.)

- Change None to NULL in insert and update

- Change hash-bang lines to use /usr/bin/env

- Clearing date should be blank (NULL) not TODAY

- Quote backslashes in strings in _quote (brian@CSUA.Berkeley.EDU)

- Expanded and clarified build instructions (tbryan@starship.python.net)

- Make code thread safe (Jerome.Alet@unice.fr)

- Add README.distutils (mwa@gate.net & jeremy@cnri.reston.va.us)

- Many fixes and increased DB-API compliance by chifungfan@yahoo.com,

tony@printra.net, jeremy@alum.mit.edu and others to get the final

version ready to release.

Important changes from PyGreSQL 2.3 to PyGreSQL 2.4:

- Insert returns None if the user doesn't have select permissions

on the table. It can (and does) happen that one has insert but

not select permissions on a table.

- Added ntuples() method to query object (brit@druid.net)

- Corrected a bug related to getresult() and the money type

- Corrected abut related to negative money amounts

- Corrected abug related to negative money amounts

- Allow update based on primary key if munged oid not available and

table has a primary key

- Add many __doc__ strings. (andre@via.ecp.fr)

- Get method works with views if key specified

Important changes from PyGreSQL 2.2 to PyGreSQL 2.3:

- connect.host returns "localhost" when connected to Unix socket

Further copyright 1997, 1998 and 1999 by D'Arcy J.M. Cain (darcy@druid.net)

See file README for copyright information.

Version 3.0

- Remove strlen() call from pglarge_write() and get size from object.

(Richard@Bouska.cz)

- Add a little more error checking to the quote function in the wrapper

- Add extra checking in _quote function

- Wrap query in pg.py for debugging

- Add DB-API 2.0 support to pgmodule.c (andre@via.ecp.fr)

- Add DB-API 2.0 wrapper pgdb.py (andre@via.ecp.fr)

- Correct keyword clash (temp) in tutorial

- Clean up layout of tutorial

- Return NULL values as None (rlawrence@lastfoot.com)

- Change None to NULL in insert and update

- Change hash-bang lines to use /usr/bin/env

- Clearing date should be blank (NULL) not TODAY

- Quote backslashes in strings in _quote (brian@CSUA.Berkeley.EDU)

- Expanded and clarified build instructions (tbryan@starship.python.net)

- Make code thread safe (Jerome.Alet@unice.fr)

- Add README.distutils (mwa@gate.net & jeremy@cnri.reston.va.us)

- Many fixes and increased DB-API compliance by chifungfan@yahoo.com,

tony@printra.net, jeremy@alum.mit.edu and others to get the final

version ready to release.

Version 2.4

- Insert returns None if the user doesn't have select permissions

on the table. It can (and does) happen that one has insert but

not select permissions on a table.

- Added ntuples() method to query object (brit@druid.net)

- Corrected a bug related to getresult() and the money type

- Corrected abut related to negative money amounts

- Corrected abug related to negative money amounts

- Allow update based on primary key if munged oid not available and

table has a primary key

- Add many __doc__ strings. (andre@via.ecp.fr)

- Get method works with views if key specified

Version 2.3

- connect.host returns "localhost" when connected to Unix socket

%define version 3.0

%define release pre20000310

%define name PyGreSQL

%define pythonversion 1.5

Source: %{name}-%{version}-%{release}.tgz

Summary: A Python interface for PostgreSQL database.

Name: %{name}

Version: %{version}

Release: %{release}

#Patch:

Group: Applications/Databases

BuildRoot: /tmp/rpmbuild_%{name}

Copyright: GPL-like

Requires: python>= %{pythonversion}, postgresql

Packager: Hartmut Goebel<hartmut@goebel.noris.de>

Vendor: D'Arcy J.M. Cain<darcy@druid.net>

URL: http://www.druid.net/pygresql/

#* Tue Oct 06 1998 Fabio Coatti <cova@felix.unife.it>

#- fixed installation directory files list

%description

PyGreSQL is a python module that interfaces to a PostgreSQL database. It

embeds the PostgreSQL query library to allow easy use of the powerful

PostgreSQL features from a Python script.

Version 3.0 includes DB-API 2.0 support.

%prep

rm -rf $RPM_BUILD_ROOT

%setup -n %{name}-%{version}-%{release}

#%patch

%build

mkdir -p $RPM_BUILD_ROOT/usr/lib/python%{pythonversion}/lib-dynload

cc -fpic -shared -o $RPM_BUILD_ROOT/usr/lib/python%{pythonversion}/lib-dynload/_pg.so -I/usr/include/pgsql/ -I/usr/include/python1.5 pgmodule.c -lpq

## import fails, since _pg is not yet installed

python -c 'import pg' || true

python -c 'import pgdb' || true

%install

cp *.py *.pyc $RPM_BUILD_ROOT/usr/lib/python%{pythonversion}/

cd $RPM_BUILD_ROOT

find . -type f | sed 's,^\.,\%attr(-\,root\,root) ,' > $RPM_BUILD_DIR/file.list.%{name}

find . -type l | sed 's,^\.,\%attr(-\,root\,root) ,' >> $RPM_BUILD_DIR/file.list.%{name}

%files -f ../file.list.%{name}

%doc %attr(-,root,root) Announce ChangeLog README tutorial

%clean

rm -rf $RPM_BUILD_ROOT

cd $RPM_BUILD_DIR

rm -rf %{name}-%{version}-%{release} file.list.%{name}