hi peter, thanks for considering postgis.
i will consider all other reports too. i understand the ambiguity. in order to make the template_gis for pere should have run mktemplate_gis --user=pere. alex On Sat, 2005-05-21 at 17:40 +0200, Petter Reinholdtsen wrote: > Package: libpostgis1-pg74 > Version: 1.0.0-1 > Severity: normal > > When I as the postgres user create a new postgis database using the > --owner flag to set the initial owner of the database, the tables > created are still owned by the postgres user. I believe it would be > more correct to make sure the table owner is the suer listed as the > datbase owner. > > [EMAIL PROTECTED]:~$ createdb.postgis --owner pere pere_gis > CREATE DATABASE > [EMAIL PROTECTED]:~$ logout > # su - pere > % psql pere_gis > Welcome to psql 7.4.7, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help on internal slash commands > \g or terminate with semicolon to execute query > \q to quit > > pere_gis=> \d > List of relations > Schema | Name | Type | Owner > --------+------------------+-------+---------- > public | geometry_columns | table | postgres > public | spatial_ref_sys | table | postgres > (2 rows) > > I was unable to use the database because of this. I solved it by > running these PostgresSQL commands as the postgres user: > > [EMAIL PROTECTED]:~$ psql pere_gis > [...] > pere_gis=# ALTER TABLE geometry_columns OWNER TO pere; > ALTER TABLE > pere_gis=# ALTER TABLE spatial_ref_sys OWNER TO pere; > ALTER TABLE > pere_gis=# > > Perhaps the script should be updated to run these commands when the > --owner option is used? > > - System Information: > Debian Release: 3.1 > APT prefers testing > APT policy: (500, 'testing') > Architecture: i386 (i686) > Kernel: Linux 2.4.27-1-686 > Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) > > Versions of packages libpostgis1-pg74 depends on: > ii libc6 2.3.2.ds1-21 GNU C Library: Shared libraries > an > ii libgcc1 1:3.4.3-12 GCC support library > ii libgeos2 2.1.1-2 Geometry engine for Geographic > Inf > ii libpq3 7.4.7-6 PostgreSQL C client library > ii libstdc++5 1:3.3.5-12 The GNU Standard C++ Library v3 > ii postgresql 7.4.7-6 object-relational SQL database > man > ii postgresql-contrib 7.4.7-6 additional facilities for > PostgreS > ii proj 4.4.9-1 Cartographic projection filter > and > ii sudo 1.6.8p7-1.1 Provide limited super user > privile > > -- no debconf information > > -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
