[Bug 757094] New: Application:Geo/postgis2: Bug
https://bugzilla.novell.com/show_bug.cgi?id=757094 https://bugzilla.novell.com/show_bug.cgi?id=757094#c0 Summary: Application:Geo/postgis2: Bug Classification: openSUSE Product: openSUSE.org Version: unspecified Platform: 64bit OS/Version: openSUSE 12.1 Status: NEW Severity: Major Priority: P5 - None Component: 3rd party software AssignedTo: opensuse@dstoecker.de ReportedBy: sault.don@gmail.com QAContact: opensuse-communityscreening@forge.provo.novell.com Found By: Community User Blocker: --- I created a template_postgis database with postgis and postgis_topology installed: createdb -T template1 template_postgis psql template_postgis -c "CREATE EXTENSION postgis;" psql template_postgis -c "CREATE EXTENSION postgis_topology;" When I enter the template_postgis database, postgis and postgis_topology are installed and enabled: psql template_postgis -c "SELECT Postgis_full_version();" runs fine with no errors. When I create a new database from template_postgis, it loses it's topology functions: createdb -T template_postgis postgis_new psql postgis_new -c "SELECT Postgis_full_version();" says that postgis_topology_utilities or something isn't installed! It isn't until I re-enable with EXTENSION that it works again: psql postgis_new -c "CREATE EXTENSION postgis_topology;" -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=757094
https://bugzilla.novell.com/show_bug.cgi?id=757094#c1
--- Comment #1 from Donovan Cameron
https://bugzilla.novell.com/show_bug.cgi?id=757094
https://bugzilla.novell.com/show_bug.cgi?id=757094#c
Dirk Stoecker
https://bugzilla.novell.com/show_bug.cgi?id=757094
https://bugzilla.novell.com/show_bug.cgi?id=757094#c2
Angelos Tzotsos
https://bugzilla.novell.com/show_bug.cgi?id=757094
https://bugzilla.novell.com/show_bug.cgi?id=757094#c
Angelos Tzotsos
https://bugzilla.novell.com/show_bug.cgi?id=757094
https://bugzilla.novell.com/show_bug.cgi?id=757094#c3
Angelos Tzotsos
https://bugzilla.novell.com/show_bug.cgi?id=757094
https://bugzilla.novell.com/show_bug.cgi?id=757094#c4
--- Comment #4 from Donovan Cameron
https://bugzilla.novell.com/show_bug.cgi?id=757094
https://bugzilla.novell.com/show_bug.cgi?id=757094#c5
--- Comment #5 from Donovan Cameron
This functionality is now added to the main package. Topology and raster support enabled. Thanks for reporting this.
Angelos
Hey Angelos, I got back to trying this out today and noticed that the error is still present - exactly as I've described originally with one change now. That change being, that I can no longer re-insert the postgis_topology extension when it is not found with "SELECT postgis_full_version();" Command: postgres@indigenis:~> psql postgis_new -c "CREATE EXTENSION postgis_topology;" ERROR: extension "postgis_topology" already exists But it doesn't exist! The database 'postgis_new' does not have it carried over from my template_postgis which has the extensions loaded and running fine. Any ideas before I re-open this ticket? Not sure if this is a problem specific to my system, but I've re-installed both postgresql and postgis2 but to no avail. Same errors. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=757094
https://bugzilla.novell.com/show_bug.cgi?id=757094#c6
--- Comment #6 from Donovan Cameron
https://bugzilla.novell.com/show_bug.cgi?id=757094
https://bugzilla.novell.com/show_bug.cgi?id=757094#c7
--- Comment #7 from Angelos Tzotsos
participants (1)
-
bugzilla_noreply@novell.com