[Qgis-developer] errors in pgversion

[Horst Düster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Am 03.01.2011 18:06, schrieb Paolo Cavallini:
> Hi all.
> When preparing a db for versioning, I get:
> 
> .qgis/python/plugins/pgversion/tools/updateFunctions.sql
> 
> psql:/home/paolo/.qgis/python/plugins/pgversion/tools/updateFunctions.sql:20: ERROR:  schema "versions" does not exist
> 
> So I think a
> CREATE SCHEMA versions;
> is missing from the script.
> 
> All the best

Hi Paolo

To initialize pgversion in a database you have to run the
createFunctions.sql script. This script will install all nesseccary
views, schemas and functions. Have a look at:

http://www.kappasys.ch/cms/index.php?id=23&MP=23-11#toc5

The updateFunctions.sql script only updates an existing pgversion
installation. There is no need to create a schema versions due to it
exeists already.

Regrads
Horst
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJNIv7xAAoJENJq1wkKM7pSvYcIAKA83xAL9X5EjDeAC+RIQia7
K0k1maUalIGMTrW7riYdrQ3bsbtXZUNZ1jdw4rhZ9UEdiUdLGsLjKlSvldvGCVZz
YWVBQropJ6q7YGBNV93FwXvSMe8zsLhsVRSWnjLhERp6KrgvMkPOoFQUZtio6xRN
hq5QpTp/Bx/jJzqyrO07lufRXIAytGzl9zXL/Cjp/cJEgyk4HBgOTgI0hisbRmsA
D4+njPOF7E6X8Y6dCJW2sdNGIuxE4EZLkwUIBpLjGiG0lZimgcqbuHMBjxbNW7qL
YM+9AsfYX3C1evmwUSRvdoQ7jCbmqTa/x2MP6oqUtDHYKLDrodNgQJUa34rE1VY=
=0ZCq
-----END PGP SIGNATURE-----