[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 <sault.don@gmail.com> 2012-04-13 19:39:24 UTC --- The error that is returned from 'SELECT postgis_full_version();' is: NOTICE: Function postgis_topology_scripts_installed() not found. Is topology support enabled and topology.sql installed? That error shows on a database that was created from a template. The template has postgis and postgis_topology enabled. -- 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#c Dirk Stoecker <opensuse@dstoecker.de> changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|opensuse@dstoecker.de |tzotsos@gmail.com -- 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#c2 Angelos Tzotsos <tzotsos@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |tzotsos@gmail.com --- Comment #2 from Angelos Tzotsos <tzotsos@gmail.com> 2012-04-20 18:02:13 UTC --- The build configuration is done without --with-topology at the moment. I am going through with some testing with dependencies. -- 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#c Angelos Tzotsos <tzotsos@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED -- 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#c3 Angelos Tzotsos <tzotsos@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED --- Comment #3 from Angelos Tzotsos <tzotsos@gmail.com> 2012-04-21 16:13:20 UTC --- This functionality is now added to the main package. Topology and raster support enabled. Thanks for reporting this. Angelos -- 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#c4 --- Comment #4 from Donovan Cameron <sault.don@gmail.com> 2012-04-21 16:19:16 UTC --- You're the best Angelos, thanks for taking time to apply the changes. -- 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#c5 --- Comment #5 from Donovan Cameron <sault.don@gmail.com> 2012-05-05 19:51:53 UTC --- (In reply to comment #3)
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 <sault.don@gmail.com> 2012-05-05 20:15:08 UTC --- I have to create any new databases from scratch without a template and can then successfully insert postgis and postgis_topology: createdb postgis_new -O saultdon psql postgis_new -c "CREATE EXTENSION postgis;" psql postgis_new -c "CREATE EXTENSION postgis_topology;" I believe now that this error is due to the ROLES or SCHEMA privileges... I created a new role: CREATE ROLE saultdon LOGIN CREATEDB; As postgres user: CREATE DATABASE template_postgis TEMPLATE template1; CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology; SELECT postgis_full_version(); # WORKS! Now, here is the part where I am confused: As postgres user, make a new database for ROLE saultdon from template: CREATE DATABASE postgis_new TEMPLATE template_postgis OWNER saultdon; As postgres user, postgis_full_version() for database postgis_new reports everything normal. So that's nice! When I access the postgis_new database from user saultdon: SELECT postgis_full_version(); #ERROR! NOTICE: Function postgis_topology_scripts_installed() not found. Is topology support enabled and topology.sql installed? CREATE EXTENSION postgis_topology; #ERROR! ERROR: extension "postgis_topology" already exists I am thinking this is because the database user saultdon has unprivileged access to the 'topology schema'! As user saultdon in database postgis_new: postgis_new=> \dn List of schemas Name | Owner ----------+---------- gis | saultdon public | postgres topology | postgres (3 rows) I am not sure where to proceed from here, so I will most likely post in the postgis mailing list for further troubleshooting as these errors are most likely due to my lack of understanding in postgresql database administration. -- 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#c7 --- Comment #7 from Angelos Tzotsos <tzotsos@gmail.com> 2012-05-06 22:24:55 UTC --- Hi, I agree posting to postgis mailing list on this matter. I will follow this thread too. Thanks -- 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.
participants (1)
-
bugzilla_noreply＠novell.com