Hi Stephan,
Creating new columns works for me on my testdatabase. I entered a new ticket
in the bug tracker for further examination.
Regards,
Marco
On Friday 18 May 2007 12:50:12 Stephan Holl wrote:
> 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
--
Dr. Marco Hugentobler
Institute of Cartography
ETH Zurich
[EMAIL PROTECTED]
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user
