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.