databases/virtualpg: Update to 2.0.0
- Add pkg-plist
- Update description
Short summary of differences between earlier versions and v2:
- Now VirtualPG is available as both a standard C/C++ library (libvirtualpg)
and a dynamic extension module to SQLite (mod_virtualpg).
- Now the user can freely choose his/her preferred format for DATE / TIME /
TIMESTAMP values.
- Transactions (BEGIN / COMMIT / ROLLBACK) are now fully honoured also on the
PostgreSQL side.
- Write operations (INSER / UPDATE / DELETE) are now allowed only if the
PostgreSQL user has the corresponding GRANT permissions.
- Write operations can be enabled only for PostgreSQL Tables explicitly
declaring a PRIMARY KEY.
VirtualPG is a loadable dynamic extension to both SQLite and SpatiaLite.
Its intended scope is supporting direct SQL access to PostgreSQL and PostGIS own
tables, so to make any possible kind of data exchange between these two popular
open source Spatial DBMSes as straightforward and simple as possible.
WWW: http://www.gaia-gis.it/fossil/virtualpg/index
PR: 197261
Submitted by: Loic BARTOLETTI <coder@tuxfamily.org>