From: | gipsy-king1 <stuehle(at)gis-consult(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Function already exists with same argument types |
Date: | 2012-06-12 13:01:34 |
Message-ID: | 1339506094413-5712191.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear all
I want to import a postGIS-DB backup-file.
When I execute this command:
*pg_restore -i -h localhost -p 5432 -U postgres -d THS -v
"<path>/alkis.backup" > "<path2>\output.txt" 2>&1*
I get an textfile with all outputs. There are lots of ERRORs like this:
*pg_restore: erstelle FUNCTION st_geometry_analyze(internal)
pg_restore: [Archivierer (DB)] Fehler in Inhaltsverzeichniseintrag 33; 1255
121878509 FUNCTION st_geometry_analyze(internal) postgres
pg_restore: [Archivierer (DB)] could not execute query: ERROR: function
"st_geometry_analyze" already exists with same argument types
Command was: CREATE FUNCTION st_geometry_analyze(internal) RETURNS
boolean
AS '$libdir/liblwgeom', 'LWGEOM_analyze'
LANGUAGE c ST...*
/I heard that the restore-command will apply all functions a second time. Is
there a possibility to disable this inside the pg_restore-command?
I don't want to delete all function by hand inside the pdAdmin before I'll
execute the pg_restore-command./
best regards,
Thomas
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Function-already-exists-with-same-argument-types-tp5712191.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-06-12 14:18:11 | Re: import *.backup-file (PostGIS - not mine) |
Previous Message | Stefan Schwarzer | 2012-06-12 12:21:23 | Problem installing extensions on Lion |