Your message dated Tue, 01 Aug 2006 10:35:59 +0200 with message-id <[EMAIL PROTECTED]> and subject line Closing old bug reports has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database)
--- Begin Message ---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
--- End Message ---
--- Begin Message ---Version: 1.1.2-1 I'm closing both #310101 and #310100, they refer to old postgis versions and are no more applicable to postgis as packaged in testing/unstable. Thanks, -- Fabio Tranchitella <[EMAIL PROTECTED]> .''`. Proud Debian GNU/Linux developer, admin and user. : :' : `. `'` http://people.debian.org/~kobold/ `- _____________________________________________________________________ 1024D/7F961564, fpr 5465 6E69 E559 6466 BF3D 9F01 2BF8 EE2B 7F96 1564
signature.asc
Description: Questa รจ una parte del messaggio firmata digitalmente
--- End Message ---
_______________________________________________ Pkg-grass-devel mailing list [email protected] http://lists.alioth.debian.org/mailman/listinfo/pkg-grass-devel
