Hello *,
Trying to add a column to a postgis-table. This seems to work as
expected inside the
GUI, but after deleting the layer, reload it, the column does not
appear.
in psql the column is not there ether.
This is the output inside the console during the creation-process:
Debug: qgspostgresprovider.cpp: 881: (reset) Setting up binary cursor:
declare qgisf binary cursor for select "gid",asbinary("the_geom",'NDR')
as qgs_feature_geometry from "public"."gewaesserflaechen"
Debug: qgsmaplayer.cpp: 127: (name) QgsMapLayer::name: returning name
'gewaesserflaechen
Warning: inserting attribute testcolumn of type double precision
Warning: numCols: 7
WARNING: there is already a transaction in progress
Debug: qgspostgresprovider.cpp: 881: (reset) Setting up binary cursor:
declare qgisf binary cursor for select "gid",asbinary("the_geom",'NDR')
as qgs_feature_geometry from "public"."gewaesserflaechen"
WARNING: there is no transaction in progress
WARNING: there is already a transaction in progress Debug:
qgspostgresprovider.cpp: 1992: (addAttributes)
ALTER TABLE "public"."gewaesserflaechen" ADD COLUMN testcolumn double
precision
Debug: qgspostgresprovider.cpp: 881: (reset) Setting up
binary cursor: declare qgisf binary cursor for select
"gid",asbinary("the_geom",'NDR') as qgs_feature_geometry from
"public"."gewaesserflaechen"
WARNING: there is no transaction in progress
WARNING: there is already a transaction in progress
Debug: qgspostgresprovider.cpp: 881: (reset) Setting up binary cursor:
declare qgisf binary cursor for select "gid",asbinary("the_geom",'NDR')
as qgs_feature_geometry from "public"."gewaesserflaechen"
WARNING: there is no transaction in progress
Is this a problem in the configuration of the postgres-server or inside
QGIS?
This is tested with qgis 0.8.0 and checkout of release
0.8.0-branch against
postgis_full_version
-------------------------------------------------------------------------------------
POSTGIS="1.2.1" GEOS="3.0.0rc4-CAPI-1.3.3" PROJ="Rel. 4.5.0, 22 Oct
2006" USE_STATS
Thanks for any tips.
Best
Stephan
--
Stephan Holl <[EMAIL PROTECTED]>, http://intevation.de/~stephan
Tel: +49 (0)541-33 50 8 32 | Intevation GmbH | AG Osnabrück - HR B 18998
Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user
