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