Difference between revisions of "Nspostgres"

From AOLserver Wiki
Jump to navigation Jump to search
 
Line 1: Line 1:
The Postgres driver is largely maintained by the users of the [[OpenACS]].  It includes bind variable emulation
+
The Postgres driver is largely maintained by the users of the [[OpenACS]].   
 +
 
 +
Hi, Jim Lynch here. I'm going to try helping and extending the nspostgres driver.
 +
 
 +
It includes bind variable emulation
 
and other extensions which make it compatible with the [[nsoracle]] driver.
 
and other extensions which make it compatible with the [[nsoracle]] driver.
  
This module lives in AOLserver CVS[http://cvs.sourceforge.net/viewcvs.py/aolserver/nspostgres/].
+
This module lives in AOLserver CVS[http://aolserver.cvs.sourceforge.net/aolserver/nspostgres/] NOTE,
 +
corrected link.
  
 
and can be downloaded from the website: http://sourceforge.net/project/showfiles.php?group_id=3152&package_id=41577
 
and can be downloaded from the website: http://sourceforge.net/project/showfiles.php?group_id=3152&package_id=41577
 +
 +
 +
----
 +
 +
Current as of feb 2007
 +
 +
I've made a few additions to the driver, and I'd like to summarize them here. My
 +
stuff right now only lives in cvs HEAD, given it's only been tested on one or two
 +
arches so far.
 +
 +
- driver has been extended in two ways:
 +
  + build system now allows use of pg_config to get location and all other
 +
    attributes of the specific postgres install to build nspostgres
 +
    against. Also, you can specify which postgres to build against.
 +
    o to build this way, use POSTGRES=PG_CONFIG
 +
    o to specify which postgres to build against, add the path to
 +
      pgconfig like this: PG_CONFIG=/path/to/pg_config
 +
- the information in many of the error messages generated is enhanced
 +
  by the addition of an additional piece of information which is specific
 +
  to postgres. Specifically, most or all calls that include an sql statement
 +
  will also add the postgres-specific status code that cane from the call
 +
  to libpq's PQexec() call, if the call or the driver determines that an
 +
  error condition exists.

Latest revision as of 22:05, 16 February 2007

The Postgres driver is largely maintained by the users of the OpenACS.

Hi, Jim Lynch here. I'm going to try helping and extending the nspostgres driver.

It includes bind variable emulation and other extensions which make it compatible with the nsoracle driver.

This module lives in AOLserver CVS[1] NOTE, corrected link.

and can be downloaded from the website: http://sourceforge.net/project/showfiles.php?group_id=3152&package_id=41577



Current as of feb 2007

I've made a few additions to the driver, and I'd like to summarize them here. My stuff right now only lives in cvs HEAD, given it's only been tested on one or two arches so far.

- driver has been extended in two ways:
  + build system now allows use of pg_config to get location and all other 
    attributes of the specific postgres install to build nspostgres
    against. Also, you can specify which postgres to build against.
    o to build this way, use POSTGRES=PG_CONFIG
    o to specify which postgres to build against, add the path to 
      pgconfig like this: PG_CONFIG=/path/to/pg_config
- the information in many of the error messages generated is enhanced
  by the addition of an additional piece of information which is specific
  to postgres. Specifically, most or all calls that include an sql statement
  will also add the postgres-specific status code that cane from the call
  to libpq's PQexec() call, if the call or the driver determines that an
  error condition exists.