pgadmin add schema/database name automaticaly

From: "scharinger(at)ws-zwo(dot)de" <scharinger(at)ws-zwo(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: pgadmin add schema/database name automaticaly
Date: 2015-04-08 09:32:11
Message-ID: 5524F59B.3070909@ws-zwo.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Rafat Qubaj 2015-04-09 05:11:14 PostgreSQL 8.4
Previous Message Alexandre Delanoë 2015-04-01 15:49:09 Re: From hstore to jsonb (type of column)