python and sqlite3 packages

[Brook Milligan <brook%nmsu.edu@localhost>]

I am trying to use sqlite3 from within python.  It turns out that the system-supplied version of sqlite3 is too old to support certain features, so I installed both the pkgsrc version of sqlite3 and the py-sqlite3 package.  My path also includes /usr/pkg/bin prior to /usr/bin so the pkgsrc version is picked up when sqlite3 is run from the command line.  However, python loads the system-supplied version instead.

How can python be made to load the pkgsrc version of sqlite3 in preference to the system-supplied version?

Thanks for your help.

Cheers,
Brook