FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

I am looking for an LTO tape library. Do you have one to spare?
Port details
py-pyPgSQL Python DB-API 2 compliant library for using PostgreSQL databases
2.5.1_4 databases on this many watch lists=11 search for ports that depend on this port
Maintained by: python@FreeBSD.org search for ports maintained by this maintainer
Port Added: 02 Nov 2001 12:00:28
Also Listed In: python
License: not specified in port


pyPgSQL is a package of two modules that provide a Python DB-API 2.0 compliant
interface to PostgreSQL databases. The first module, libpq, exports the
PostgreSQL C API to Python. This module is written in C and can be compiled
into Python or can be dynamically loaded on demand. The second module, PgSQL,
provides the DB-API 2.0 compliant interface and support for various PostgreSQL
data types, such as INT8, NUMERIC, MONEY, BOOL, ARRAYS, etc. This module is
written in Python.

WWW: http://pypgsql.sourceforge.net/
developed by Bill Allie et al
SVNWeb : Main Web Site : Distfiles Availability : PortsMon

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Required To Build:
  1. devel/py-setuptools27
  2. lang/python27
Required To Run:
  1. lang/py-mx-base
  2. devel/py-setuptools27
  3. lang/python27
Required Libraries:
  1. databases/postgresql92-client

This port is required by:

for Run * - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...

To install the port: cd /usr/ports/databases/py-pyPgSQL/ && make install clean
To add the package: pkg install databases/py-pyPgSQL


Configuration Options
===> The following configuration options are available for py27-pyPgSQL-2.5.1_4:
     BYTEA_CONN=on: Apply Bytea connection patch
     DOCS=on: Build and/or install documentation
     EXAMPLES=on: Build and/or install examples
===> Use 'make config' to modify these settings

Master Sites:
  1. http://aarnet.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  2. http://distcache.FreeBSD.org/ports-distfiles/
  3. http://downloads.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  4. http://freefr.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  5. http://garr.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  6. http://heanet.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  7. http://hivelocity.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  8. http://ignum.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  9. http://internode.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  10. http://iweb.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  11. http://jaist.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  12. http://kaz.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  13. http://kent.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  14. http://master.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  15. http://nchc.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  16. http://ncu.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  17. http://netcologne.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  18. http://sunet.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  19. http://superb-dca3.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  20. http://switch.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  21. http://tenet.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  22. http://ufpr.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  23. http://waix.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/

Number of commits found: 30

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
20 Oct 2014 10:41:13
Original commit files touched by this commit  2.5.1_4
Revision:371255
bapt search for other commits by this committer
Cleanup plist
08 Oct 2014 17:16:34
Original commit files touched by this commit  2.5.1_4
Revision:370468
bapt search for other commits by this committer
Convert to USES=pgsql and USES=python
10 Jun 2014 07:39:02
Original commit files touched by this commit  2.5.1_4
Revision:357277
olgeni search for other commits by this committer
Remove indefinite articles and trailing periods from COMMENT, plus
minor COMMENT typos and surrounding whitespace fixes. Categories D-F.

CR:		D196
Approved by:	portmgr (bapt)
24 Jan 2014 19:02:48
Original commit files touched by this commit  2.5.1_4
Revision:340923
mva search for other commits by this committer
- Enable stagedir support
20 Sep 2013 16:13:49
Original commit files touched by this commit  2.5.1_4
Revision:327717
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
08 Jan 2013 07:06:25
Original commit files touched by this commit  2.5.1_4
Revision:310073
bapt search for other commits by this committer
Convert last python@ ports to new options framework
for both make options work as expected (previous version were missing include
<bsd.port.options.mk>)
for databases/py-pyPgSQL reverse the logic for the option test so that it
actually works as expected

Approved by:	python (crees)
22 Oct 2011 23:50:23
Original commit files touched by this commit  2.5.1_4
eadler search for other commits by this committer
- remove maintainer tags from pkg-descr

Approved by:    portmgr
Approved by:    bapt (mentor)
20 Mar 2011 12:54:45
Original commit files touched by this commit  2.5.1_4
miwi search for other commits by this committer
- Get Rid MD5 support
10 Sep 2010 04:18:06
Original commit files touched by this commit  2.5.1_4
pgollucci search for other commits by this committer
PostgreSQL 8.3.1 has changed it's bytea encoding.

* in PostgreSQL 8.3.1 Release note
Make encode(bytea, 'escape') convert all high-bit-set byte values into \nnn
octal escape sequences (Tom)

This is necessary to avoid encoding problems when the database encoding is
multi-byte. This change could pose compatibility issues for applications that
are expecting specific results from encode.

but pyPgSQL escape bytea encode as it's own implementments. PostgreSQL says that
it may make failure(see PQescapeBytea documentation).

in PQescapeBytea function documentation:
"The only difference from PQescapeByteaConn is that PQescapeBytea does not take
a PGconn parameter. Because of this, it cannot adjust its behavior depending on
the connection properties (in particular, whether standard-conforming strings
are enabled) and therefore it might give the wrong results. Also, it has no way
to return an error message on failure."

Patch is included upstream already

PR:             ports/122616
Submitted by:   "Choe, Cheng-Dae" <whitekid@gmail.com>
22 Aug 2009 00:18:43
Original commit files touched by this commit  2.5.1_3
amdmi3 search for other commits by this committer
- Switch SourceForge ports to the new File Release System: categories starting
with D
06 Jun 2008 13:17:10
Original commit files touched by this commit  2.5.1_3
edwin search for other commits by this committer
Bump portrevision due to upgrade of devel/gettext.

The affected ports are the ones with gettext as a run-dependency
according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT
in Makefile (29 of them).

PR:             ports/124340
Submitted by:   edwin@
Approved by:    portmgr (pav)
20 Jun 2007 21:24:22
Original commit files touched by this commit  2.5.1_2
lwhsu search for other commits by this committer
- EXAMPLES should be omitted when NOPORTEXAMPLES is defined

Noticed by:     sat
20 Jun 2007 15:57:27
Original commit files touched by this commit  2.5.1_1
lwhsu search for other commits by this committer
- Honour PKGNAMEPREFIX [1]
- Use DOCSDIR, EXAMPLESDIR in pkg-plist
- Things under EXAMPLESDIR should not be controlled by NOPORTDOCS
- Minor fix to pet portlint(1)
- Grab maintainership for python@
- Bump PORTREVISION

PR:             ports/113876 [1]
Submitted by:   Greg Skafte <skafte AT trollkarl.net>
08 Jul 2006 05:29:20
Original commit files touched by this commit  2.5.1
rafan search for other commits by this committer
- Update to 2.5.1

Approved by:    delphij (mentor, implicit)
24 Nov 2005 01:23:57
Original commit files touched by this commit  2.4_2
pav search for other commits by this committer
- Add SHA256
05 Mar 2005 22:09:34
Original commit files touched by this commit  2.4_2
vs search for other commits by this committer
Reset maintainer on request. Thanks to Gerhard for maintaining the
ports so far!

PR:             ports/78088
31 Jan 2005 00:35:56
Original commit files touched by this commit  2.4_2
girgen search for other commits by this committer
Split the postgresql ports into a server and a client part.

All ports depending on postgresql shall use the USE_PGSQL=yes knob
defined in Mk/bsd.ports.mk. Bumping portrevisions where needed.

PR:             75344
Approved by:    portmgr@ (kris), ade & sean (mentors)
31 Mar 2004 03:12:58
Original commit files touched by this commit  2.4_1
trevor search for other commits by this committer
SIZEify (maintainer timeout)
04 Feb 2004 05:21:48
Original commit files touched by this commit  2.4_1
marcus search for other commits by this committer
Bump PORTREVISION on all ports that depend on gettext to aid with upgrading.

(Part 2)
31 Jul 2003 06:50:03
Original commit files touched by this commit  2.4
daichi search for other commits by this committer
update databases/py-pyPgSQL: 2.3 -> 2.4

PR:             55084
Submitted by:   Gerhard Haering <gh@ghaering.de>
21 Feb 2003 11:15:05
Original commit files touched by this commit  2.3
knu search for other commits by this committer
De-pkg-comment.
04 Jan 2003 16:17:27
Original commit files touched by this commit  2.3
seanc search for other commits by this committer
Missed configure scripts in libpq version bump: chase lib version.
02 Jan 2003 19:28:46
Original commit files touched by this commit  2.3
ijliao search for other commits by this committer
upgrade to 2.3

PR:             46099
Submitted by:   maintainer
05 Oct 2002 23:12:29
Original commit files touched by this commit  2.2
pat search for other commits by this committer
Respect LOCALBASE and remove py-mx-base as a build dependency.
Use tab in place of whitespace as well.

PR:             ports/43570
Submitted by:   maintainer
16 Sep 2002 13:57:56
Original commit files touched by this commit  2.2
ijliao search for other commits by this committer
- update port to pyPgSQL 2.2
- updated maintainer email address
- use REINPLACE instead of PERL

PR:             42560
Submitted by:   maintainer
09 Jun 2002 16:06:47
Original commit files touched by this commit  2.1
pat search for other commits by this committer
Update to 2.1

--
also make a cosmetic change
space -> tabs
INSTALL_MAN -> INSTALL_DATA for installing port docs
perl -> ${PERL}

PR:             39051
Submitted by:   maintainer
29 Apr 2002 13:33:57
Original commit files touched by this commit  2.0
ijliao search for other commits by this committer
use USE_PYDISTUTILS
19 Mar 2002 18:27:05
Original commit files touched by this commit  2.0
petef search for other commits by this committer
Update to work with PostgreSQL 7.2.

PR:             36102
Submitted by:   maintainer
10 Nov 2001 07:01:33
files touched by this commit
nbm search for other commits by this committer
Update of the py-pyPGSQL port to version 2.0.    
02 Nov 2001 15:00:28
files touched by this commit
nbm search for other commits by this committer
Add pyPgSQL, a Python DB-API 2 compliant library for using PostgreSQL  
databases    

Number of commits found: 30

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD

This site
What is FreshPorts?
About the authors
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
otrsDec 16
mod_dav_svnDec 15
subversionDec 15
subversion16Dec 15
subversion17Dec 15
nvidia-driverDec 14
nvidia-driver-173Dec 14
nvidia-driver-304Dec 14
nvidia-driver-71Dec 14
nvidia-driver-96Dec 14
asterisk11Dec 11
bind99Dec 11
xorg-serverDec 10
unboundDec 09
freetype2Dec 07

11 vulnerabilities affecting 47 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds


Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 24437
Broken 139
Deprecated 70
Ignore 394
Forbidden 3
Restricted 206
No CDROM 93
Vulnerable 22
Expired 0
Set to expire 65
Interactive 0
new 24 hours 0
new 48 hours2
new 7 days29
new fortnight54
new month244

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2014 Dan Langille. All rights reserved.