pgadmin add schema/database name automaticaly
От | scharinger@ws-zwo.de |
---|---|
Тема | pgadmin add schema/database name automaticaly |
Дата | |
Msg-id | 5524F59B.3070909@ws-zwo.de обсуждение исходный текст |
Список | pgsql-novice |
Hello, I'm using pgadmin III (1.14.2) on debian wheezy (installed from debian repo). Postgre Version is 9.1 also from debian repo. I have to identical server. I use one for testing and one for productiv work. I create and test SQL-Scripts on the testing machine and after test success I transfer the Scipts to the productiv machine and execute it there. My problem is that on the productiv machine pgadmin adds schema/database name to all tables and in views automaticaly. I don't know how I have triggered this behavior. The table-names in the database "database" on the testmachine are like "table1", "table2" ... The table-names on the productiv machine are like "database.table1", "database.table2". I'm using only lowercase names. When I dump the database on the productiv machine and restore it on the testmachine, everything is ok on the testmachine. The tablenames are then again "table1", "table2" and so on. By this I guess the descibed behavior is triggered by pgadmin? The problem is when I try to execute the scripts from testmachine on the productiv machine I get the error "Error: relation "table1" does not exist" Changing all tablenames in the script to "database.table1", "database.table2" makes the script working on productiv machine. I don't know how I managed to change the naming on productiv machine nor how to switch it back to "normal" state in pgadmin. I googled a lot about this but no result. I viewed all the options in pgadmin but no success. Any help or suggestion? Tx, Werner -- W. Scharinger
В списке pgsql-novice по дате отправления: