My troubles with test PostgreSQL 8.1
Yaroslav Kavenchuk <[email protected]> Wed, 09 Nov 2005 22:25:46 +0200
| Newsgroups | gmane.lisp.clsql.devel |
|---|---|
| Message-ID | <[email protected]> |
some troubles with test postgresql 8.1 under windows:
1. On attempt to drop database ask password for current user (not for
user from specs). May be need set db-backend-has-create/destroy-db? to nil?
current user not have rights to drop/create database usually (may be
even for connect :)
2. truncate-database:
*** - While accessing database #<POSTGRESQL-DATABASE
localhost/test/postgres OPEN #x19FBFB5D>
with expression "DROP VIEW table_privileges":
Error 7 / view "table_privileges" does not exist
has occurred.
(list-views :database database)
("table_privileges" "tables" "triggered_update_columns" "triggers"
"usage_privileges"
"view_column_usage" "view_table_usage" "views" "data_type_privileges"
"element_types" "schemata"
"table_constraints" "constraint_column_usage" "constraint_table_usage"
"domain_constraints"
"domain_udt_usage" "domains" "enabled_roles" "key_column_usage"
"parameters"
"referential_constraints" "role_column_grants" "role_routine_grants"
"role_table_grants"
"role_usage_grants" "routine_privileges" "routines" "pg_indexes"
"pg_stats" "pg_locks"
"pg_prepared_xacts" "pg_stat_all_tables" "pg_stat_sys_tables"
"pg_stat_user_tables"
"pg_statio_all_tables" "pg_statio_sys_tables" "pg_statio_user_tables"
"pg_stat_all_indexes"
"pg_stat_sys_indexes" "pg_stat_user_indexes" "pg_shadow"
"pg_statio_all_indexes"
"pg_statio_sys_indexes" "pg_statio_user_indexes" "pg_statio_all_sequences"
"pg_statio_sys_sequences" "pg_statio_user_sequences" "pg_stat_activity"
"pg_stat_database"
"information_schema_catalog_name" "applicable_roles"
"check_constraints" "column_domain_usage"
"column_privileges" "column_udt_usage" "pg_settings" "columns"
"pg_roles" "pg_group" "pg_user"
"pg_rules" "pg_views" "pg_tables")
this all system views
I not advance further
Thanks!
--
WBR, Yaroslav Kavenchuk.