[postgis-users] How to setup a versioned datastore?

[George Silva]

I'm sorry, I don't know german. Can't help you with that.

For what I could understand is that the relation


> uberschwemmungsgebiete existiert nicht


doest not exist. Are you sure the table exists?

It should work, my current version works.

If you can translate the error would be nice :P

I'll run other tests here. Please let me know.

George

On Wed, Aug 4, 2010 at 4:46 AM, Dominik Wiedner <DominikWiedner at web.de>wrote:

> Hi,
>
> I also downloaded the extension and managed to install it within the target
> database. But when I attempt to enable the target-table, I get the following
> error:
>
> HINWEIS: CREATE TABLE erstellt implizit eine Sequenz
> »uberschwemmungsgebiete_h
> istory_history_id_seq« für die »serial«-Spalte
> »uberschwemmungsgebiete_hist
> ory.history_id«
>
> KONTEXT: SQL-Anweisung »CREATE TABLE
> public.Uberschwemmungsgebiete_history(history_id serial not null,date_added
> timestamp not null default now(),date_deleted
> timestamp default null,last_operation varchar(30) not null,active_user
> varchar(90) not null default CURRENT_USER,current_version text not null,like
> public.Uberschwemmungsgebiete,CONSTRAINT Uberschwemmungsgebiete_history_pk
> primary key(history_id));«
>
> PL/pgSQL function "postgis_enable_history" line 66 at EXECUTE-Anweisung
> FEHLER: Relation »public.uberschwemmungsgebiete« existiert nicht <<<<
> This is the error I mean, since the table has the schema "public".
> ZEILE 1: ...t CURRENT_USER,current_version text not null,like public.Ube...
> ^
> ANFRAGE: CREATE TABLE public.Uberschwemmungsgebiete_history(history_id
> serial not null,date_added timestamp not null default now(),date_deleted
> timestamp default null,last_operation varchar(30) not null,active_user
> varchar(90) not null default CURRENT_USER,current_version text not null,like
> public.Uberschwemmungsgebiete,CONSTRAINT Uberschwemmungsgebiete_history_pk
> primary key(history_id));
>
> KONTEXT: PL/pgSQL function "postgis_enable_history" line 66 at
> EXECUTE-Anweisung
>
> Any hints?
>
> Regards,
> Dominik
> _______________________________________________
> postgis-users mailing list
>
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
George R. C. Silva

Desenvolvimento em GIS
http://blog.geoprocessamento.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100804/c8d9dcea/attachment.html>