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]
