I have created a new database for the pg_versioning. I created pgvs functions and got this error:
$ psql -d philippines -U **** -h **** -f createFunctions.sql CREATE SCHEMA CREATE TYPE GRANT psql:createFunctions.sql.1:32: NOTICE: CREATE TABLE will create implicit sequence "version_tables_version_table_id_seq" for serial column "version_tables.version_table_id" psql:createFunctions.sql.1:32: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "version_table_pkey" for table "version_tables" CREATE TABLE GRANT CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION psql:createFunctions.sql.1:920: NOTICE: function versions.pgvsreverse(pg_catalog.varchar) does not exist, skipping DROP FUNCTION CREATE FUNCTION The pgadminIII showed the added versions schema but I can't use it in qgis 1.7. On Mon, Nov 8, 2010 at 7:37 PM, maning sambale <[email protected]> wrote: > Sweet! It's working on qgis 1.5 (ubuntu). Will be watching this > plugin. Thanks! > > On Mon, Nov 8, 2010 at 7:13 PM, Düster Horst <[email protected]> wrote: >> I made an update to handle a non existing pgvs in the layers source db. >> Please reinstall the plugin and try again. >> ------------------------------------------------ >> Dr. Horst Düster >> Stv. Amtschef / kantonaler GIS-Koordinator >> Kanton Solothurn >> Bau- und Justizdepartement >> Amt für Geoinformation >> SO!GIS Koordination >> Rötistrasse 4 >> CH-4501 Solothurn >> Telefon ++41(0)32 627 25 32 >> Mobil ++41(0)79 511 54 12 >> Telefax ++41(0)32 627 22 14 >> mailto:[email protected] >> http://www.agi.so.ch >> -----Ursprüngliche Nachricht----- >> Von: [email protected] [mailto:[email protected]] >> Gesendet am: Montag, 8. November 2010 10:58 >> An: Düster Horst >> Cc: postgis-users >> Betreff: Re: Re: [postgis-users] Announcement: PostGIS Versioning System >> pgversion and QGIS Plugin >> On QGIS 1.4 (mac), I overridden the 1.5 warning and continued with the >> install. Plugin manager didn't activate it. >> On qgis 1.5.0 (ubuntu): >> I had to install qtsql. Then the plugin was activated. Tested with >> my test postgis data, I got this error when I used "Prepare layer for >> versioning": >> An error has occured while executing Python code: >> Traceback (most recent call last): >> File "/home/maning/.qgis/python/plugins/pgversion/pgVersion.py", >> line 170, in doInit >> if not self.tools.versionExists(mySchema, myTable): >> File "/home/maning/.qgis/python/plugins/pgversion/pgVersionTools.py", >> line 107, in versionExists >> if len(result["SCHEMA"]) 0: >> KeyError: 'SCHEMA' >> Python version: >> 2.6.5 (r265:79063, Apr 16 2010, 13:28:26) >> [GCC 4.4.3] >> QGIS version: >> 1.5.0-Tethys Tethys, exported >> Python path: ['/usr/share/qgis/python', '/home/maning/.qgis/python', >> '/home/maning/.qgis/python/plugins', '/usr/share/qgis/python/plugins', >> '/usr/local/lib/python2.6/dist-packages/Sphinx-0.6.5-py2.6.egg', >> '/usr/local/lib/python2.6/dist-packages/docutils-0.6-py2.6.egg', >> '/usr/local/lib/python2.6/dist-packages/Jinja2-2.4.1-py2.6.egg', >> '/usr/local/lib/python2.6/dist-packages/Pygments-1.3.1-py2.6.egg', >> '/usr/lib/python2.6', '/usr/lib/python2.6/plat-linux2', >> '/usr/lib/python2.6/lib-tk', '/usr/lib/python2.6/lib-old', >> '/usr/lib/python2.6/lib-dynload', '/usr/lib/python2.6/dist-packages', >> '/usr/lib/python2.6/dist-packages/PIL', >> '/usr/lib/python2.6/dist-packages/gst-0.10', >> '/usr/lib/pymodules/python2.6', >> '/usr/lib/python2.6/dist-packages/gtk-2.0', >> '/usr/lib/pymodules/python2.6/gtk-2.0', >> '/usr/lib/python2.6/dist-packages/wx-2.8-gtk2-unicode', >> '/usr/local/lib/python2.6/dist-packages', >> u'/home/maning/.qgis//python/plugins', >> '/usr/share/qgis/python/plugins/fTools/tools'] >> On Mon, Nov 8, 2010 at 5:21 PM, Düster Horst <[email protected]> wrote: >>> The plugin is marked as experimental and I had set the qgis minimum >>> version >>> to 1.5 due to I tested the plugin with 1.5. I changed the minimum version >>> 1.4. Please try it and give me a responce whether it works. >>> Regards >>> Horst >>> ------------------------------------------------ >>> Dr. Horst Düster >>> Stv. Amtschef / kantonaler GIS-Koordinator >>> Kanton Solothurn >>> Bau- und Justizdepartement >>> Amt für Geoinformation >>> SO!GIS Koordination >>> Rötistrasse 4 >>> CH-4501 Solothurn >>> Telefon ++41(0)32 627 25 32 >>> Mobil ++41(0)79 511 54 12 >>> Telefax ++41(0)32 627 22 14 >>> mailto:[email protected] >>> http://www.agi.so.ch >>> -----Ursprüngliche Nachricht----- >>> Von: maning sambale [mailto:[email protected]] >>> Gesendet am: Montag, 8. November 2010 10:10 >>> An: PostGIS Users Discussion >>> Betreff: Re: [postgis-users] Announcement: PostGIS Versioning System >>> pgversion and QGIS Plugin >>> Nice! What version of QGIS does it use. I added your repoe, but I >>> can't find the plugin in my 1.4 version >>> On Mon, Nov 8, 2010 at 4:08 PM, Javier de la Torre >>> <[email protected]> wrote: >>>> Hi, >>>> Thats great. Congratulations. >>>> One question. If I understand correctly you are using the DB users for >>>> the >>>> versioning. How easy would be to use external users from, for example a >>>> web >>>> system? We normally do not use the users on PostgreSQL for the data >>>> content. >>>> Are you planning something on this direction? >>>> Thanks. >>>> Javier >>>> www.vizzuality.com >>>> >>>> >>>> On Nov 8, 2010, at 8:43 AM, Düster Horst wrote: >>>> >>>> I just finished the first beta version of my newly released pgvs support >>>> system. The idea of this system is to enable the editing of a single >>>> PostGIS >>>> layer concurrently by more than one user at the same time, similar to >>>> source >>>> code versioning systems like CVS or Subversion. You will find further >>>> informations at: >>>> >>>> http://www.kappasys.org/cms/index.php?id=23&L=5 >>>> >>>> You can download the PostGIS functions from: >>>> >>>> http://www.kappasys.ch/pgtools/pgversion/createFunctions.sql >>>> >>>> To get easy access to pgvs I additionally created the QGIS plugin >>>> pgversion >>>> which you can download from: >>>> >>>> http://www.kappasys.org/qgis/plugins.xml >>>> >>>> I know that not all features of a SVN like system are implemented yet. >>>> But >>>> I >>>> would like to get your comments and ideas for further developements. >>>> >>>> I hope that pgvs can make your life easier. >>>> >>>> Regards >>>> >>>> Horst >>>> >>>> ------------------------------------------------ >>>> >>>> Dr. Horst Düster >>>> Stv. Amtschef / kantonaler GIS-Koordinator >>>> >>>> Kanton Solothurn >>>> Bau- und Justizdepartement >>>> Amt für Geoinformation >>>> SO!GIS Koordination >>>> Rötistrasse 4 >>>> CH-4501 Solothurn >>>> >>>> Telefon ++41(0)32 627 25 32 >>>> Mobil ++41(0)79 511 54 12 >>>> Telefax ++41(0)32 627 22 14 >>>> >>>> mailto:[email protected] >>>> http://www.agi.so.ch >>>> >>>> >>>> _______________________________________________ >>>> postgis-users mailing list >>>> [email protected] >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>> >>>> >>>> _______________________________________________ >>>> postgis-users mailing list >>>> [email protected] >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>> >>>> >>> -- >>> cheers, >>> maning >>> ------------------------------------------------------ >>> "Freedom is still the most radical idea of all" -N.Branden >>> wiki: http://esambale.wikispaces.com/ >>> blog: http://epsg4253.wordpress.com/ >>> ------------------------------------------------------ >>> _______________________________________________ >>> postgis-users mailing list >>> [email protected] >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >> -- >> cheers, >> maning >> ------------------------------------------------------ >> "Freedom is still the most radical idea of all" -N.Branden >> wiki: http://esambale.wikispaces.com/ >> blog: http://epsg4253.wordpress.com/ >> ------------------------------------------------------ > > > > -- > cheers, > maning > ------------------------------------------------------ > "Freedom is still the most radical idea of all" -N.Branden > wiki: http://esambale.wikispaces.com/ > blog: http://epsg4253.wordpress.com/ > ------------------------------------------------------ > -- cheers, maning ------------------------------------------------------ "Freedom is still the most radical idea of all" -N.Branden wiki: http://esambale.wikispaces.com/ blog: http://epsg4253.wordpress.com/ ------------------------------------------------------ _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
